SQL Server Performance

How to get the DB from recovery mode to Normal mode?

Discussion in 'SQL Server 2005 General DBA Questions' started by muraliprofession, Apr 24, 2008.

  1. muraliprofession New Member

    I have cancelled the updation operation on one of my tables in one database, in the Query Analyser, as it is takes a long time for more than 9 hrs.After cancelled the query, I have restarted the server, and after restarting the server the DB shows the recovery mode. In this case, i thought can I detach and attach the database, but i feel it may leads to corrupt the database.I don't know how to get this database from this recovery mode to normal mode..
    Kindly advise me...Thanks to everybody...
  2. anilksharma99 New Member

    It's rolling back transactions and if the log file is huge, rolling back would take considerably long. You would have to wait until log file transactions are rolled back. You should not even be able to detach the db.
  3. Luis Martin Moderator

    Did you write rollback in you update?

Share This Page