Hai, 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...
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.