异机备份准备工作:
1、映射网络网络驱动器,参照示例写异机的地址如(\\192.168.5.186\backup),backup对应的异机盘符共享开启,相关权限(读写,完全控制)开启,连接后请自行测试。
2、数据库机器的操作master下执行
EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'xp_cmdshell', 1;
RECONFIGURE;
exec master..xp_cmdshell 'net use Z: \\192.168.5.180\backup 123456 /user:192.168.5.180\Administrator'
USE master;
ALTER DATABASE SQL_LX SET RECOVERY FULL;
GO
BACKUP DATABASE SQL_LX
TO DISK = '\\192.168.5.180\backup\test.bak'
WITH FORMAT;
GO
EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'xp_cmdshell', 1;
RECONFIGURE;
exec master..xp_cmdshell 'net use Z: \\192.168.3.12\4.20DB_backup abcd=1234 /user:192.168.3.12\Administrator'
单次试验的语句:
USE master;
ALTER DATABASE SQL_LX(数据库名) SET RECOVERY FULL;
GO
BACKUP DATABASE SQL_LX(数据库名)
TO DISK = '\\192.168.3.12\4.20DB_backup\test2.bak'
WITH FORMAT;
GO
其余的就和新建一个的维护计划一致了,就可以选择虚拟的磁盘了。