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 |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2008-06-06 : 03:43:25
|
| We were trying to restore our production server db backup in test server over LAN (due to space shortage on test server) . Test server hanged and did not respond for abt more than 15 hours (backup file 40 GB ) . The we restarted the server (resetting the power button) . Now it's showing the status 'Restoring' . According to me it's not doing anything (as seen in task manager workload ) . So how can I go ahead with checking the db .Due to 'restoring' status I get following error ------------------------------------Msg 927, Level 14, State 2, Line 1Database 'envdb' cannot be opened. It is in the middle of a restore.---------------------------------- |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-06 : 09:01:10
|
| You must have restored with Norecovery option.Apply diff or tran log backup with Recovery option.If its restores,I would suggest to check integrity with DBCC checkdb. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-06 : 23:51:05
|
| Run this:restore database db_name with recovery |
|
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2008-06-09 : 09:52:50
|
| You'll have to drop the database and restart the restore operation as it was interrupted during it's restore operation and will not be able to be recovered manually (as suggessted prior). |
|
|
|
|
|
|
failed restore and server restart