Override file while backup database
52,033
Solution 1
sqlcmd -S servername -Q "BACKUP DATABASE [DBName] TO DISK = 'C:\backup.bak' WITH INIT"
Solution 2
INIT
does the trick. From MSDN:
INIT Specifies that all backup sets should be overwritten
Solution 3
WITH INIT
is not enough. Should be WITH INIT, SKIP
these days. Docs
Explanation: INIT
overwrites only if some conditions are met. SKIP
instructs to ignore those conditions.
Related videos on Youtube
![juergen d](https://i.stack.imgur.com/LnDUq.gif?s=256&g=1)
Author by
juergen d
Updated on July 09, 2022Comments
-
juergen d almost 2 years
I want to back up a database using this code
sqlcmd -S servername -Q "BACKUP DATABASE [DBName] TO DISK = 'C:\backup.bak'"
It works. But if the backup file already exists, the data gets appended to the file instead of replacing the file. Every time I call
BACKUP DATABASE
the file gets bigger.Is there an option for
BACKUP DATABASE
to force a replace? -
Amirhossein over 2 yearsPlease edit your answer! This question no need for new answer and your answer isn't minimum of policy for answer question format. please read help center