数据库异地备份

因为生产环境的数据库要进行异机备份，所以就做了一个Job+代码段来实现

数据库:MSSQL2005


EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO  


//创建映射(如不清楚net use命令，请查看DOS语法)
exec master..xp_cmdshell 'net use z: \\IP地址或计算机名\D$ "密码" /user:IP地址或计算机名\用户名'


declare @filename varchar(50)set @filename='z:\CroxxRoad'+CONVERT(VARCHAR(10),GETDATE(),110)+'.bak'backup database CroxxRoad to disk=@filename
//删除映射
exec master..xp_cmdshell 'net use z: /delete' 
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGUREGOEXEC sp_configure 'xp_cmdshell', 0
GO
RECONFIGURE