Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error Expand / Collapse
Author
Message
Posted Saturday, December 3, 2011 8:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 1:30 AM
Points: 53, Visits: 252
I am getting while using database. I was trying to take databse in OFFLine.

Msg 952, Level 16, State 1, Line 1
Database abc is in transition. Try the statement later.
Post #1215850
Posted Saturday, December 3, 2011 8:46 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, September 23, 2012 8:09 AM
Points: 70, Visits: 157
close your mangement studio and start again . I had a same issue in past

java
Post #1215852
Posted Monday, January 14, 2013 2:31 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:49 AM
Points: 62, Visits: 326
i check all process but no process shown in sysprocesses and Sp_who/sp_who2.
I had check database id from.
select * from sys.databases
then
select * from sys.sysprocesses WHERE dbid = 84

SELECT * FROM sys.dm_exec_requests WHERE database_id = 84

select * from sys.dm_tran_locks where resource_database_id=84
After that you will get procees id.

then kill corresponding session and check database status.

Post #1406607
Posted Sunday, June 2, 2013 11:45 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:49 AM
Points: 62, Visits: 326
.
Post #1459081
Posted Monday, June 3, 2013 12:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 5, 2014 2:51 AM
Points: 41, Visits: 227
Please try to Stop and Start sql server service using management studio to resolved this issue...
Post #1459090
Posted Monday, June 3, 2013 1:26 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 4:54 AM
Points: 1,921, Visits: 2,345
Restart the SQL Server


_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1459109
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse