November 10, 2004 at 7:50 am
Hi
I am kind of new to Restores and Backups
Let me explain what we do. We back up the Production and make a copy of the backup and Restore it for Marketing Analysis etc. etc.
Step 1) --> We kill all active processes
Step 2) --> Move from Prod Backup to E drive of the QA server.
Now Step 2 Failed because there is not enough DISK Space for the data file. Understand that, but this leaves the DB on QA server on "Loading" mode. It doesnt go back to "regular" mode, so that it can be used.
Can somebody explain what should I do , so that next time if the Restore Fails -- then I should be able to use the DB.
Thanks
J P G
November 15, 2004 at 8:00 am
This was removed by the editor as SPAM
November 16, 2004 at 7:02 am
If the restore fails, you can't use the database - it never restored. SQL Server is usually an 'all-or-nothing' system.
-SQLBill
December 1, 2004 at 12:34 pm
I encountered a similar problem recently. The solution was to stop SQL Server and delete the physical files (mdf & ldf) then restart SQL Server. In this case, SQL Server recognized that the files were not available and made no attempt to load them. I then recreated the database from the script originally used and the user was back in business, able to perform the restore.
Hope this helps (even if late).
Don
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply