SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Database is in transition. MSQL: Error 962
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lalbatros
Yak Posting Veteran

67 Posts

Posted - 11/27/2008 :  09:16:32  Show Profile  Reply with Quote
Hello,

I cannot access my database anymore, neither in the Management Studio, nor by any other means (Access).

This is the error message I get when I try to open the database:
The database myDatabase is not accessible. (ObjectExplorer)


And this the error message when I try to get its properties:
Database 'myDatabase' is in transition. Try the statement later. (Microsoft SQL Server, Error: 952)

Would you know the possible causes?
Would you know any solution?
And do you know if I should keep some hope to get access to my data again?

Thanks
__________________________________________________________________

Here is also the full message when trying to read the properties:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Database 'myDatabase' is in transition. Try the statement later. (Microsoft SQL Server, Error: 952)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=952&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

sodeep
Flowing Fount of Yak Knowledge

USA
6718 Posts

Posted - 11/27/2008 :  09:20:40  Show Profile  Reply with Quote
Was Database involved in Log shippping?
Go to Top of Page

defiestc
Starting Member

1 Posts

Posted - 12/18/2008 :  16:34:03  Show Profile  Reply with Quote
Try closing and opening Management Studio then try accessing the database again
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000 Version 3.4.03