Monday, March 12, 2012

Recover db after disaster test

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?
THXAre 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/
"SQL_dummy" <SQLdummy@.discussions.microsoft.com> wrote in message
news:139075EF-6815-4A92-A243-D942E4537AA9@.microsoft.com...
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|||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.
"Narayana Vyas Kondreddi" wrote:

> 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/
>
> "SQL_dummy" <SQLdummy@.discussions.microsoft.com> wrote in message
> news:139075EF-6815-4A92-A243-D942E4537AA9@.microsoft.com...
> 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
>
>|||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
"SQL_dummy" <SQLdummy@.discussions.microsoft.com> wrote in message
news:CDD197DF-BC3B-4043-A4DB-E9D0D0969E67@.microsoft.com...[vbcol=seagreen]
> 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.
> "Narayana Vyas Kondreddi" wrote:
>
may[vbcol=seagreen]
client[vbcol=seagreen]
databases.[vbcol=seagreen]

No comments:

Post a Comment