Post reply

Droping the Database in emergency mode

  • October 7, 2004 at 8:48 am

    #60533

    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.

  • October 8, 2004 at 10:24 am

    #525984

    When the db was in "suspect" mode, did you run the "sp_resetstatus" stored procedure?

    Don't count what you do, do what counts.

    SQL Draggon

  • October 8, 2004 at 12:33 pm

    #526014

    Yes,But it didn't work for me,So I have set the database to emergency mode.But how can i drop this database.I have created another DB with all the Data base objects But nnow the problem is that how can i drop or rename that existing DB.If I can do that i can rename the new DB to the old DB.

     

    Thanks.

  • October 8, 2004 at 12:55 pm

    #526015

    Have you tried sp_detach_db or taking it offline in Enterprise Manager?

  • October 8, 2004 at 1:14 pm

    #526017

    Yep, I could not do it either.

  • October 8, 2004 at 2:06 pm

    #526020

    How about

    DBCC DBREPAIR(database_name, dropdb)

    Steve

  • October 8, 2004 at 3:22 pm

    #526031

    I'm sorry to say that now the DB is in emergency mode so i can't drop it.

    How can i drop when its in emergency mode.

    Thanks.

  • October 10, 2004 at 6:22 am

    #526058

    When you tried to drop the database, you say the message was that it is 'in use'. You aren't doning anything silly like leaving Query Analyser linked to the database, are you? 

    Run 'sp_who' in Query Analyser to check if any process is linked to the database.

    Peter

  • October 11, 2004 at 7:41 am

    #526147

    I tried that also,But I have a connection which is an application user for that DB. So How can disconnect forcibly that user from th DB.I guess if i can disconnect the user then i can drop the DB.

     

    Thanks.

  • October 11, 2004 at 8:38 am

    #526189

    In enterprise manager:

    go to Management - current Activity- Processes Info

    then right click on the process you want to get rid of and select kill Process.

    Peter

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply