backup task for me
-
Hi
I have the following task, but i don't know how to configure to handle the backup file.
This is my task
What I would like to see for the backups of the SQL Server you are working on, is one Full backup per week (Saturday night), and Differential backups on the other days of the week. Unless you have also implemented automatic cleanup of old dumps, I recommend leaving a single full cycle on disks (disk space permitting of course); ie. use 7 different files, and after a week you start overwriting the previous week’s files again.
Thanks for your help
Janos
-
I almost sounds like you're giving advice more than asking for advice, but I think there's maybe a language barrier there. However, I'm going to assume you're asking for advice.
If all you want to do is overwrite last week's files, then put the full backup in a different job than the diffs and use the @init = 1 flag. That will overwrite the file that already exists. The same can be done for the diffs if you like.
You can put the diffs in the same job because it's all inclusive. So wed's diff will contain everything until wed, not just wed. So you can overwrite it every day w/o any problems.
Is this what you're asking?
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
Hi,
Sorry for my english, the email supposed to be a begging for help.
I dont understand the init=1 flag. What does it do? I understand what you mean with differential backup includes the previous days as well. But my collegues wish to have all differantial backup files to keep for 6 days in a week. Can i sort out that with one differential job I create 6 different file / database. Then i will overwrite the files same weekday next week.
Thanks you for your help
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply