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 |
|
tshockley
Starting Member
2 Posts |
 Posted - 2007-04-21 : 15:17:03
|
| When trying to perform a restore in SQL Enterprise Manager, the restore process completes but when I try to access the database it shows still restoring. This will stay like this not matter what I do. Has anyone ran into this problem before and does anyone know of a fix. Every other aspect of SQL Enterprise Manager is currently working, I believe it could have been one of Microsofts patches that could have caused this but not sure. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-21 : 20:36:25
|
| Did you try refresh the display in em? How about restore db with sql statement? |
 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2007-04-21 : 20:49:54
|
| Most likely you made an incorrect selection of "Recovery Completion State" on the Options tab of the Restore Database dialog. "Leave database operational" is the one you wanted in this case.In order to fully recover the database that is currently in the loading state, you can run the following in Query Analyzer: RESTORE DATABASE <DBNAME> WITH RECOVERY |
|
|
|
tshockley
Starting Member
2 Posts |
Posted - 2007-04-23 : 08:03:05
|
| When Restoring the database I made sure that I checked the fully operational and I also refreshed Enterprise Manager. No matter what I do the database stays restoring. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-23 : 10:30:29
|
| Tried with restore statement? Same issue? |
|
|
|
rend
Starting Member
1 Post |
Posted - 2008-12-05 : 12:03:08
|
quote:
Originally posted by izaltsman
Most likely you made an incorrect selection of "Recovery Completion State" on the Options tab of the Restore Database dialog. "Leave database operational" is the one you wanted in this case.In order to fully recover the database that is currently in the loading state, you can run the following in Query Analyzer: RESTORE DATABASE <DBNAME> WITH RECOVERY
this worked for me. thx so much. |
|
|
|
|
|
|
Restores hang in Enterprise Manager