Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scabral7
Yak Posting Veteran
57 Posts |
 Posted - 2012-04-24 : 14:36:46
|
| 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 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-04-24 : 14:57:05
|
| Replication is certainly an option, it's just likely to be more work if you're going to replicate the entire database.Log shipping may be a decent solution, as you can schedule the synchronization to occur only when needed. You also have the option of reading from the secondary database if you use standby. While you can't read from a mirrored database, you can have it automatically fail over, while log shipping and replication require manual failover and changing connection strings in applications. |
 |
|
|
scabral7
Yak Posting Veteran
57 Posts |
Posted - 2012-04-24 : 15:59:55
|
| what if the databases are set to simple recovery mode? I don't think Log shipping would work unless i change it to full mode.I just need an automated way to get the databases in sync, but realizing that it will only happen once a day. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-04-24 : 16:34:36
|
| Simple recovery restricts you to snapshot replication, or making a backup and restoring it. |
|
|
|
scabral7
Yak Posting Veteran
57 Posts |
Posted - 2012-04-24 : 16:47:42
|
| that's what i figured. Well, at least it's a start...thanks |
|
|
|
|
|
|
SQL 2008 High Availability options