January 15, 2004 at 7:46 am
A client running SQL 7 was attempting to move a database from his development server to production using a restore on the production server. The process hung up and he cancelled. Now he has a new database on the production server, but he can't access it or delete it. He's getting the following error:
Server: Msg 3701, Level 11, State 8, Line 1
Cannot drop the database 'CAER', because it does not exist in the system catalog.
Any suggestions?
January 15, 2004 at 8:08 am
I'm a bit curious as to why your client thought the process hung.
I'm not so sure that cancelling the operation was such a wise move. Whenever you're dealing with a prod server
you need to think at least twice about what you do before you do it.
Anyway, has your client tried to just re-apply the restore?
Try that first, and see what happens.
/Kenneth
January 15, 2004 at 9:03 am
1st. of all your client should not have sa right to create database as he pleased. (We don't give our client sa right!)
2nd. I think your client need to close and restart his EM. He could also right click on databases and refresh the database listing. If he is attempting to restore and overwrite the existing database, it's also a different problem. We also told our database dbos that they should request restore to us so that we can manage it instead of having them messed up their databases.
mom
January 15, 2004 at 9:10 am
I should have mentioned that the client has already rebooted the server in an attempt to clear the phantom connection, but continues to receive the above error.
January 15, 2004 at 9:38 am
Kenneth, re-applying the restore worked! --Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply