sqlserver备份到linux,SQLSERVER 备份与恢复

--完全备份

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