[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

SQL 2008 Log shipping set-up along with Database Mirroring

Hello there,

I have a existing SQL 2008 DB mirroring set-up that will provide HA capability and would like to set-up a Log shipping from Principal server to a secondary server in DR site. In the event of Datacenter going down, we can manually fail over DB in Secondary server.

I am looking for documents that will explain the set-up for Log shipping with DB mirroring. Is there any implication that I should be concerned with?

Please advise.

Thanks and Regards
0
goprasad
Asked:
goprasad
  • 2
1 Solution
 
Ephraim WangoyaCommented:
There should be no problem as far as I know, look at this article from Microsoft
http://msdn.microsoft.com/en-us/library/ms187016.aspx
0
 
goprasadAuthor Commented:
Is there any URL with step by step process of setting up SQL 2008 Log shipping
0
 
Ephraim WangoyaCommented:
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now