Recovering DBs with a "Suspect" state

Hello
(SQL Server 2000)
I have databases that appear as "Suspect" in the Enteprise Manager. What can I do to recover them or put them in a normal state?
Thanks a lot.Depends on why it is suspect. If you are lucky, someone simply moved the database files, and you just beed to move them back. if you have average luck, then you are looking at a database restore. What does the errorlog say?|||before you decide what to do, you ought to determine the cause.

but you can either...

a. you might be able to put your database in emergency mode and extract your data using bcp or dts.

or

b. restore from your last good backup.

I practice full recovery and can recover to any point in time, so I usually go with b and I have never done a, but I hear it is possible in some situations.

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?
THX
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
|||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]

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]

Recover data from yesterday

Hi,
I'm not a database manager,
I have to recover the old database instead of the actual.
I backed up the old one from a tape backup.
Do i have just to rename the existing one and copy the one
that i want in the same folder.
People told me that there was no change between these two
version except that someone erase a folder.
Thank...
If you are talking about SQL Database (instead of MDMArch'd Analysis
Services database) ,YOu may restore the SQL database using the restore
wizard, but
1. Restore as a DIFFERENT database name and
2. on the second tab, choose DIFFERENT PHYSICAL FILENAMES/Locations for
each file so you will not overwrite the good, current version of the
database...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Alain" <anonymous@.discussions.microsoft.com> wrote in message
news:233501c4aca0$2e00dd90$a601280a@.phx.gbl...
> Hi,
> I'm not a database manager,
> I have to recover the old database instead of the actual.
> I backed up the old one from a tape backup.
> Do i have just to rename the existing one and copy the one
> that i want in the same folder.
> People told me that there was no change between these two
> version except that someone erase a folder.
> Thank...