sql数据库局域网和远程异地备份数据库方案.docVIP

异地备份数据库 2已经封装成存储过程了，如下：create procedure RemoteBackupasbegin?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 = NCITAS_GDB_ + @datestr + .bak?set @bakpath = z:\ + @bakfilename?print @bakpath??--开始备份?--注意:(Z:后面要有一个空格)?exec master..xp_cmdshell net use z: HYPERLINK \\4\Share\CITASDB_RemoteBackup\\4\Share\RemoteBackup?? userpassword?? /user:computename\