question

Raghuchavan avatar image
Raghuchavan asked

Can We configure SQL server mirroing with Logshipping in SQL server 2008

Can We configure SQL server mirroring with Log shipping in SQL server 2008 ? SQL server Database mirroring for high availability and database log shipping for read only Or reporting purpose in SQL server 2008 . When the mirroring fail over to secondary server Log shipping should not have any effect.
database-mirroring
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
JohnM avatar image
JohnM answered
If I understand your question correctly, yes you can mirror AND log ship the same database. I'm assuming that you would mirror to one secondary instance and log ship to yet another instance. See this reference: https://msdn.microsoft.com/en-us/library/ms187016(v=sql.100).aspx The above article talks about how the data flow would work. Disclaimer: I've never done this type of configuration at all so I would definitely recommend testing. Hope that helps!
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.