Unable to connect to one or more Databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Unable to connect to one or more Databases

Unable to connect to one or more Databases

Rate Topic

Display Mode

Topic Options

Author

Message

dev1.bohol

Posted Sunday, August 05, 2012 7:37 PM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 8:06 AM
Points: 14, Visits: 90

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. Smile

Thank you

-dev1.bohol@gmail.com

Post #1340322

Suresh B.

Posted Monday, August 06, 2012 12:25 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 4:49 AM
Points: 1,075, Visits: 5,119

I don't think there is any relationship...
Please post the error message.

Post #1340367

« Prev Topic | Next Topic »

Permissions