I want to do a full weekly backup of my SQL Server 2012 Express database.
I have created a SQL script and batch file to automatically do a full backup of my database each week and overwrite the existing backup file each time this script is executed.
I am wondering if my syntax is correct and is doing what I intend it to do.
BACKUP DATABASE test TO DISK = N'\\path\to\backup\folder\TestBackup.bak' WITH NOFORMAT , INIT , NAME = N'test Backup' , SKIP , NOREWIND , NOUNLOAD , STATS = 10;
Is there anything incorrect in the above backup statement?