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 |
|
Clothahump
Starting Member
18 Posts |
 Posted - 2011-04-25 : 15:12:28
|
| I'm new to the world of replication and mirroring. I think I can do this, but everything I'm reading has only succeeded in confusing me.Scenario: three local servers (L01,L02,L03) and one remote server (R01). L03 is the primary SQL Server that services the application.We currently replicate publishing directly from L03 to R01. The issue comes if we have to copy the replicated database back across the network; it can take days (20+ gb files on a T1 line).I want to establish mirroring from L03 to L02, with L01 witnessing. That seems fairly straightforward. We also enjoy the advantage of a hot rollover if L03 goes down. My question is this:Can I then set up replication from L02 to R04? R04 is our "off-site" location, which we are required to have. Or could I set up a second mirror from L03 to R01 with no automatic rollover?Has anyone done anything like this? Is it even possible? Thanks in advance! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Clothahump
Starting Member
18 Posts |
Posted - 2011-04-26 : 13:51:16
|
| Okay....another variation.As I said, we are replicating from L03 to R01. I'm thinking now that we leave that in place, as it satisfies our off-site backup requirement. If I do, can I also set up mirroring from L03 to L02? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Clothahump
Starting Member
18 Posts |
Posted - 2011-04-27 : 12:18:12
|
| Great. That's how we'll handle it, then.Thanks, everyone! |
|
|
|
|
|
|
|
|
Can I replicate a mirror database?