一定要在sqlserver2005里面映射,在系统映射是不能用的
exec master..xp_cmdshell
'net use z: //192.168.0.11/其他备份/kq "278016tshily" /user:192.168.0.11/administrator'
删除映射:exec master..xp_cmdshell
'net use z: /del'
备份
完整备份
Backup Database NorthwindCS
To disk='G:/Backup/NorthwindCS_Full_20070908.bak'
--差异备份
Backup Database NorthwindCS
To disk='G:/Backup/NorthwindCS_Diff_20070908.bak'
With Differential
--日志备份,默认截断日志
Backup Log NorthwindCS
To disk='G:/Backup/NorthwindCS_Log_20070908.bak'
--日志备份,不截断日志
Backup Log NorthwindCS
To disk='G:/Backup/NorthwindCS_Log_20070908.bak'
With No_
Backup Database NorthwindCS
To disk='G:/Backup/NorthwindCS_Full_20070908.bak'
--差异备份
Backup Database NorthwindCS
To disk='G:/Backup/NorthwindCS_Diff_20070908.bak'
With Differential
--日志备份,默认截断日志
Backup Log NorthwindCS
To disk='G:/Backup/NorthwindCS_Log_20070908.bak'
--日志备份,不截断日志
Backup Log NorthwindCS
To disk='G:/Backup/NorthwindCS_Log_20070908.bak'
With No_