Database SUSPECT...

[Parasu]

Hi All,
I find one of my databases as SUSPECT when I open my SQL Server 7 using EM. What does this SUSPECT mean. What causes this and how can I rectify my database.
Thanx in advance

Cheers
ozone

 

[Cagliostro]

Is this adtabase created on an oter computer? John Fill

ivfmd@mail.md

 

[Parasu]

Hi John,
The database is in the same computer only. I tried to copy the .mdf and .ldf files of the database and paste it in other server. The copying was not successful. Might that be a reason??

Cheers

 

[tlbroadbent]

The following info comes from SQL BOL.

Suspect means: Database integrity is suspect for the referenced database.

A database can become suspect if one of these conditions is true:

[ol][li]If one or more database files are not available.[/li]
[li]If the entire database is not available.[/li]
[li]If one or more database files are corrupted.[/li]
[li]If a database resource is being held by the operating system.[/li][/ol]
To resolve a suspect database:

[ol][li]Check the SQL Server error log and resolve all problems.[/li]
[li]Reset the suspect status by executing sp_resetstatus.[/li][/ol]
For more information, see Resetting the Suspect Status and Troubleshooting Recovery.

The last two references are to articles in SQL BOL.


Terry

http://members.home.net/tlbroadbent/index.htm

 

[Parasu]

Terry,
Thanx for that. I'll work around. Thanx again

Parasu