December 10, 2003 at 1:59 am
I have created a Maintenance Plan and Scheduled it weekly. Check Database integrity and "Attempt to Repair Minor Problems" has been enabled. But this seems to require database in Single User Mode. Putting in Single User Mode is not an option Since the Database has to be Online 24/7/365.
December 10, 2003 at 6:22 am
If DBCC CheckDB finds any problem then running DBCC CHECKDB with the REPAIR option will require your db to be in single user mode.
Run a CHECKDB manually, and if it founds any errors, then consider puting the db in single user mode.
Also try to find the reason of the damage in the db, and you can restore the damage db in another server, so you can estimate the time to repair the db.
December 10, 2003 at 7:06 am
Don't check the Attempt to Repair Minor Problems as this is a known issue (well-documented). Most of the time SQL Server won't detect any issues and will go along just fine, so there's no need for this to be toggled. Should SQL Server detect an error needing repair, you should know about it from a maintenance plan and respond accordingly (and manually as racosta has suggested).
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
December 11, 2003 at 12:59 am
Thank you all for your time. Manual Intrevention is required which i was trying to avoid.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply