November 24, 2005 at 11:55 am
Hi,
I’m part of the SQL Server product team at Microsoft and I’m an expert on corruption problems, their causes and how to rectify them. I wrote DBCC CHECKDB and repair for SQL Server 2000 and 2005 so I have a lot of useful knowledge to share. I’m currently the Lead Program Manager for the Storage Engine.
I’m happy to answer any questions you have on corruptions and disaster recovery and I can decipher any CHECKDB output. To make things easy for us all, please start a new thread for your issue and include the following info if at all possible:
1) What symptoms you’re seeing
2) The output from ‘DBCC CHECKDB (yourdbname) WITH ALL_ERRORMSGS, NO_INFOMSGS’
3) When the problem first occurred and what steps you have already taken
4) The SQL Server version (including SP and any hotfixes)
5) Whether you have a comprehensive disaster recovery strategy, including usable backups
6) Whether you’ve checked the SQL Server errorlog and Windows event logs for evidence of h/w problems
7) Whether you’ve made an recent h/w changes
8) Whether all your firmware/drivers are up-to-date
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
November 28, 2005 at 8:00 am
This was removed by the editor as SPAM
November 28, 2005 at 6:29 pm
Paul,
Quite the credentials. Thanks for offering to help. I have just a quick question.
I have a DB Maintenance Job set up and I chose to "repair minor problems if possible" in the database integrity job step. If it does have to do a repair, does it show up in the log?
Thanks......Cindy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply