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


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


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.


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


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

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Website Built with

Up ↑

%d bloggers like this: