I have the following statement being run in an SQL Server 2000 Job:

Backup Database DBName To Disk='C:\Path\DBName.bak'

Every time this runs it appends to the existing file (the last scheduled backup) This makes the file size grow and grow and grow.Eg if the first .bak file was 10Mb the next back up will push the file size to 20Mb even though there has been no more data in the tables. Can I alter this statement to replace or overwrite the existing file?

Thank you in advance

Wind is your friend
Matt

__________________
Wind is your friend
Matt

Take a look at EXPIREDATE and RETAINDAYS in BOL for Backup Database

“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/

If I am creating a job using EM. Are these properties avaibale to me? The way I am reading them they are not.

Is it possible to create a 'scheduled job' using EM that overwrites the last .bak file

TYIA

Wind is your friend
Matt

Here is the solution for anyone interested:

The INIT is what did it

BACKUP DATABASE [DBName] TO DISK = N'C:\Inetpub\wwwroot\path\DBName.bak' WITH INIT , NOUNLOAD , NAME = N'SomeName', NOSKIP , STATS = 10, NOFORMAT

Wind is your friend
Matt