Discuz!NT|BBS|论坛

注册

 

发新话题 回复该主题

数据服务备份语句 [复制链接]

1#
DECLARE @strPath NVARCHAR(200)
set @strPath = convert(NVARCHAR(19),getdate(),120)
set @strPath = REPLACE(@strPath, ':' , '.')
set @strPath = 'D:\webs\wxgzh\bak\files\' + 'toppmswx2'+@strPath + '.bak'
BACKUP DATABASE [toppmswx2] TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT


DECLARE @strPath NVARCHAR(200)
set @strPath = convert(NVARCHAR(19),getdate(),120)
set @strPath = REPLACE(@strPath, ':' , '.')
set @strPath = 'D:\webs\mobileappsrv\bak\files\' + 'toppmsapp'+@strPath + '.bak'
BACKUP DATABASE [toppmsapp] TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT


DECLARE @strPath NVARCHAR(200)
set @strPath = convert(NVARCHAR(19),getdate(),120)
set @strPath = REPLACE(@strPath, ':' , '.')
set @strPath = 'D:\webs\khappsrv\bak\files\' + 'toppmskhapp'+@strPath + '.bak'
BACKUP DATABASE [toppmskhapp] TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT


DECLARE @strPath NVARCHAR(200)
set @strPath = convert(NVARCHAR(19),getdate(),120)
set @strPath = REPLACE(@strPath, ':' , '.')
set @strPath = 'D:\webs\helpbbs\bak\files\' + 'dnt31'+@strPath + '.bak'
BACKUP DATABASE [dnt31] TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
分享 转发
TOP
发新话题 回复该主题