locked
Regular Backup co-exist with log-shipping (or SQL mirroring) RRS feed

  • Question

  • Suppose I have a 3rd party SQL backup software to backup my databases, can I also setup a stand-by server for log shipping?

    I'm not sure if this is possible? If not, is SQL mirroring a choice instead of log shipping?

    Thanks a lot!

    Monday, May 14, 2007 6:05 PM

Answers

  • The only restriction is that only one thread of log backups can exist.

    So, if your 3rd-party backup software is also doing log backups, log shipping will not work.

    Alternatively, you can do full backups with your 3rd-party software and log shipping will work just fine.

     

    Mirroring has no such restrictions.

    Tuesday, May 15, 2007 7:09 PM