/************ 备份 恢复 *******
backup database sys to disk='c:\目录\a.bak' with init
调用存储过程xp_CmdShell:
master..xp_cmdShell 'bcp pubs..authors2 out c:\authors.txt -Sservername -Usa -Ppassword'--还原
use master
RESTORE DATABASE TestDB FROM DISK = 'c:\2002.dat'
backup database sys to disk='c:\目录\a.bak' with init
调用存储过程xp_CmdShell:
master..xp_cmdShell 'bcp pubs..authors2 out c:\authors.txt -Sservername -Usa -Ppassword'--还原
use master
RESTORE DATABASE TestDB FROM DISK = 'c:\2002.dat'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货