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 |
|
sundarchaitanya
Starting Member
1 Post |
 Posted - 2012-06-20 : 06:08:36
|
Dear All,My database shows that database in restore mode. I was unable to bring it offline. i dont have backup. database size is 400 gb and i usedresote database <dbname> with recovery commandthese no change in statusplease help me.thanks in advance
|
|
|
JaybeeSQL
Posting Yak Master
112 Posts |
Posted - 2012-06-20 : 11:57:59
|
| Oddly enough I am currently facing the same problem on 4 log shipping secondary databases, look forward to any advice. |
 |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2012-06-25 : 02:11:09
|
| The solution of the issue is to create an empty database and make a backup of that then tried to restore the backup on the database stuck in restoring mode. Set these options on the restore:First, the recovery state needs to be RESTORE WITH RECOVERY. Second, the “Overwrite the existing database” option needs to be selected. With these settings, the empty database was restored into the one that was stalled out. Ref:http://www.kenmaynard.com/content/sql-server-database-stuck-restoring-mode |
|
|
|
|
|
|
SQL database struck at restore mode