Split backups in SQL Server
Split backup is a method of performing the backups on a SQL Server database to multiple files .
When we perform the split backups on a database, the SQLserver engine creates multiple backup files with the size split into the number of files mentioned in the backup command.
When we perform the split backups on a database, the SQL
1
2
3
4
5
| BACKUP DATABASE [SansSQL] TO DISK = N'D:\Backup\SansSQL_Part1_Backup.bak' ,DISK = N'D:\Backup\SansSQL_Part2_Backup.bak'WITH INIT, STATS = 10GO |
When you execute backup command like above then the backup of that particular database will be split into 2 different files of almost equal size.
This can be used with Full, Differential and Log backups as well.
