Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Know everything about SQL Server technologies and latest happenings, not to mention the best practices and sharing best from our own experience.
Browse by Tags · View All
DBA 36
SQL Server 32
Best practices 27
Configuration 22
General 20
Versions 19
Technical Reference 17
SQL Server 2008 R2 14
Tools 13
SQL Server 2012 12

Archive · View All
May 2012 16
July 2012 11
June 2012 9
August 2012 8
September 2012 3

SQL Server Knowledge Sharing Network

How to fix Microsoft SQL Server Error 5034 or fix Database is in transition. Try the statement later

Jul 12 2012 12:00AM by Satya Jayanty (@sqlmaster)   

This can happen sometimes if you try to take a DB offline or perform certain other operations and they fail.

  • Sometimes the lock can be cleared if you close the SSMS instance that attempted the operation, and then reopen it.
  • It can also occur if you try to take the DB offline while a long query is running. Follow the below steps to find long-running queries and the kill if there are any.

                     Ø  Select DB_ID('DB_Name')

                     Ø  Select status, session_id, command from sys.dm_exec_requests Where database_id =<dbid>

                          After running above query, If you find the status column with value - "Suspended" then you have to 

                    kill   that session id. You can run below query to kill that spid.

                     Ø   KILL <spid>

If neither of the above works, close all SSMS instances then restart SQL Server Service through the SQL Server Configuration Manager. Usually that will cure it, although the DB may be in recovery mode at first

 


Republished from SQLServer-QA.net [10 clicks].  Read the original version here [4 clicks].

Satya Jayanty (@sqlmaster)
34 · 5% · 1720
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"How to fix Microsoft SQL Server Error 5034 or fix Database is in transition. Try the statement later" rated 5 out of 5 by 1 readers
How to fix Microsoft SQL Server Error 5034 or fix Database is in transition. Try the statement later , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]