March 14, 2008 at 4:08 pm
I have inherited a SQL Server that has a database marked as (Loading\Suspect). As far as I can tell, I dont have a backup of this database. I know I can delete the db, but I want to restore the db and need the data.
What are my choices, if I want to restore this db ?
I can stop the service, move/copy the db's raw data files to another directory....but can I then do a restore with the raw data files ? (I dont think I can do an 'attach', as the db was never 'detached')
Please advise what I can do.
Thank you
March 14, 2008 at 6:16 pm
One cause of Loading, is that a database was restored without the use of WITH RECOVERY so it is still looking for additional files to be restored.
Try this:
RESTORE DATABASE dbname WITH RECOVERY
Might be obvious - but - replace 'dbname' with the real name of your database.
-SQLBill
March 15, 2008 at 9:59 am
I'd also look at why it's suspect. check the error log for clues. Often this is something simple, like a moved LDF file or permissions.
March 17, 2008 at 11:12 am
SQL Bill, I receive the follwing messages when I perform your syntax;
File 'Customer_Primary_0' was only partially restored by a database or file restore. The entire file must be successfully restored before applying the log.
File 'Customer_Data2_0' was only partially restored by a database or file restore. The entire file must be successfully restored before applying the log.
File 'Customer_Primary_1' was only partially restored by a database or file restore. The entire file must be successfully restored before applying the log.
File 'Customer_Data2_1' was only partially restored by a database or file restore. The entire file must be successfully restored before applying the log.
The database has a primary .mdf and 3 .ndf files and 1 ldf (log) file....
What else can I try ? Overall, is it possible to create a new database with the mdf, ndf, and ldf files ?
March 17, 2008 at 11:48 am
In the meantime, I tried to detach and attach db without success...now when I run the syntax of
'RESTORE DATABASE [customer] WITH RECOVERY' I get the message of
Could not find database ID 65535. Database may not be activated yet or may be in transition.
Any help at this point would be greatly appreciated !
Thank you
March 20, 2008 at 2:35 pm
It looks like something stopped the restore before it was completed. I would try restoring it again. Make sure you have enough disk space to do the restore.
Keep in mind that if the original database had 10 GB of data and 5 GB of unused space, the backup might only be 10 GB in size, but it still needs a minimum of 15 GB of space on the drive.
-SQLBill
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply