Advice on changing retention period
Tue, 7 Oct 2008 14:00:59 -0700 (PDT)
We are looking at changing the retention period for our replication
from 14 days to 21 days and before doing so wanted to get some advice.
1) Most importantly, if I make the change, will it force the
subscribers to reinitialise or cause any other similar operational
issues or will it be fairly transparent as f ...
|
Installing Replication Component
Tue, 7 Oct 2008 12:43:24 -0400
I get this message when I try to setup Replication
"The replication Component was not included when SQL Server was installed on
<Instance1>"
We have a 2 node SQL 2000 active-active cluster.
Is there a way we can add(install) the Replication component over existing
installation(Instance1) with minimal impact ...
|
Unexpected eof encountered in bcp data file...msmerge_genhistory90.bcp
Sat, 4 Oct 2008 07:02:13 -0700 (PDT)
Creating a new merge replication on SQL 2005 and the snapshot fails.
When I run the bcp command from the command prompt it returns the
unexpected EOF. The source file is msmerge_genhistory90.bcp and the
destination is the msmerge_genhistory table on the subscriber. The
BCP file does exist in the specified fold ...
|
Unexpected eof encountered in bcp data file...msmerge_genhistory90.bcp
Fri, 3 Oct 2008 20:17:02 -0700 (PDT)
Creating a new merge replication on SQL 2005 and the snapshot fails.
When I run the bcp command from the command prompt it returns the
unexpected EOF. The source file is msmerge_genhistory90.bcp and the
destination is the msmerge_genhistory table on the subscriber. The
BCP file does exist in the specified fold ...
|
Transactional Replication - Primary key ??
Fri, 3 Oct 2008 12:48:54 -0400
Is there a way to replicate a table that doesn't have a primary key?
Thank you
...
|
Transactional Replication - Primary key ??
Fri, 3 Oct 2008 12:48:54 -0400
Is there a way to replicate a table that doesn't have a primary key?
Thank you
...
|
Delete Publication
Fri, 3 Oct 2008 03:18:24 -0700 (PDT)
I get following error when i Try to delete a subscription. The
Distributor and Subscribers are all not available since the network is
not available. How can i remove the subscription even when Distributor
and Subscriber servers are not available ...
|
|
|
How do I deal with a DB failure manually?
Thu, 2 Oct 2008 05:38:26 -0700 (PDT)
Hey everyone
I have 2 machines running SQL Server 2005, and have set up mirroring
for the DB, and the mirror is synchronized. SVR1 is the Principal, and
SVR2 is the mirror.
I want to simulate a failure of the principal, and do a MANUAL
recovery. Here is what I do:
1. Shut down SVR1.
2. The status of t ...
|
replication stored procedure name changed after applied kb954606
Wed, 1 Oct 2008 12:38:21 -0700
We applied kb954606 to our sql 2005 sp2 32 bit test server. The replication
stored procedure names in the user databases were changed. The names
changed with encryption code. The application stop working.
eg. sp name changed to : sp_MSsync_upd_2721C21E_9892_4F57_BE66_3A1EE134C3C9
We uninstalled kb95 ...
|
Error trying to update the value of a Row Filtered Column value
Tue, 30 Sep 2008 21:02:43 -0700 (PDT)
I have Row Filtered Transaction Replication setup - I want to breakout
a table by year so the filter is YEAR([datefield]] = 2005 for example.
There are 3 databases that subscribe to 3 separate publications; 1 for
each year. The databases are called D_2004, D_2005, D_2006 .
For a test to see if a record would ...
|
