SQL 2008 High Availability Solutions

[scottcabral1979]

Hi,

we currently have a SQL 2008 data warehouse with about a dozen different databases. We would like to have about 5 of the databases replicated or mirrored to another database server.

Since it's a data warehouse, the data only gets loaded during a 3 hour period each morning and the rest of the day it remains static. I'm trying to come up with the best option to copy these databases to a different database server on a scheduled basis in case the main data warehouse is unavailable.

I looked at snapshot replication which seems like it could be a possibility. I'm just worried about how long the process will take. Are there any other options that would make sense given my situation?

thanks

 

[dhulbert]

Why not just go with a backup and restore after the overnight jobs have completed.



I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)