SQL Server Performance Forum – Threads Archive
AN SQL DATABASE IS SUSPECTED TO BE CORRUPTED
How can i determine if a certain database is corrupted? When you view the SQL Enterprise Manager, no identifier "(SUSPECT)" is indicated but it seems to be corrupted since it has been returning error messages to its users. Recently, one of our servers was downed due to a massive power fluctuation. And this occurrence could have caused some of the databases to be corrupted? Thanks again.
select name, dbid, mode, status from sysdatabases where dbid =
db_id(‘msdb’) name dbid mode status
msdb 5 0 328
truncate log on chkpt
database not recovered yet
database is suspect for more informationhttp://support.microsoft.com/default.aspx?scid=kb;en-us;180500 —————————————-
Cast your vote
And obviously try to protect your servers against any future power fluctuations. If you can get a power stabiliser and a UPS, that is probably a good idea, especially if you regularly have power fluctuations. Have the stabiliser on the mains supply side, then the UPS then your server plugged into the UPS. This should give you reasonable protection although obviously nothing is guaranteed to protect you completely. Regards, Robert.