SqlServer备份与还原（主从高可用同步相关）

备份脚本

 ---创建测度库
--CREATE DATABASE [testDB]

--USE [testDB]

--CREATE TABLE [TestTable](
--	[id] [int] IDENTITY(1,1) NOT NULL,
--	[UserName] [varchar](50) NULL
--) ON [PRIMARY]

--INSERT INTO [TestTable] (UserName) SELECT  'test'
 

DECLARE @CurrentTime VARCHAR(50), @FileName VARCHAR(200)
SET @CurrentTime = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR, GETDATE(), 120 ),'-','_'),' ','_'),':','')

        
--([testDB] 数据库完整备份)
SET @FileName = 'D:\dbbak\test_FullBackup_' + @CurrentTime+'.bak'
BACKUP DATABASE [testDB]
TO DISK=@FileName WITH FORMAT ,COMPRESSION


  --([testDB] 数据库日志备份) 
SET @FileName = 'D:\dbbak\test_logBackup_' + @CurrentTime+'.bak'
BACKUP log [testDB]
TO DISK=@FileName WITH FORMAT ,COMPRESSION
　　

　还原脚本

 ---创建测度库
--CREATE DATABASE [testDB]

--USE [testDB]

--CREATE TABLE [TestTable](
--	[id] [int] IDENTITY(1,1) NOT NULL,
--	[UserName] [varchar](50) NULL
--) ON [PRIMARY]

--INSERT INTO [TestTable] (UserName) SELECT  'test'
 

DECLARE @CurrentTime VARCHAR(50), @FileName VARCHAR(200)
SET @CurrentTime = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR, GETDATE(), 120 ),'-','_'),' ','_'),':','')

        
--([testDB] 数据库完整备份)
SET @FileName = 'D:\dbbak\test_FullBackup_' + @CurrentTime+'.bak'
BACKUP DATABASE [testDB]
TO DISK=@FileName WITH FORMAT ,COMPRESSION


  --([testDB] 数据库日志备份) 
SET @FileName = 'D:\dbbak\test_logBackup_' + @CurrentTime+'.bak'
BACKUP log [testDB]
TO DISK=@FileName WITH FORMAT ,COMPRESSION