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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 help with transactional replication

Author  Topic 

greatsqldba
Starting Member

11 Posts

Posted - 2011-06-09 : 21:33:20
Transactional replication is deployed within the environment to provide a near real-time copy of data that is critical to business processes. The data set being replicated contains several hundred million rows of data and receives several million changes on a daily basis. It is critical that this data is always synchronized with the source. How do you determine if the data is synchronized? If you determine that the data is not in synch, how do you get the subscriber corrected and everything functioning again?

Thanks in advance for any help.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2011-06-09 : 22:30:07
Homework?

CODO ERGO SUM
Go to Top of Page

greatsqldba
Starting Member

11 Posts

Posted - 2011-06-10 : 10:58:18
quote:
Originally posted by Michael Valentine Jones

Homework?

CODO ERGO SUM



Yes, has to be precise...this guy is unforgiving which is what he is paid to be...but...
Go to Top of Page
   

- Advertisement -