Backup database - overwrite option

Question

Hello,
I make a backup over maintenance plan wirh script, it works fine:
USE AdventureWorks2012;
GO
BACKUP DATABASE AdventureWorks2012
TO DISK = 'Z:\SQLServerBackups\AdventureWorks2012.Bak'
GO
After the job, the backup file exist at folder.
When i start the job again, he appned at existing file AdventureWorks2012.Bak the database.
How can i overwrite this file at maintenance plan, not append?
Horst

---

Thanks Horst MOSS 2007 Farm; MOSS 2010 Farm; TFS 2010; IIS 7.5

Answer 1

Hi,

You can add option with init as below

USE AdventureWorks2012;
GO
BACKUP DATABASE AdventureWorks2012
TO DISK = 'Z:\SQLServerBackups\AdventureWorks2012.Bak' with init
GO

This will overwrite all the previuous backups files in this backup.

---

- Chintak (My Blog)

Answer 2

Thank You.

Horst

---

Thanks Horst MOSS 2007 Farm; MOSS 2010 Farm; TFS 2010; IIS 7.5