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

Unable to connect to one or more Databases Expand / Collapse
Author
Message
Posted Sunday, August 5, 2012 7:37 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 7:39 PM
Points: 31, Visits: 206
Hi SQL Masters,

I have a situation here regarding my supported two Databases, one of them is ABC Database and the other one is DAConfiguration.

My problem here is that, when the ABC Database is in recovery mode status, the DAConfiguration Database is inaccessible, however, the status of DAConfiguration Database is "Online" when i execute the query below.

select d.database_id, d.name, d.state_desc
from sys.databases d
where d.name in ('ABC','DAConfiguration');
go;

I am just thingking, if there is a relationship between the two of them.

Can anyone would help me regarding my case?


Your response is highly appreciated.


Thank you


-dev1.bohol@gmail.com
Post #1340322
Posted Monday, August 6, 2012 12:25 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 2:53 AM
Points: 1,101, Visits: 5,290
I don't think there is any relationship...
Please post the error message.
Post #1340367
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse