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 |
|
DKnutson
Starting Member
4 Posts |
 Posted - 2009-06-26 : 16:35:02
|
| I'm thinking of setting up a mirrored db where the two servers will be on opposite sites of a private T1 WAN. Both servers are running SQL 2005. The database is currently 1GB, but will steadily grow by about 10GB per year. The main reason to mirror them will be for disaster recovery - like when my main office loses power for a period of time.Is this configuration advisable? Anyone else doing this with a similiar sized db? |
|
|
jrsansom
Starting Member
4 Posts |
Posted - 2009-06-28 : 16:11:07
|
| OK, this may sound like a daft question but may I ask what is your reasoning for using Database Mirroring? That said, what you are looking to achieve is certainly possible and from the database size metrics you are quoting the volume of data being transported across the network is actually quite small.Other factors to consider are the Operating Mode that you intend to implement for your Database Mirroing deployment as this has ramifications with regard to network performance. I would of course also suggest that you test the latency of your network between the two sites ahead of proceeding with any Mirrored deployment.John Sansom | www.johnsansom.com | |
 |
|
|
DKnutson
Starting Member
4 Posts |
Posted - 2009-06-29 : 16:04:34
|
| I'm thinking mirror strictly for fault tolerance. If my office in CA loses power (like it did this weekend), then with a few quick changes, everyone can be back in operation using the mirrored system in LA. I've tested the change-over and it takes me about 5 minutes to reconfigure the app servers - the mirror itself does auto-failover.My current latency is generally below 100ms. I've only worked with the High Avail. mode so far. I not really worried about losing data during if a failover happens - can easily re-import anything that is missing, so I can go with a different mode if necessary. Thanks! |
|
|
|
|
|
|
Mirror servers across T1 WAN