When someone from my team tried to take a Database offline, due to a blocking session the database went into transition state. The session is still present and Now I want to know what is the blocking session running while trying to keep database offline before killing it.
If i try with any dmvs or DBCC Input Buffer i'm getting the same error: Database is in Transition.
Please help me how to find what was the session running.
P.S It is a SQL 2005 database
Aucun commentaire:
Enregistrer un commentaire