Help to Remove Replication
Mon, 25 Aug 2008 17:28:01 -0700
Distribution database files were lost because of the disk failure.
We decided to remove completely replication from the server.
I used exec sp_dropdistributor, sp_dropdistributiondb, sp_removedbreplication
I also run delete msdb..msdistributiondbs
After all, I do not have any records in
select * from mas ...
|
Can't change server name for publication & subscription
Mon, 25 Aug 2008 13:58:10 -0700
I have two SQL servers, one that publishes parts of a database to another SQL
server to help offload some of the work. Tonight i am renaming my SQL server
with the subscription, but when i look at the properties for the Publication
on the other server, the old server name is in there, and it's grayed out so
...
|
troubleshooting Transactional Replication Latency
Sat, 23 Aug 2008 09:16:12 -0700
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 ...
|
Beginning Replication
Sat, 23 Aug 2008 10:31:50 -0400
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 ...
|
How to start synchronization from program
Fri, 22 Aug 2008 20:44:23 -0700 (PDT)
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 ru ...
|
Cross Database Replication
Fri, 22 Aug 2008 09:14:01 -0700
Is it possible to setup a table in one database to replicate to table in
another database on the same machine? ...
|
Synchronization of replicated SQL Express database in Vista
Fri, 22 Aug 2008 02:28:00 -0700
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 ...
|
|
|
SQL2005 / SP2 / Setting replication clean-out metadata
Thu, 21 Aug 2008 17:43:48 -0430
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 t ...
|
Effects of reboot on SQL2005 Merge Replication?
Thu, 21 Aug 2008 06:18:01 -0700
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 ...
|
Error 14151: schema script could not be propagated to the subscrib
Thu, 21 Aug 2008 05:49:01 -0700
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 t ...
|
