SQL server 2005 - database mirroring AND transaction log shipping on the same DB?

James St. John
James St. John used Ask the Experts™
on
I have a database setup with mirroring (high protection mode, no witness server).  I would like to setup transaction log shipping to a remote SQL server for the purpose of off-site backup.

Is it even possible to utilize transaction log shipping in a mirrored environment?  What happens if the principle server does down and I make the mirror server the principle server?

Also - with transaction log shipping, do I have to worry about identity columns like I'd have to with replication?

Thanks,
-- Jim
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
From BOL:

"Typically, when combining log shipping and database mirroring, the mirroring session is established before log shipping, although this is not required. Then the current principal database is configured as the log shipping primary (the principal/primary database), along with one or more remote secondary databases. Also, the mirror database must be configured as a log shipping primary (the mirror/primary database). The log shipping secondary databases should be on different server instances than either the principal/primary server or mirror/primary server. "




Author

Commented:
Sirees:

Thanks for the help.  You didn't mention anything about identity columns in this scenario -- do I have to worry about them?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial