November 27, 2002 at 9:42 am
We are running 2 seperate maintenance plans that backup SQL databases alternately by day between 2 servers each having about 800GB storage space. If each maintenance plan is setup to keep 7-days of backups, does it count the days that that server did not receive any new SQL databases? For example, Here us server1 plan: today is November 27, 2002, if the server is backed up on 11/27, 11/29, 12/1, 12/3, 12/5, 12/7 and 12/9, will it count 11/28, 11/30, etcetera and delete the database backup from November 27th, on December 4th? instead of on the 8th backup which would run on 12/11.
To summarize (because I know what I am saying is confusing), will the November 27th backup be deleted on December 4th, or will it be deleted on December 8th?
November 27, 2002 at 12:07 pm
The plan counts actual days. I does not care if it had do something on a certain day.
December 2, 2002 at 1:42 pm
Based on the number of backups and the size of the backups you should take a look at SQL LiteSpeed.
This could reduce your backup time by 50% as well as reduce your disk space needs for your backup files by 70-80%. In addition, the restores are also much faster.
SQL LiteSpeed can also be integrated very easily with your existing Maintenance Plans that you already have setup.
Greg Robidoux
Edgewood Solutions
http://www.edgewoodsolutions.com
Greg Robidoux
Edgewood Solutions
www.edgewoodsolutions.com
December 2, 2002 at 4:05 pm
2nd vote for SQLLitespeed. Working on a review and it is a fantastic product.
The maint plan works on days. If you say 7 days, it keeps 7 files (assuming you backup once a day). You need space for 8 because the backup occurs before the deletion.
Steve Jones
December 2, 2002 at 7:33 pm
You could add a step via the job to verify how many instead are in the folder and with active script delete the oldest instead of expiring. BUt you have to make sure permissions are in order to delete the file.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply