ananda.murugesan (8/21/2013)
Can we kept CHECKSUM option in database Instead checking every week DBCC CHECKDB?
No.
Well, you can do it, but it will give you absolutely no knowledge about whether the database is corrupt or not, so doing so could easily result in a case where you find out you have corruption and find out that all backups back the last 3 month are also corrupted and that there's no way to recover without data loss.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability