I recently backed up a database and when trying to restore it to my local machine I got this error:
Msg 3182, Level 16, State 2, Line 1
The backup set cannot be restored because the database was damaged
when the backup occurred.
Salvage attempts may exploit WITH CONTINUE_AFTER_ERROR
I tried several different backups (e.g., with the crc check/verifying the backup options checked/unchecked). I tried restoring within the management studio gui and via T-SQL script. Each time the same error.
I can successfully restore if I include the 'continue_after_error' but I'm unaware of what the error was and it leaving it this way will give me a nagging feeling of doom to come.
What should I be doing to troubleshoot this? I'm a relative beginner with respect to database administration and until now, things have gone smoothly in all my backups/restores.