SQL server数据库备份与还原语句

--创建备份设备到D盘
USE [master]
GO
EXEC master.dbo.sp_addumpdevice  @devtype = N'disk', @logicalname = N'beifen', 
@physicalname = N'D:\beifen.bak'
GO
--完整备份到备份设备中
BACKUP DATABASE [这是数据库名] TO  [beifen] WITH NOFORMAT, NOINIT,  
NAME = N'这是数据库名-完整 数据库 备份', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO
--还原完整备份
RESTORE DATABASE [这是数据库名] FROM  [beifen] WITH  FILE = 1,  NOUNLOAD,  
REPLACE,  STATS = 10
GO
--差异备份
BACKUP DATABASE [这是数据库名] TO  [beifen] WITH  DIFFERENTIAL , NOFORMAT, NOINIT,  
NAME = N'这是数据库名-差异 数据库 备份', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO
--事务日志备份
BACKUP LOG [这是数据库名] TO  [beifen] WITH NOFORMAT, NOINIT,  
NAME = N'这是数据库名-事务日志  备份', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO
--还原到最近状态
RESTORE DATABASE [这是数据库名] FROM  [beifen] WITH  FILE = 1,  NORECOVERY,  
NOUNLOAD,  STATS = 10
GO
RESTORE DATABASE [这是数据库名] FROM  [beifen] WITH  FILE = 2,  NORECOVERY,  
NOUNLOAD,  STATS = 10
GO
RESTORE LOG [这是数据库名] FROM  [beifen] WITH  FILE = 3,  NOUNLOAD,  STATS = 10
GO