July 22, 2002 at 12:27 am
Hi,
A very good day to you. I do have a query. What will be the command to overwrite the pervious backup?
I have used this command : backup database <databasename> to disk = 'filename'
I have try this but it will just append. What should i add to have the file being overwritten. I added this into the job function in SQL Server 2000.
Hope that you can advise me on that.
Best regards.
July 22, 2002 at 6:26 am
If you want to overwirte the previous backup then use.
backup database <databasename>
to disk = 'filename'
WITH FORMAT
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 22, 2002 at 9:22 am
I prefer to generate a unique name for each backup so I can keep more if I need them. I then trim the previous ones with a script.
Steve Jones
July 22, 2002 at 4:58 pm
July 22, 2002 at 6:51 pm
Hi,
Thank you for your tips. I will give it a try today.
Best regards.
Kelvin
quote:
If you want to overwirte the previous backup then use.backup database <databasename>
to disk = 'filename'
WITH FORMAT
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply