Multiple Backup Files of the SQL Server database with SSMS and T-SQL

Introduction

In this article, we will learn a simple tip to take multiple backup files of one Database. Sometime we may need more than one copy of a backup file in different file location and we can achieve that in two ways, either using T-SQL Query or using SSMS.

T-SQL Statement

BACKUP DATABASE [PracticalWorks] TO
DISK=N'D:\DBBackup\BackupCopy1.bak',
DISK=N'D:\DBBackup\BackupCopy2.bak'

I have a database called PracticalWorks, and by writing Multiple DISK locations in the Backup T-SQL query, we can take multiple backup files of one Database.

SSMS

Right-click on the database, go to tasks and select the option backup. In the destination session we can provide multiple locations where we want to keep the backup file.

Fig.1 Go to Backup option on Tasks option

Fig.2 Provide the disk location to backup

Conclusion

In this article, we have discussed the two ways to take multiple backup copies of one database. I hope you all found this tip much useful. Lets learn some other tips and tricks in upcoming articles. Please share your feedback in the comment section.

Consider reading other SQL articles of Mine

• Difference between CURRENT_TIMESTAMP vs GETDATE() vs SYSDATETIME() vs GETUTCDATE() in SQL Server
• Change Schema Name of Table in MS SQL Server
• Identifying object dependencies in SQL Server using SP_DEPENDS
• Select Names Starting With Vowels in MS SQL Server
• Display Line Numbers in a SQL Server Management Studio Query Window (SSMS)