Error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Error

Error

Rate Topic

Display Mode

Topic Options

Author

Message

Satya_0000

Posted Saturday, December 03, 2011 8:45 AM

Valued Member

Group: General Forum Members
Last Login: Monday, April 22, 2013 5:40 AM
Points: 53, Visits: 204

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

salum

Posted Saturday, December 03, 2011 8:46 AM

Valued 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

dineshvishe

Posted Monday, January 14, 2013 2:31 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 6:28 AM
Points: 42, Visits: 224

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

« Prev Topic | Next Topic »

Permissions