SQLServer Backup & Restore

1.Full Backup

BACKUP DATABASE [zsyydb] TO DISK=N'\\192.0.33.222\Backup\zsyydb.bak'
WITH NOFORMAT,NOINIT,NAME=N'zsyydb-full',SKIP,NOREWIND,NOUNLOAD,STATS=5
GO

2.Full Restore

RESTORE DATABASE [zsyydb] FROM DISK=N'D:\backup\zsyydb.bak' WITH FILE=1,REPLACE,
MOVE N'zsyydb'TO N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\zsyydb.mdf',
MOVE N'HistoryData'TO N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\HistoryData.ndf',
MOVE N'UnConfirm2013'TO N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\UnConfirm2013.ndf',
MOVE N'zsyylog'TO N'T:\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\zsyydb.ldf',
MOVE N'zsyylog_1'TO N'T:\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\zsyydb1.ldf',
NORECOVERY,NOUNLOAD,STATS= 5
GO

3.Diff Backup

BACKUP DATABASE [zsyydb] TO DISK=N'\\192.0.33.222\Backup\zsyydb01.bak'
WITH DIFFERENTIAL,NOFORMAT,NOINIT,NAME=N'zsyydb-差异数据库备份',SKIP,NOREWIND,NOUNLOAD,STATS=5
GO

4.Diff Restore

RESTORE DATABASE [zsyydb] FROM DISK=N'D:\backup\zsyydb01.bak' WITH FILE= 1,REPLACE,
MOVE N'zsyydb'TO N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\zsyydb.mdf',
MOVE N'HistoryData'TO N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\HistoryData.ndf',
MOVE N'UnConfirm2013'TO N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\UnConfirm2013.ndf',
MOVE N'zsyylog'TO N'T:\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\zsyydb.ldf',
MOVE N'zsyylog_1'TO N'T:\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\zsyydb1.ldf',
NOUNLOAD,STATS=5
GO