Configure option to disable BACKUP LOG TO DISK = 'NUL' - by Stan Segers

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 795081 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 7/26/2013 1:56:24 AM
Access Restriction Public


In some cases I had problems with virtual machines and VSS based backup software. These problems are twofold;
- VSS based backups software executing a BACKUP LOG TO DISK = 'NUL' after taking a snapshot and thus invalidating the log chain.
- VSS based backup software taking full backups under the hood (thus resetting the base for differential backups)

For the first issue, I found the culprit; Veeam (; To avoid this problem, I would like to have an option (under sp_configure) to disallow log backups to disk = 'NUL'

For the second issue, a seperate connect item exits: "Option to force VSS backup to copy_only"
Sign in to post a comment.
Posted by Harut on 4/4/2014 at 4:16 PM
I think the request is not to completely disallow BACKUP LOG TO DISK = 'NUL' which I agree can be invaluable, but to have the knob to disable it as a conscious choice. You can always keep the default for a "Disallow" option to "off"
Posted by Microsoft on 10/10/2013 at 2:51 PM
VSS backups do not perform any form of LOG backup. The only options for VSS-based SQL backups are FULL and Database. If something is taking a BACKUP LOG TO NULL operation, it is the application, and not VSS.
While it would be handy to prevent backups to NULL, there area few areas where it is an invaluable tool (such as when the DB is completely out of disk space for the log, which can't truncate for lack of a backup.) This does break the log chain but that's better than having production down.