I’ve like to have this discussion on db corruption topic. We run weekly dbcc checkdb and most time, this sql job went through without errors. However, if it does, that usually means big headache for any dbas.
The recommended way is to check if it can be fixed without data loss or restore from last good copy.
My question is about the procedure to restore from last good copy.
Our backup strategy is weekly full back on sunday, diff backup daily and tlog backup hourly.
Say if weekly integrity check indicated errors,
How to determine the last good backup
once last good backup is determined, say corruption on wed, should I use last week full backup + diff backup on tuesday + all tlogs after tuesday’s diff backup till current time to restore db? question
should I use replace option ?