Hi. One of our customers is reporting that his maintenance-plan-driven backup will sometimes fail validation. He has the process setup to send him an email when a failure occurs. What causes these failures? Always, subsequent backups are (for a time) fine--report no failures.
asked 06 Nov '12, 15:28
Is the database in active use (i.e. running transactions) during the validation? (IIRC, the maintenance plan runs its validation against the active database, not against a copy of the backup.) - If so, confine the following general warning on validation:
Does a further validation of the same database (i.e. not in the next run) give the same errors?
answered 06 Nov '12, 16:44