Comments
Sort by recent activity
Perfect! Thanks for the help. / comments
Perfect! Thanks for the help.
Brian Donahue wrote:
jlucas -- you're saying that the database is in a restoring state, what is the indication? Is the word (restoring) next to the database name in SQL Server Manaagement Studio and SQL Backup? If so, you may have simply forgot to restore the database using the WITH RECOVERY option.
Yes, that is correct. What is quirky about this all is that Red Gate says the restore is complete. I also noticed that it did not allow me any way to break the restore process (I was trying just ot get into my database at this point). I did try to stop the SQL Backup Agent, but it didn't work.
What I ended up doing was:
- Wait a few hours
- Verify it still showed restoring next to the db name in Red Gate and Management Studio
- I then did a differential restore which did the restore once again, but opened my database immediately
This is really all the information I have to go off of. Is there a better way to handle this in the future? I already plan on creating a secondary backup process. / comments
Brian Donahue wrote:
jlucas -- you're saying that the database is in a restoring state, what is the indication? Is the word (restoring) next to the database name in SQL Server Manaagement Studio...
That is exactly what happened and then the restoring never went away and I was locked out from doing anything to the database. In the future, I will do restores with the Operational selection.
Do you know if there are any other ways to stop the restore if it seems frozen? I understand it may only restore portions of the database if I do this. I stopped the SQL Backup Agent and restarted it, but that didn't stop it. / comments
That is exactly what happened and then the restoring never went away and I was locked out from doing anything to the database. In the future, I will do restores with the Operational selection.
Do y...
I have the same issue where it is locking up, but shows the restore already being completed. However, with my issue, I cannot get the restore to stop altogether. This is a very small restore I am working with (4MB).
I closed management studio and stopped and started the SQL Backup Agent (twice). Red Gate and my server still show the database is being restored.
Any thoughts on what I should do? / comments
I have the same issue where it is locking up, but shows the restore already being completed. However, with my issue, I cannot get the restore to stop altogether. This is a very small restore I am w...