Saturday , March 2 2024

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“.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *