--完全备份
DECLARE @strPath NVARCHAR(200)
set
@strPath = convert(NVARCHAR(19),getdate(),120)
set @strPath =
REPLACE(@strPath, ':' , '.')
set @strPath = 'E:\datebak\' +
+ '.bak'
BACKUP DATABASE [drpdb] TO DISK = @strPath WITH NOINIT ,
NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
--差异备份
DECLARE @strPath NVARCHAR(200)
set
@strPath = convert(NVARCHAR(19),getdate(),120)
set @strPath =
REPLACE(@strPath, ':' , '.')
set @strPath = 'E:\datebak\' +
+ '.bak'
BACKUP DATABASE [drpdb] TO DISK = @strPath with
format,differential
--恢复
restoredatabasedrpdb fromdisk='E:\backup\drpdb_full_2010-09-26
02.00.00.bak' withnorecovery, replace
restoredatabasedrpdb fromdisk='E:\backup\drpdb_incrment_2010-09-30
02.00.00.bak' withrecovery
restoreheaderonlyfrombak1restoredatabased1frombak1withfile=2--从完全备份中恢复----------------------------------------------------------------------restoreheaderonlyfrombak2--从差异备份中恢复restoredatabased2frombak2withfile=1,norecoveryrestoredatabased2frombak2withfile=5,recovery----------------------------------------------------------------------restoreheaderonlyfrombak3--从日志备份中恢复restoredatabased3frombak3withfile=1,norecoveryrestorelogd3frombak3withfile=2,norecoveryrestorelogd3frombak3withfile=3,norecoveryrestorelogd3frombak3withfile=4,norecoveryrestorelogd3frombak3withfile=5,recovery