sm_iransoftware (1/31/2015)
I read It.the most important and repeatedly Advise is :
Dont use Repair option. because ....
The impression from this recommendation can be
1- I must run only DBCC checkDB 'DBName' about once a week. (without option)
this command cover most of the validation DBCc commands.
2- I must check the report of this Command.
But I dont know What do I do, If :
3- I Found some error on DBCC report. In microsoft text, recommanded restore backup and dont use repair, If you have backup.
If I read the error on 10 oclock, I should restore database ? restore to which time?
1. The standard database consistency check command of Checkdb runs both logical and physical checks across the database files and inside the database.
2. Yes. Otherwise, why run it.
3. Assuming you're also taking log backups, restore to a point in time prior to the corruption of your database.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning