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.
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.
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.
1 comment:
I like this blog layout . How do you make it? Its so sweet! https://royalcbd.com/product/cbd-roll-on-gel/
Post a Comment