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 |
|
Kassem
Starting Member
7 Posts |
 Posted - 2008-06-30 : 03:27:01
|
| Hii hope that you can help me , I m working on SQL server 2005 using transactional continus Replication. i have a problem "Missing Data" the problem : some of data enter in a branch is not posted to another branch , and they deleted from the original branch , this is the real example for our situation :1- i have 2 tables (Main --> Details )in the database with cascading update and delete , no identity key , the structure for them are : table 1 : Main - Vr_id nvarchar (10) key - vr_type int key - ..... table 2 : Details - VD_id nvarchar (10) key - vd_type int key - seq int key - ............... when i make a transaction in the branch A the data save in the 2 tables main and details , after couple of hrs , the data is missing from the main table and still in the details table in branch A ?!!!!(even i have a cascading delete between the 2 tables ) !!!!but is not replicated to the branch B even the data in the details tableNow i can find data in table details in branch A is not in branch B and the Synchronization status "No Transaction to replicated" i have nothing to do now , i still make searching for the solution please if u have any idea or solution for this type of problems , tell me what i can do to fix it .Regards ................ Makkeh Kassem |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-30 : 06:46:28
|
| Where is the publisher? Do you have updateable transactional or simply transactional? If you do not have updateable transactional replication set up, then any changes to the subscribers will not be copied back to the publisher and therefore not diseminated back through all the servers. |
 |
|
|
Kassem
Starting Member
7 Posts |
Posted - 2008-06-30 : 07:08:28
|
| Hi RickDI have updateatble transactional , and please note that not all the data are missing , some time a part of the transaction is missing from the Main table in the subscriber ,do u think is a problem in the connection coz , i use VPN connection and not always up ?thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-30 : 22:43:10
|
| Check status in replication monitor, ensure there is no non-replicated rows in publication. |
|
|
|
Kassem
Starting Member
7 Posts |
Posted - 2008-07-01 : 02:30:41
|
| I check the Status in the replication monitor , it's no replicated transaction this problem happen when the connectivity go down more then 10 hrs between the publisher and subscriber ? |
|
|
|
Kassem
Starting Member
7 Posts |
Posted - 2008-07-01 : 03:19:15
|
| Please note that , i have 1 publisher A and 2 subscriber B , C now i have loss of data in the Subscriber C cause the Publisher is reintialise again the Subscriber C (Reason : Fail Validation ) !!!!!!!!!!!!!!!!!!!!?????????????????? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-01 : 23:22:44
|
| It's not easy to resync dbs when one site went down for long time in two way replication, may contact Microsoft for help. |
|
|
|
Kassem
Starting Member
7 Posts |
Posted - 2008-07-02 : 01:54:16
|
| Thanks rmiao |
|
|
|
|
|
|
|
|
Replication Data Missing