If I backup my SQL Server 2008 R2 database with the following command
set @BackupFileName = N'C:\backup\Production-db.BAK' BACKUP DATABASE [Production-db] TO DISK = @BackupFileName
and run the command twice, the backup file grows to twice the current database size. With every new run, additional data is appended.
How can I create a full backup without appending, but by replacing the previous backup file?