【MVS】sqlserver 备份数据库命令

备份sqlserver 数据库，完整备份数据库和日志

--查看当前连接的数据库

select @@servername;

 

--在主库上创建测试库和表

CREATE DATABASE [test]

USE [test]

CREATE TABLE [test1]([id] INT,[name] VARCHAR(100))

INSERT INTO [test1] SELECT 1,'test'

 

 

--在主库上执行，获取时间戳后，进行数据库和日志备份；

--参数format 删除之前备份集信息，init重建备份集； 

DECLARE @CurrentTime VARCHAR(50), @FileName VARCHAR(200)

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

 

SET @FileName = 'D:\clustershare\QQQ_FullBackup_' + @CurrentTime+'.bak'

BACKUP DATABASE [QQQ] TO DISK=@FileName WITH FORMAT ,COMPRESSION

 

SET @FileName = 'd:\clustershare\QQQ_logBackup_' + @CurrentTime+'.bak'

BACKUP log [QQQ] TO DISK=@FileName WITH FORMAT ,COMPRESSION