I have a Database in suspect state and i have changed it to emergency mode and copied all the data and i am trying to delete it or renaming it so that i can recreate the db with the old name as my aplication will be looking for that database name.
When i tried to drop the database it says its in use and cannot be dropped.
And when I tried to rename it It gives me the follwoing message.
To change the NAME, the database must be in state in which a checkpoint can be executed.
Please advise me .
Thanks.Enterprise Manager likely still has a connection to the suspect database. Close EM, and drop the database via Query Analyzer (while logged into the master DB, of course). Just another reason why Enterprise Manager is evil.|||Did you identify the reason for Suspect mode?|||My data files and log files were corrupted and i dont have a backup for the DB. So I have placed the db in emergency mode and copied all the tables and data using query analyzer. But while copying the table and data i could not get all the constraints on the tables.
I have copied the tables and data using the following sql command
SELECT * INTO aaa from aaa.
How can i bring the db into active which is now in emergency mode.
Thanks.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment