Wednesday, March 7, 2012

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

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!

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.

No comments:

Post a Comment