January 26, 2012 at 9:09 am
I cannot Restore a ProdDB to a TestDB because it is in use. When I go to Activity Monitor and filter by TestDB, there is only one process, ID 54.
The Task State is SUSPENDED.
The Current type of Command is DELETE.
Wait Time (ms) is over 55,000.
Wait Type is BROKER_RECEIVE_WAITFOR.
I am unable to Kill this Process. How do I remove this process to restore to TestDB?
Also, what is the nature of this Process and why is it Suspended?
Thank you,
Steve Doinidis
January 26, 2012 at 1:35 pm
Have you checked what it is trying to delete? If the command is deleting millions of rows, and you are trying to kill, then it is trying to roll back all the rows and it will take some time to finish. Let's wait and restore. Don't attempt to restart the service and that will put the database in recovery mode.
January 27, 2012 at 9:14 am
Sounds an awful lot like this, http://social.msdn.microsoft.com/Forums/en-IE/sqldatabaseengine/thread/233da267-7d61-425e-bdce-58241a7769aa.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 1, 2012 at 8:32 am
As a work around, and providing you don't care about the TestDb you're trying to restore over, I would detach it, selecting the option to kill any connections before restoring the new ProdDb, making sure you select the TestDb file names in the restore options, and the overwrite existing db option.
All a bit dirty but will definitely achieve what you want to do!
Cheers
Vultar
February 8, 2012 at 10:45 am
Hi all,
My Caching Services was turned off, but it wasn't uninstalled. I have to uninstall caching services on the test app server prior to restoring Test.
Thanks!
Thank you,
Steve Doinidis
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply