June 3, 2002 at 12:00 am
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/awarren/maintenanceplansbackupsandremovingoldfiles.asp>http://qa.sqlservercentral.com/columnists/awarren/maintenanceplansbackupsandremovingoldfiles.asp
June 10, 2002 at 4:11 am
You say:
"Now you'd think...really...that it would make sense to delete the files first, then do the backup?"
I would say that that would absolutely make no sense at all, and I thank MS on my bare knees (as a manner of speaking 🙂 that they agree with me. It would be very bad to delete the previous backup unless you were 100% sure that the new backup was OK (that is: written to disk and preferably verified too). Otherwise if the backup failed it would be possible to end up without a valid backup since the older one was already deleted.
I think that if you choose to keep 2 old backups, you should know that you are guaranteed to have those, even if the last backup failed for some reason. In your scenario, if a backup failed, the older one would already have been deleted. Backups are just to important to take such gambles with!
June 10, 2002 at 4:34 am
I sorta see your point, but ultimately what you dont have is a current backup, which to me is a far greater problem!
Andy
June 10, 2002 at 6:44 am
Have to agree with Andy on this one. Rather loose two days ago backup and try to get a good current one.
Anyway, thanks for finding this out Andy! Good to know.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 7, 2004 at 8:14 am
Hi Andy,
I have been having a problem with the maintenance plan where it does not remove transaction logs older than the specified number of days set in the properties. In one plan, i have 5 databases manually selected and i have enabled the transaction log backup once a week and the plan is supposed to remove the .trn files older than a week. However, only 2 databases are showing .trn files and those .trn files are never deleted, and just keep adding up week by week. Other plans are working fine. Do you have any idea what could be causing this? Do i need to limit one plan per db when backing up the transaction log?
thanks,
Guy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply