DBCC (checkdb & shrinkfile) corruptions

[oldduffer]

All

Hope you can help with this one;

Over the past few weeks I've been receiving too many errors for both the checkdb and shrinkfile commands.
Last night for example the DBCC checkdb failed because it could not access a data page, I think an earlier failure with the shrinkfile may have been the cause. This again happened the night before and a number of times over the past month. The frequency used to be less than once per six months

I would like to know if there are any reasons why these DBCC's may be corrupting so frequently or if there is any steps or advice you can give to prevent this problem

any ideas appreciated, thanks

Old goat

 

[tlbroadbent]

Which SQL Server version and service pack is installed? Does the error log provide any additional info about the failures? Which options are you using with CHECKDB? What other maintenance functions do you run regularly? Do you perform regular backups?

Do you know which database is in error? Have you attempted to analyze one table at a time on the database? Have you reindexed the tables lately?

What kind of disk are you using for data and log files? Do you have RAID? Are the data and log files on the same drive? How much disk space is available for the data and log files? Is there other activity on the server during the maintenance runs?

We run regular maintenance including BACKUPS, DBREINDEX, CHECKDB and SHRINFILE on 7 servers and rarely encounter errors unless we run out of disk space. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.