Override file while backup database

sql-server database backup database-backups

sqlcmd -S servername -Q "BACKUP DATABASE [DBName] TO DISK = 'C:\backup.bak' WITH INIT"

sql-server database backup database-backups

INIT does the trick. From MSDN:

INIT Specifies that all backup sets should be overwritten

sql-server database backup database-backups

BACKUP DATABASE SQ_P TO DISK='D:\Data Backup\SQ_P.bak' with init;

where SQ_P is the Database Name

CodeHunter