Wednesday, 25 March 2015

Backup Split - Scripts

BACKUP DATABASE DBNAME TO
DISK = 'E:\TEMP\DBNAME_SPLIT1.BAK',
DISK = 'E:\TEMP\DBNAME_SPLIT2.BAK',
DISK = 'E:\TEMP\DBNAME_SPLIT3.BAK'
,DISK = 'E:\TEMP\DBNAME_SPLIT4.BAK'
,DISK = 'E:\TEMP\DBNAME_SPLIT5.BAK'
,DISK = 'E:\TEMP\DBNAME_SPLIT6.BAK'
,DISK = 'E:\TEMP\DBNAME_SPLIT7.BAK'
,DISK = 'E:\TEMP\DBNAME_SPLIT8.BAK'
,DISK = 'E:\TEMP\DBNAME_SPLIT9.BAK'
,DISK = 'E:\TEMP\DBNAME_SPLIT10.BAK'
WITH COMPRESSION, INIT, STATS=1

GO

No comments:

Post a Comment