How to make a job overwrite and not append

mat41 · October 24th, 2005, 09:53 PM

I can not make a job that overwrites an existing file. Everytime the job runs the file size get out of control.

1..I am using the job wizard in EM to create the job.
2..Using Transact SQL Command:
Backup Database DBName To Disk='C:\MyPath\DBName.bak'
3..Scheduling it to run once a day in the evening

It is all running fine and backs up as it should. How can I make it replace the file each time. My objective is to have one file in this dir and for it to be overwritten each time. I can not find a way to stop the file size growing.

Thank you in advance

Wind is your friend
Matt

robprell · October 25th, 2005, 01:42 PM

I think you want the "init" option of the backup command. It's in the help files that come with SQL.

mat41 · October 25th, 2005, 06:23 PM

I wil look for it, have you used it?

Wind is your friend
Matt

mat41 · October 26th, 2005, 06:14 PM

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

robprell · October 28th, 2005, 04:03 PM

Thanks for the follow up message, sorry I was unplugged from the web for a few days to reply to your previous post.

gday mate!!!