September 3, 2013 at 3:00 pm
Using SQL 2008 R2,
1. Can I create either a Mirror off of a Mirrored database, or can I create 2 Mirrors off of one principal?
2. Having 2 instances with mirrored databases, can I also create a log shipped database off of the principal, which ever server is the pricipal?
Thanks!
September 3, 2013 at 3:07 pm
alanspeckman (9/3/2013)
1. Can I create either a Mirror off of a Mirrored database, or can I create 2 Mirrors off of one principal?
No and no.
2. Having 2 instances with mirrored databases, can I also create a log shipped database off of the principal, which ever server is the pricipal?
Yes. It's a little harder than log shipping a standalone, but there are documents explaining the process around.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply