sql server connect: Recover db after disaster test -- sql server connect

Re: Recover db after disaster test

Narayana Vyas Kondreddi
4/29/2005 12:00:00 AM

sql server connect: Are you at least able to see the databases from Query Analyzer? If so, may
be it is a client side issue, and can be resolved by reinstalling client
tools. Any errors in the SQL Server error logs?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/

[quoted text, click to view]
After doing an disaster recovery test the sql services aren't running.
When i open the enterprise manager the instance is there but no databases.
All databases are recovered from tape

How can i solve this in proper way?

THX

Re: Recover db after disaster test

SQL_dummy
4/29/2005 4:32:01 AM

No, in the query analyzer i can only see the instance, no databases.
There if got an error message that he couldn't find sql server services.
So now i'm trying to reinstall the sql server.

[quoted text, click to view]

Re: Recover db after disaster test

Hari Prasad
5/1/2005 12:00:00 AM

Hi,

From Control panel services, see MSSQL Server server is running or not, If
the service is stopped mode, start the service and see if you can see
the databases.

Thanks
Hari
SQL Server MVP

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.