RE: Extremely Quick Backups – SQLServerCentral

Hall of Fame

Points: 3152

January 12, 2018 at 1:30 am

#1975678

Rune Bivrin - Friday, January 12, 2018 12:32 AM
Interesting. If you look in the linked documentation, you're led to believe that the ... FILE = NUL syntax (without the single quotes) is the correct one, but clearly that doesn't work in practice.

Yes..
https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql
This states NUL (not 'NUL')

{ DISK | TAPE | URL} = { 'physical_device_name' | @physical_device_name_var | NUL }