Search This Blog

Showing posts with label Split backups in SQL Server. Show all posts
Showing posts with label Split backups in SQL Server. Show all posts

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 SQL server engine creates multiple backup files with the size split into the number of files mentioned in the backup command.
?
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 = 10
GO

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.