SS2K5 Replication

• Topics

  Started by

  Posts

  Last post

• What would change is_not_for_replication from 0 to 1 for all foreign keys?

  I have encountered an issue with foreign key options is_not_for_replication and is_not_trusted (vie…

  Mike G.

  1 replies

  15 years, 11 months ago

  By: Mike G.

• Deleting Orphaned SYNC_ and FLTR_ views in sysobjects

  I’m having a problem when I restore a SQL 2000 backup on a SQL 2005 server. The SQL 2000 backup wa…

  Mike G.

  3 replies

  15 years, 11 months ago

  By: Mike G.

• for large database processing

  hi i have initially 10 millions of data in single table of sql server 2005 with 10 millions rows. n…

  mayank jarsaniya

  4 replies

  15 years, 11 months ago

  By: mayank jarsaniya

• Pls help me in SQL 2005 Migration

  Hi All, I have installed SQL 2005 in my server. The service pack installed is SP1. After installa…

  deepzzzz

  3 replies

  15 years, 11 months ago

  By: deepzzzz

• Replication Failure

  Hi, Faced failure in replication with below error message. DELETE Statement Conflicted with COLUMN …

  M&M

  4 replies

  15 years, 11 months ago

  By: Roy Ernest

• Transactional latency issues between Distributor and Subscriber

  Latency between our Distributor and the Subscriber is usually is less than 10 seconds. However some…

  RML51

  5 replies

  15 years, 11 months ago

  By: RML51

• Conflict Alerts

  I am very new to replication and we occasionally get some conflicts on a specific article that are …

  jyusko

  1 replies

  15 years, 11 months ago

  By: abv_by

• Maxcmdsintran worth using?

  Just trying to gather other people's views. Has anyone seen setting this on the logreader turn out …

  Shark Energy

  2 replies

  15 years, 11 months ago

  By: Ian Scarlett

• Beginner at replication - How can you tell how often replication kicksoff?

  I'm a beginner at replication, and trying to look at an existing replication job. From server A to …

  tan110

  7 replies

  15 years, 11 months ago

  By: Roy Ernest

• Distributor DB deleted need to attach files?????

  Okay here's what I did to screw up my day. 1. I had to move file to a new drive but had no way to m…

  lkennedy76

  2 replies

  15 years, 11 months ago

  By: Steve Jones - SSC Editor

• Handling Identities @ subscriber when using replication as a DR scenario

  The Issue/facts I have a replicated system 2 nodes running transactional replication on 2005 The ta…

  John LaSpada

  1 replies

  15 years, 11 months ago

  By: Shark Energy

• Distribution Cleanup Job removes 0 transactions despite all trans being delivered to subscribers

  I'm currently experiencing an issue where my distribution database is growing rather rapidly, at ar…

  Matthew Darwin

  3 replies

  15 years, 11 months ago

  By: Steve Jones - SSC Editor

• "REPLICATION REBUILD INDEX, REORGANIZE INDEX AND UPDATE STATISTCS IN REPLICATION TRANSACTIONAL."

  Hi, I have a transactional replication. I rebuild index and/or reorganize index and update statisti…

  noelia.lago

  2 replies

  15 years, 12 months ago

  By: noelia.lago

• SQL SERVER 2005 REPLICATION (SNAPSHOT ERROR)

  I'm trying to generate a snapshot of 41 articles (all tables).  I've been getting this error w…

  Steve-3_5_7_9

  2 replies

  15 years, 12 months ago

  By: rpcasey001

• Can a SQL Server 2005 Publisher use a SQL Server 2008 Distributor?

  We are in the initial stages of designing a transactional replication architecture where the publis…

  Anthony Sammartino

  1 replies

  15 years, 12 months ago

  By: Anthony Sammartino