Our company often appear sqlserver2000 database consistency error, but after the restart the server or backup to restore with DBCC checkdb (dbname) check, error disappears, what reason is this excuse me? thank you

CodePudding user response:

Check the SQL2000 SP4 patch is installed.

CodePudding user response:

Sp4 installed, and deleting data have relations? Every year we delete the previous data on a regular basis