Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: dopping the database which is in emergency mode

    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.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    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.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Did you identify the reason for Suspect mode?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Apr 2003
    Posts
    176
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •