Site icon Database Tutorials

How To Split SQL Server Backup Files To Different Disks

 

If you are not using any backup software, you may not be able to back up large databases to a single disk. In such a case, you can split the backup with the following script.

The script takes the backup to 20 different disks in 20 parts, and then verify the backup using these files.

“M” is the name of our mounted drive. “Disk01, Disk02” shows the mounted disks.  You can find detailed information about Mounted Drive in my article “What is Mounted Drive and How to Create It“.

Exit mobile version