Replication

troubleshooting Transactional Replication Latency
Hi everybody. SERVER_A: Windows 2003 Server with SQL Server 2005 SP2. This is the corporative server for all our data. About 30 tables divided in 4 publications. Each publication contains the tables belongs at the same database. This is the suscriber of one publication I describe below. SERVER_B: Windows 20... 23 Aug 2008 13:30

Beginning Replication
Hi I am not very experienced in Sqlserver2k administration. I do mostly scripting. I need to replicate/synchronize/update data between our company server at our head office in Massachusetts running Sqlserver2K standard edition with a desktop at our Manhattan sales office running Sqlserver2K personal edi... 25 Aug 2008 10:21

How to start synchronization from program
Hi to everyone. I have 2 sql servers 2000 running merge replication. Sometimes the publisher has an error saying that it cannot connect to the subscriber, and there is a red "x" on the replication agent. What I do is right click it and click Start Synchronization. My question is: Is there a way for me to run t... 24 Aug 2008 07:49

Cross Database Replication
Is it possible to setup a table in one database to replicate to table in another database on the same machine? ... 23 Aug 2008 13:30

Synchronization of replicated SQL Express database in Vista
Hello, I have created a merge pull replication from SQL Server 2005 to Windows clients running SQL Express 2005. The clients should be able to work offline with the replicated database and synchronize when on-line. In Windows XP this is no problem: the Synchronize tab in the Tools menu of Explorer shows the ... 26 Aug 2008 03:47

Repl Log Reader Leaving Transaction Open
We have the same issue. This also causes the log file to grow, as it cannot free space internally. If you look at log_reuse_wait in sys.databases you will find that the log is waiting for replication to free space. Changing the backup mode, backing up and shrinking, and any number of other appraches have fa... 21 Aug 2008 22:42

SQL2005 / SP2 / Setting replication clean-out metadata
Hi everyone, We were affected by a bug in SQL that seems to be fixed in the cumulative update 8. We basically had lots of records in msmergecontents in status = 4. Now that seems to be corrected, however, as a workaround we had set the publications to never expire. We would like to change that setting to s... 21 Aug 2008 18:37

Effects of reboot on SQL2005 Merge Replication?
Hi, Can anyone confirm what happens when either of 2 SQL 2005 servers configured for continous merge replication are rebooted? Will the replication just pick up and carry on, or must it be manually started again? Many thanks, FD ... 26 Aug 2008 05:49

Error 14151: schema script could not be propagated to the subscrib
I am setting up replication between two sql2005 servers. One being the distributor/publisher and the other being the sole subscriber. I have created 2 publications, tables only, one with about 15 articles the other with only 2 articles. I have created push subscriptions to the subscriber for each. Both of thes... 21 Aug 2008 09:21

replicaiton failed with:A system assertion check has failed
Hi folks We run 2005 sp2 on 32 bit. I am setting tr. replication. After snapshot applied, log reader can't start with a message: The process could not execute 'sp_repldone/sp_replcounters' on 'MEMTOOLSSQL04'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help: http://help/MSSQL_REPL20011 A system a... 21 Aug 2008 08:20