Home Forums SQL Server 2008 SQL Server 2008 Administration What to do IN RECOVEY and lock database in the same time does not allow to be ONLINE RE: What to do IN RECOVEY and lock database in the same time does not allow to be ONLINE

  • Sue,

    Thanks for your response. Great documentation.
    After a couple of hours, watching,
    database_transaction_log_bytes_reserved from sys.dm_tran_database_transactions, for both transactions

    0
    3639948
    and it remains at the same value.
    database_transaction_next_undo_lsn
    NULL
    NULL

    What  else can I do? More than 24 hours  IN RECOVERY state, no  ERRORLOG updates about this

    Best  Regards