SQL Server Take Offline

We had an issue with taking a SQL database offline, and we found that the SQL allowed more control for rolling back in-progress transactions.  Here is the article that listed the SQL.

I think our problem had something to do with the SQL Agent.  We ended up having to kill the process that was accessing the database, and I am pretty sure it was a SQL Agent process.  Then, the database went offline, and we able to restore it.

Resources

SQL for taking databases offline

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.