异地备份数据库
2
已经封装成存储过程了,如下:
create procedure RemoteBackup
as
begin
declare @datestr nvarchar(30)
declare @bakfilename nvarchar(50)
declare @bakpath nvarchar(50)
--
时间字符串
set @datestr = convert(nvarchar(30), getdate(),121)
set @datestr = Left(@datestr,19)
set
@datestr
=
replace(replace(replace(@datestr,'-',''),':',''),'
','')
--bak
文件路径
set @bakfilename = N'CITAS_GDB_' + @datestr + '.bak'
set @bakpath = 'z:\' + @bakfilename
print @bakpath
--
开始备份
--
注意
:(Z:
后面要有一个空格
)
exec master..xp_cmdshell 'net use z: