Post reply

3rd Party Tool for Transaction Log Backup

  • July 26, 2006 at 12:42 pm

    #75023

    Is there anyone using a third party tool that would take a transaction log backup and move the files to a remote location?

     

    Thanks

    shahab

  • July 27, 2006 at 2:00 pm

    #652003

    While I'm sure there are plenty of third party tolls that do this, I actually found a great set of scripts designed by someone on this site and posted for free. It uses a command line zip utility to compress the logs before sending them across the netrrok to a remote server. The whole setup is designed to facilitate log shipping but we use it just to for offsite backups as well. I'm currently using it for twenty remote sites and it works great.

     

    Here's the link http://www.sqlservercentral.com/columnists/ckempster/customlogshipping.asp

     

  • July 27, 2006 at 2:19 pm

    #652016

    Its a wonderful solution however has some shortcomings, acknowledged by author himself:

  • Cant pre-detect missed or missing files (as you could if you utilised the MSDB)
  • Cant pre-detect invalid file sizes
  • Does not do a quick header and file check and compare DBA's passed in parameters with

    • i am infact concerned about 1 and 2 both. Would like to find a solution for these.

  • July 31, 2006 at 9:03 pm

    #652504

    Are you looking to just move the logs or for transaction log shipping?

    Julian Kuiters
    juliankuiters.id.au

    • Viewing 4 posts - 1 through 3 (of 3 total)

    You must be logged in to reply to this topic. Login to reply