Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
YogeshDesai
Posting Yak Master
136 Posts |
 Posted - 2007-11-26 : 09:31:36
|
| Hi Guys,I was just checking my DR server, I found that one database is in still loading status.when I am trying to open database getting the following errorError 927: Database 'XXXXXXX' cannot be opened. It is in the middle of a restore.anybody help me to fix this.SQL IN Minds |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-26 : 11:51:58
|
| it's waiting for you to finish restoring it.if you don't want to restore any more transaction log backups or differential backupsuse RESTORE DATABASE yourDB WITH RECOVERY_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
|
|
|
Error 927