恢复 test的时候遇到了了 狗屎的问题
问题 1
use test
go
restore database test
from disk =‘t:\badkup\test_full11192014';
with norecovery
"because it is in use by this session. It is recommended that the master database be used when performing this operation"
原因 狗屁的
解决 不要用 test, 用其他的 database 什么系统db 自己创建的阿猫阿狗的db
问题2
use master
restore database test
from disk =‘t:\badkup\test_full11192014';
with norecovery
the tail of the log for the database "test" has not been backed up. use backup log norecovery to backup the log if it contains work you dont want to lose.use replace or with stopat clause of the restorestatement to joust overwrite the contents of the log.''
原因 没有备份 tail 系统建议使用 replace 或者 stopat 来解决
解决 替换 norecovery 或者是通过 studio 着tail的备份 右击要备份的db task backup 选择 log 备份 在左边的 大窗 选择 选项 勾选 tail 备份
use master
restore database test
from disk =‘t:\badkup\test_full11192014';
with replace
it works