MSDN上的数据库还原和备份

USE master;
--Make sure the database is using the simple recovery model.
--确保数据库是使用简单恢复模式
ALTER DATABASE nw_ilux SET RECOVERY SIMPLE;
GO
-- Back up the full AdventureWorks database.
--备份全部AdventureWorks数据库。
BACKUP DATABASE AdventureWorks TO DISK = 'Z:\SQLServerBackups\AdventureWorks.bak' 
  WITH FORMAT;
GO
--Create a differential database backup.
--创建一个微分数据库备份。
BACKUP DATABASE AdventureWorks TO DISK = 'Z:\SQLServerBackups\AdventureWorks.bak'
   WITH DIFFERENTIAL;
GO
--Restore the full database backup (from backup set 1).
--恢复完整的数据库备份(从备份集1)。
RESTORE DATABASE AdventureWorks FROM DISK = 'Z:\SQLServerBackups\AdventureWorks.bak' 
   WITH FILE=1, NORECOVERY;
--Restore the differential backup (from backup set 2).
--恢复微分备份(从备份集2)。
RESTORE DATABASE AdventureWorks FROM DISK = 'Z:\SQLServerBackups\AdventureWorks.bak' 
   WITH FILE=2, RECOVERY;
GO