error restore 01

恢复 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