View Single Post
  #7  
Old 6th July 2012, 21:35
Diggy Diggy is offline
Junior Member
 
Join Date: Aug 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Each night, a main database on a db server is backed up on that server before nightly transactions are run, and after they're run. Each before and after database, along with the db transaction log, is placed in its own sub-directory named for the date of the backup, as in "20120516" and "20120516_after". After a month's worth of these backups are created, I archive them on a NAS device. After three months, I delete the oldest backups on the db server. Rather than do this manually, I was looking to automate at least most of the process. Hence the script.
Reply With Quote