Monday, September 3, 2012

Database is in transition

When you alter the database to “OFFLINE” and other transactions are happening on that database then the database will be in transition and will require the transition Session to complete, or we may have to kill that session. Database OFFLINE state requires “Exclusive Lock” on the database. So always use “With Rollback Immediate” 

Alter Database <DB> Set Offline With Rollback Immediate;

No comments:

Post a Comment