We have an SQL Server 2000 DB server with several databases on it. Frequently, one of the DBs will have a state of "Suspect." This appears to occur after our 3rd party backup software runs a full backup on the weekends.
How can I begin to troubleshoot the cause of this issue? Has anyone seen anything like this?
Unless your 3rd party backup tool is SQLLiteSpeed, in which case I don't think it's the reason, - disable any 3rd party backups and use the native. Also examine carefully your disks and make sure you're not running out of disk space on the drives where you place the backup devices. Try to move those devices onto a different drive other than the ones where your data and log devices live.
How are you currently reviving the database ? Also, do you run dbcc checkdb on this database ? If you database is clean, no disk errors and you have plenty of disk space - contact this vendor to see if there are any known issues. Also, have big is this database and do you use any text/ntext... datatypes ?