Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Maintenance Plans - Backups and Removing Old Files


Maintenance Plans - Backups and Removing Old Files

Author
Message
Andy Warren
Andy Warren
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

Group: Moderators
Points: 7221 Visits: 2679
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/maintenanceplansbackupsandremovingoldfiles.asp>http://www.sqlservercentral.com/columnists/awarren/maintenanceplansbackupsandremovingoldfiles.asp

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Jeremy
Jeremy
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 1
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 Smile 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!



Andy Warren
Andy Warren
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

Group: Moderators
Points: 7221 Visits: 2679
I sorta see your point, but ultimately what you dont have is a current backup, which to me is a far greater problem!

Andy
http://www.sqlservercentral.com/columnists/awarren/

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
David Benoit
David Benoit
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2108 Visits: 3650
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
glacroix
glacroix
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 1

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





Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search