What are the challenges you face when working across database platforms? Take the survey
Options

SQL Backup Log shipping with existing log shipping

ghinesghines Posts: 7
edited January 10, 2008 5:26AM in SQL Backup Previous Versions
Hi, we are currently doing log shipping with one of our databases using the native SQL facilities. What's the best way to set this up with SQL Backup? Should I just run the log shipping wizard and it will take care of it, or do I need to disable the current log shipping, and then run the wizard? Thanks for any help.

Comments

  • Options
    peteypetey Posts: 2,358 New member
    You need to disable the existing log shipping setup. While it is possible to maintain two log shipping schemes, having transaction log files in two formats just makes the restore process difficult to manage, besides having to ensure both schemes' timings do not collide.

    Disable the existing job, after ensuring that all backed up transaction logs have been restored on the standby server. Then use the SQL Backup GUI to set up log shipping. You do not need to perform the full backup/restore since your production and standby databases are already in sync.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.