Taking a database offline in SQL Server 2008 and avoid transition error message

HomeIT Taking a database offline in SQL Server 2008 and avoid transition error message
May
22

Taking a database offline in SQL Server 2008 and avoid transition error message

by in IT

Taking a database offline is a very simple task. Right click on it and select ‘Take offline’. However, if the database is being used at the moment the action will fail and your database may remain in limbo for a (sometimes long) while.

Msg 952, Level 16, State 1, Procedure sp_who, Line 79
Database ‘UATdb’ is in transition. Try the statement later.

Try this instead:
ALTER DATABASE UATdb SET OFFLINE WITH ROLLBACK IMMEDIATE


About the Author:

Xavier is an entrepreneur, project manager, trainer, Certified Scrum Master & Professional and Certified Microsoft professional who has spent a great deal of his career working on cutting edge projects, with a primary focus on .Net and recently iOS. His expertise is primarily web applications, search and mobile. Throughout multiple projects he has acquired skills in dealing with complex enterprise software deployments with companies that range from startups to Microsoft. Also worked as a worldwide v-trainer/evangelist for Microsoft.
«
»
Share this:   

Sorry, the comment form is closed at this time.