Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to Retrive the suspect database

Author  Topic 

anthu_soft
Starting Member

8 Posts

Posted - 2008-10-22 : 02:02:00
Hi,

I have a big problem in sql server. i created the database and am having some table. now my data base is in suspect state. how can i bring the normal database or how can i take the backup for the database.


I need an urgent solution.

Thanks in Advance,
Anthuvan

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-10-22 : 02:55:45
What version of SQL?

Do you have a backup of that database?

If you look through the error log, what does it say about that DB? There should be some entry in there saying why the DB is suspect.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -