Recently I took the database offline with the option Drop all active connections checked.
After that I couldn't bring it back online due to error Could not redo log record for transaction id on page database. I was able to recover the database with CHECKDB but I want to avoid such a scenario in future
As far as I understand an uncommitted transaction was interrupted which corrupted databases's integrity.
I wonder how can I disable new upcoming connections while letting the active transactions to finish?