BACKUP DATABASE myDB TO DISK = N'C:\path\myDB.bak' WITH NOFORMAT, COMPRESSION, NOINIT, NAME = N'myDB-Full Database Backup', SKIP, STATS = 10; GO