34,588
社区成员
发帖
与我相关
我的任务
分享
BACKUP DATABASE AdventureWorks2008R2
TO DISK='X:\SQLServerBackups\AdventureWorks2008R2_1a.bak',
DISK='Y:\SQLServerBackups\AdventureWorks2008R2_2a.bak',
DISK='Z:\SQLServerBackups\AdventureWorks2008R2_3a.bak'
MIRROR TO DISK='X:\SQLServerBackups\AdventureWorks2008R2_1b.bak',
DISK='Y:\SQLServerBackups\AdventureWorks2008R2_2b.bak',
DISK='Z:\SQLServerBackups\AdventureWorks2008R2_3b.bak';
GO
BACKUP DATABASE [msdb]
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\db_backup_201209062157.bak' --修改成你指定保存的路径
WITH NOFORMAT, NOINIT, NAME = N'db_backup_20120906215741', SKIP, REWIND, NOUNLOAD, STATS = 10