Monday 30 May 2011

SPLIT BACKUP

BACKUP DATABASE [ABC] TO 
DISK = N'E:\MSSQL\BACKUP\ABC\ABC1.BAK',
DISK = N'E:\MSSQL\BACKUP\ABC\ABC2.BAK',
DISK = N'E:\MSSQL\BACKUP\ABC\ABC3.BAK'
WITH  INIT ,  NOUNLOAD ,  NAME = N'ABC backup',  SKIP ,  STATS = 10,  DESCRIPTION = N'Backup ABC Full',  NOFORMAT

No comments:

Post a Comment