-- ===========================

-- Backup Database Template

-- ylb:创建数据备份

-- ===========================

BACKUP DATABASE TestDb

 TO  DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\TestDb.bak'

WITH

 NOFORMAT,

 COMPRESSION,

 NOINIT,

 NAME = N'TestDb-Full Database Backup',

 SKIP,

 STATS = 10;

GO

-- ============================

-- Restore Database Template

-- ylb:还原数据库（前提必须有备份）

-- ============================

USE master

GO

RESTORE DATABASE TestDb

 FROM  DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\TestDb.bak'

WITH

 FILE = 1,

 NOUNLOAD,

 REPLACE,

 STATS = 10

GO

-- ================================

-- Create Backup Device Template

-- ylb：创建备份驱动

-- ================================

USE master

GO

EXEC master.dbo.sp_addumpdevice

 @devtype = N'disk',

 @logicalname = N'Backup_Device_Name',

 @physicalname = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\Backup_Device_Name.bak'

GO