Setup SQLServer 2008 DR database using NetApp?

• WYL

  Old Hand

  Points: 323

  More actions

  November 11, 2011 at 5:30 pm

  #251714

  Hi:

  I am looking into ways to setup a SQLServer DR database, for purpose of DR and reporting.

  Prd environment: SQLServer 2 Node Cluster

  DR environment: Standard alone SQLServer

  Want to find ways so that the SQLServer DR database will be up running for DR + reporting purpose, and updates will be propagated from Prd environment to DR in a 15min interval.

  Can NetApp snapmanager for SQLServer/snapmanager be used to setup the environment? Have seen documents to setup SQLServer DR using NetApp tools, but the DR database is offline, and will only be brought up when a DR switch over happens.

  Thanks.

• Perry Whittle

  SSC Guru

  Points: 234064

  More actions

  November 15, 2011 at 8:05 pm

  #1408238

  No snapmanager, use SQL server log shipping.

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉