SQL SERVER – Creating Multiple Backup Files – Stripped

One of my long-term clients (Comprehensive Database Performance Health Check) recently asked me question if I know a way of creating multiple backup files for one backup files. Of course, there is a way and it is a very easy way. Let us learn it today.

SQL SERVER - Creating Multiple Backup Files - Stripped backupfiles-800x541


Creating Multiple Backup Files

It is very easy to take one backup and split it and distribute it. At the same time, it is equally easy to take multiple backups files from SQL Server itself. There are two different ways to do it. One via SSMS and another via T-SQL. Let us learn both of them here.


In SSMS, right-click on the database, go to tasks and select the option backup. Over here is the destination where you can provide multiple locations where you want to take backup. On the screen, I have provided the same directory but you can also select another directory as well.

SQL SERVER - Creating Multiple Backup Files - Stripped backupcopies

Well, that’s it. It is that simple.


If you want to do that with T-SQL, here is the script.

DISK = N'D:\data\backup1.bak',
DISK = N'D:\data\backupcopy.bak'

Let me know if you want me to create a video on this topic or not on backup files. Remember, here you are splitting one file into multiple files and you will need all the files to restore your backup. 

Here are my few recent videos and I would like to know what is your feedback about them. You can subscribe to my youtube channel here.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Backup, SQL Restore, SQL Server, SQL Server Management Studio, SSMS
Previous Post
SQL SERVER – AlwaysOn and Propagation of Compatibility Level
Next Post
Multiple Backup Copies Stripped – SQL in Sixty Seconds #156

Related Posts

3 Comments. Leave new

  • Dear Pinal, I consider name second file as “copy” inappropriate…it’s not a copy, it’s another part of the backup.

  • Any chance there is a secret command when setting up multiple file backup in the Maintenance Plans so that the files would be unique like when doing single file backup? ( date and ID )


Leave a Reply