Database is in transition. MSQL: Error 962

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Database is in transition. MSQL: Error 962

Author

Topic

lalbatros
Yak Posting Veteran

69 Posts

Posted - 2008-11-27 : 09:16:32

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
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-27 : 09:20:40

Was Database involved in Log shippping?

defiestc
Starting Member

1 Post

Posted - 2008-12-18 : 16:34:03

Try closing and opening Management Studio then try accessing the database again

Cowski
Starting Member

30 Posts

Posted - 2011-07-07 : 14:52:35

For what it's worth, defiestc' solution fixed my issue.

Silly, silly SQL Server.

Thanks!

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-07-07 : 15:04:57

Right click -> refresh should have the same effect. Management Studio's just a management tool, nothing more. Closing & reopening it won't affect the databases.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources