Log size increasing
Fri, 18 Jul 2008 07:04:14 -0700
Hi,
I have set up transactional replication for ten tables. However, after a
month the log size on the publisher has started growing and it has become 50
GB in size. What should be done to decrease the log size and to keep it
small. Thanks in advance. ...
|
SQL Server 2005 Start a transactional replication (push) using a
snapshot on a DVD
Fri, 18 Jul 2008 10:53:14 +0200
Hello,
We would like to test a transactional replication (push) using a
snapshot recently copied on a DVD. Did anyone try this ?
Thank's in advance for your answers,
Regards,
Karine ...
|
merge replication conflict
Thu, 17 Jul 2008 16:52:03 -0700
Hi SQL server expert,
I have a merge replication. The table has a primary key and an identity
column.
when I insert one row at the publisher and one row at the subscriber with
the same key,
I got two conflicts after syncronization, nothing got syncronized. What I
would like it to do was to let the publish ...
|
Merge Replication
Thu, 17 Jul 2008 13:09:13 -0700
We have Server A, which is running Merge replication and acting as Publisher
and Distributor.
We have new server C which we needs to move our replication from A to this.
Server B is the only subscriber
Right now we have established the logshipping on server A to server C
And the plan was to stop ...
|
Change Publication Name
Thu, 17 Jul 2008 11:44:50 -0700 (PDT)
We have a problem with sp_repladdcolumn. We have publication names
that have a comma in them. This causes sp_repladdcolumn not to work
right. Is there a way to rename a publication without having to drop,
recreate, or reinitialize?
Thanks,
Ken ...
|
Replicate same table different filters
Wed, 16 Jul 2008 19:44:55 GMT
SQL2000 Enterprise Edition SP3a
I have transaction replication set up between two servers, nothing out of the
ordinary. I need one of the tables being published to be filtered two
different ways to the same subscriber.
For example:
TableA being published all rows and columns to TableA on the subscriber.
...
|
alter table and snapshot replication
Wed, 16 Jul 2008 03:41:05 -0700 (PDT)
Hello everyone,
I have 2 tables that I need to change the identity column to 'NOT FOR
REPLICATION' in order to my snapshot replications to work.
What is really going on and I would like to fix is that the subscriber
databases dont get any indexes and most of the primary keys. I dont
know what was the situat ...
|
|
|
Why aren't nonclustered indexes/constraints appearing in subscriber
Tue, 15 Jul 2008 14:23:02 -0700 (PDT)
I have transactional replication set up for sql 2005. I have
nonclustered primarykeys, several check constraints and other
nonclustered indexes in my publisher db. My subscriber db for some
reason got the primary key indexes but not the check constraints or
the nonclustered indexes. Not having the nonclustere ...
|
Non-unique identifier for table with auto-increment PK
Tue, 15 Jul 2008 22:22:10 +0100
Hi
I am trying to merge publish a sql server 2005 database using sql server
200o options. The publishing wizard wants to add a uniqueidentifier column
to a table even though the table has an auto-increment PK. Why is that? How
can I add a uniqueidentifier column myself?
Thanks
Regards
...
|
Repl Log Reader Leaving Transaction Open
Tue, 15 Jul 2008 14:49:39 -0600
We have set up our SQL Server 2005 production server to do transactional
replication (one way) to a reporting server with a push subscription. It
appears that the replication log reader continuously maintains an open
transaction. If I try to kill the spid it quickly returns and remains open
again. Is this no ...
|
