July 23, 2008 at 11:00 am
Ok, Just try a RESTORE with REPLACE like this:
RESTORE DATABASE [your database name] from disk = 'Backup file name and path'
WITH REPLACE, RECOVERY
Maninder
www.dbanation.com
July 23, 2008 at 12:32 pm
Get the same message as before...tells me the database is in use.
The Redneck DBA
April 20, 2009 at 10:07 am
I have the same problem today and I don't have a backup from this database...
My problem started after I was recovering another database and sql server had stucked then I reboot the server and when sql server was rebooted I had 3 database stucked ub recovery, one of then was the database that I was recovering and the other 2 wasn't even in use
April 20, 2009 at 10:31 am
My problem went away when I bounces the SQLSERVER service. But sounds like you already have. Might give it awhile. If it is a big DB or you had a bunch of transactions to roll forward/back it may take awhile.
The Redneck DBA
April 20, 2009 at 11:48 am
we have one DB that takes almost 40 minutes to recover after a reboot. it's around 600GB and the schema isn't exactly by the book
September 16, 2009 at 12:34 am
Perry Whittle (7/23/2008)
sorry my bad!!restore database DBNAME with recovery
This worked for me...thanks.
September 16, 2009 at 6:20 am
Sometimes it is impossible to change database status, because it is corrupted.
Just make sure you don't have space issue and then re-run your job again - the new Restore on a top of "restoring" database works just fine.
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply