Is your feature request related to a problem? Please describe.
CheckId 14 checks for backups written to the Windows NUL (one "L") device (i.e. backups that are immediately discarded and don't actually exist on disk).
Describe the solution you'd like
The check consists of 2 queries:
-
First query flags databases that had backups to NUL that are either COPY_ONLY or in SIMPLE recovery. These are phantom backups but don't break the backup chain.
-
Second query flags the more dangerous case: databases in FULL/BULK_LOGGED recovery that had non-copy-only backups to NUL. Since these advance the LSN chain without producing a real backup file, they can brake the backup chain and make log chain restores impossible.
Sample result set
Describe alternatives you've considered
Going to SQLBits.
Are you ready to build the code for the feature?
Yup
Is your feature request related to a problem? Please describe.
CheckId 14 checks for backups written to the Windows NUL (one "L") device (i.e. backups that are immediately discarded and don't actually exist on disk).
Describe the solution you'd like
The check consists of 2 queries:
First query flags databases that had backups to NUL that are either COPY_ONLY or in SIMPLE recovery. These are phantom backups but don't break the backup chain.
Second query flags the more dangerous case: databases in FULL/BULK_LOGGED recovery that had non-copy-only backups to NUL. Since these advance the LSN chain without producing a real backup file, they can brake the backup chain and make log chain restores impossible.
Sample result set
Describe alternatives you've considered
Going to SQLBits.
Are you ready to build the code for the feature?
Yup