isql -Usa -Ppassword -Sserver

dump database name to "路径\文件名"

go

 

load database name from "路径\文件名"

go

 

在备份和还原时，可能会出现无法连接到备份数据库

sp_configure "allow update",1

go

update sysservers set srvnetname='XXX_BS' where srvid=1

go

 清除日志

dump transaction master with no_log

go