Home / server / Questions / 383579
Accepted
joeqwerty
Asked: 2012-04-27 14:30:57 +0800 CST

How Do I Use the "Backup Database" Statement to Overwrite an Existing Database Backup?

  • 772

I'm trying to write a database backup statement that will overwrite the existing backup but I'm not having any luck. I've tried various combinations of the INIT, FORMAT, and RETAINDAYS =x clauses but the backup seems to always append to the existing file instead of overwriting/recreating it.

What is the correct statement to use to achieve this?

sql-server-2008

1 Answers

  1. Best Answer

    You should be able to use WITH INIT provided that the name of the backup that you are taking matches the name within the backup.

    • 3