causes and recovery from suspect mode
can some one tell me that what are the possible causes that mark a database in sql server as suspect mode and how to recover it.
The exact problem is here-
We're trying to backup the transaction log. as there was not free disk space it failed and the database server has marked as suspected. How to recover it and what is the possible reasons of it.
error log contains mainly following error messages
"BACKUP failed to complete the command BACKUP DATABASE <dbname> TO DISK = N'<Some Path>' WITH NOINIT , NOUNLOAD , NAME = N'BackUp', NOSKIP , STATS = 10, NOFORMAT "
Then it has various occurences of following error message
"The log file for database 'distribution' is full. Back up the transaction log for the database to free up some log space."
"Automatic checkpointing is disabled in database 'distribution' because the log is out of space. It will continue when the database owner successfully checkpoints the database. Free up some space or extend the database and then run the CHECKPOINT statement."
After that lined up with following message repeatedly.
"I/O error (bad page ID) detected during read at offset 0x000000002a2000 in file 'd:\microsoft sql server\mssql\Data\distribution.MDF'.."
Please someone tell me