Native SQL Backups & RedGate Backups

guantguant Posts: 14
edited July 16, 2009 5:56AM in SQL Backup Previous Versions
Were planning on switching over all of our sql backups to redgate, but in the meantime were testing both first to make sure we want to purchase. Is it ok to run both sql and redgate backups or will they interfere with each other?

Thank you!

Comments

  • Guant,

    When I converted to SQLBackup I migrated each database at a time with the native backup and the SQLBackup jobs both running and once I was happy with the SQLBackup set up I stopped the native ones. Obviously I had to schedule them apart for performance and file access reasons and also for my own reasons I had the backup files generated in a different location. I had this parallel run system for maybe two or three days per database before I switched to solely SQL Backup.

    Good luck with your project.

    Jonathan

    Senior DBA
    Careers South West Ltd
  • Guant,

    The other thing to be careful of is that both SQL Backup and Native backups share the same LSN sequence so if you were to do the following:
    ----------------------------------------------------------------------------------> Time
    SQL Backup:   Full            Diff              Full          Diff              Full           
            Native:            Full              Diff           Diff            Full           Diff
    

    You would need a mixture of SQL Backup and Native backups to do a restore.

    James
    James Moore
    Head of DBA Tools
    Red Gate Software Ltd
  • Very good point James, it totally slipped my mind that I ran my native backups with the WITH COPY_ONLY option so as to not break the SQLBackup chain.

    Essentially my first step was to accept that SQLBackup was my main backup tool and I had the native backups as a safety net.

    Jonathan

    Senior DBA
    Careers South West Ltd
Sign In or Register to comment.