Skip to main content

SQL Server Backup to multiple files (file size is different)

Please Use this Script to Backup your db in 10 files

BACKUP DATABASE [Databas_Name] TO
DISK = 'C:\MSSQL_Backup\Database_FileName1.bak',
DISK = 'C:\MSSQL_Backup\Database_FileName2.bak',
DISK = 'C:\MSSQL_Backup\Database_FileName3.bak',
DISK = 'C:\MSSQL_Backup\Database_FileName4.bak',
DISK = 'C:\MSSQL_Backup\Database_FileName5.bak',
DISK = 'C:\MSSQL_Backup\Database_FileName6.bak',
DISK = 'C:\MSSQL_Backup\Database_FileName7.bak',
DISK = 'C:\MSSQL_Backup\Database_FileName8.bak',
DISK = 'C:\MSSQL_Backup\Database_FileName9.bak',
DISK = 'C:\MSSQL_Backup\Database_FileName10.bak'
WITH INIT , NOUNLOAD , NAME = 'Databas_Name backup', NOSKIP , STATS = 10, NOFORMAT



 

Comments