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 |
|
Zoroaster
Aged Yak Warrior
702 Posts |
 Posted - 2008-01-16 : 11:35:34
|
All, I am looking to see if anyone here has some hands on experience with a blend of Database Mirroring and Transactional replication and if there are any caveats I should know about when approaching this. From a high level what we have is a primary site and a backup site with the idea being to mirror the primary db and secondary db at each site and then use Transactional replication across sites from primary db to primary db. Our preferred solution is to use clustering in place of mirroring but it is not an option at this location. If there is a better way please feel free to include in your response. Thank you.
Future guru in the making. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-01-16 : 11:50:42
|
| I've got lots of experience with all 3. Our current environment:4-node cluster at both sites for site maintenance and issues. Database mirroring of all prod databases from primary site to secondary site for disaster recovery purposes. Transactional replication at primary site between databases and also across to the other site for reporting and dual site purposes. So did you have a specific question?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2008-01-16 : 11:53:14
|
I suppose my question is if the proposed solution (mirrored DB's with the primarys replicated) is workable or if it is too convoluted to be practical?
Future guru in the making. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-01-16 : 11:59:51
|
| I don't know what you mean by the primaries replicated. What is your intention with replication?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2008-01-16 : 12:34:08
|
quote:
Originally posted by tkizer
I don't know what you mean by the primaries replicated. What is your intention with replication?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
We have a primary site and backup site each with a primary and secondary database node. We want to mirror the primary and secondary nodes and then replicate the primary nodes across the primary and backup.
Future guru in the making. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-01-16 : 15:18:18
|
| I thought you weren't using clustering. I'm confused by your use of the word node, which is a clustering term. There is no issue with replicating data between databases and also using database mirroring. You should be aware of the transaction log implications for both solutions though. If either breaks and it isn't fixed in a timely manner, you could blow out the logs due to the data being stored in the tlog waiting for the process to start to work again.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2008-01-17 : 11:10:13
|
We aren't using clustering, I was using node as a general term, not exclusive to clustering. I will keep the log implications in mind, thanks for the input.
Future guru in the making. |
|
|
|
|
|
|
Database mirroring and Transactional Replication