SQL Server Replication announcement
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky1Votes
Reminder - please indicate if a reply has answered your question.
How do I indicate a post answered my question? If a post has answered your original question, please indicate this by clicking on the "Mark as Answer" button ...4 Replies | 35361 Views | Greg Y - Thursday, December 07, 2006 8:22 PM | Last Reply Harry SQL DBA - Saturday, February 19, 2011 5:43 AM
-
Unanswered0Votes
Side by Side upgrade of replicated databases from SQL 2000 to SQL 2012
Hello, We are in the process of upgrading multiple databases from SQL 2000 to SQL 2012 (via SQL 2008 R2) using side by side technique. One of the databases to be upgraded is ... -
Unanswered0Votes
delete 'repl_distributor' from linked-server on publish and distributor by mistake
I deleted delete 'repl_distributor' from linked-server on publish and distributor by mistake by kept on distributor. By now, I didn't find any side effect except can't insert trace token from ...0 Replies | 62 Views | Archer long - 13 hours 9 minutes ago -
Unanswered0Votes
Some of my log readers are failing - jobs show "Waiting for Worker Thread" status!
Good afternoon, Recently, I added a few more transactional replications to my SQL Server 2008 R2 replication set and I began noticing some problems. I now have 29 transaction ...2 Replies | 76 Views | MBCDev - Friday, July 05, 2013 6:08 PM | Last Reply MBCDev - 14 hours 28 minutes ago -
Unanswered0Votes
Database mirroring Error
I am getting below error when I am trying set partner to principal server Error: 1474, Severity: 16, State: 1. Database mirroring connection error ...2 Replies | 97 Views | J P IT - Friday, July 05, 2013 9:17 PM | Last Reply rksqldba - 20 hours 48 minutes ago -
Answered0Votes
The merge process could not enumerate deletions at the 'Publisher'.
Hi All, I use merge replication with pull subscribtions. Since yesterday I started to receive errors stating: The merge process could not enumerate deletions at the ...3 Replies | 3070 Views | alekpo - Wednesday, July 27, 2011 2:47 PM | Last Reply Pradeep Adiga - Friday, July 05, 2013 6:28 PM -
Answered0Votes
Merge replication keeps sending the snapshot over and over
I have a merge replication setup on a Server 2003, MS SQL 2005 server. It has one subscriber. When the merge is initiated, it creates a snapshot and starts to bulk copy the data into the ...20 Replies | 1455 Views | aab123 - Friday, December 14, 2012 9:45 PM | Last Reply Ranjeet Kumar Panda - Friday, July 05, 2013 11:29 AM -
Unanswered0Votes
Sql Server Replication for ORACLE data sync
While creating the oracle publisher, getting the below error Failed to execute the HREPL.INITPUBLISHER request to Oracle Publisher 'ORCL'. Verify that the Oracle package code exists ...0 Replies | 89 Views | Amit dotnet - Friday, July 05, 2013 9:48 AM -
Unanswered0Votes
how to view the inserted ,updated records going to replicate in merge replication
how to view the inserted ,updated records going to replicate in merge replication Regards Mohanraj..0 Replies | 76 Views | Mohanraj G - Friday, July 05, 2013 7:32 AM -
Unanswered0Votes
SQL Server 2012 Merge Replication Issue - Inserted Data on Subscriber get deleted after successfully synced back to the Publishers
Hi all, I have just encountered this weird issue with our Merge Replication Setup. We have a primary ...2 Replies | 134 Views | douglasle - Thursday, July 04, 2013 4:37 AM | Last Reply douglasle - Friday, July 05, 2013 2:11 AM -
Unanswered0Votes
The process could not connect to Subscriber
trying to make a new replication for sql server 2008 running on windows 7 to sql server 2008 running on windows server 2008 but i'm always getting: The process could not connect to Subscriber. I have ...6 Replies | 4554 Views | salah chebaro - Wednesday, August 03, 2011 1:24 PM | Last Reply jose luis rivas - Thursday, July 04, 2013 10:57 PM -
Unanswered0Votes
The merge process could not enumerate changes at the 'Subscriber'.
I have two SQL 2005 Standard servers using merge replication, and out of the blue started getting failure notices regarding "The merge process could not enumerate changes at the ...8 Replies | 11214 Views | Scotty Davis - Wednesday, April 19, 2006 1:37 PM | Last Reply Mohanraj G - Thursday, July 04, 2013 6:04 PM -
Unanswered0Votes
How to sync the sync for specific table.
How to sync the sync for specific table at first . (for one time activity).??? Regards Mohanraj..1 Replies | 99 Views | Mohanraj G - Thursday, July 04, 2013 12:33 PM | Last Reply Pradeep Adiga - Thursday, July 04, 2013 4:34 PM -
Unanswered0Votes
MS SQL Server 2005 - snapshot generation issue
Hi. I would like to share with you a weird problem we noticed at work. We are running MS SQL server 2005. When generating initial snapshot we are setting the name ...1 Replies | 109 Views | LC85 - Thursday, July 04, 2013 8:45 AM | Last Reply Hilary Cotter - Thursday, July 04, 2013 11:52 AM -
Discussion0Votes
When to use Merge Replication
I am using slow link agent profile as there are network connectivity issues =>The publisher is SQL Server 2008 Standard edition with 4GB Ram on 32 bit ...7 Replies | 164 Views | Mayaaa - Tuesday, July 02, 2013 5:46 AM | Last Reply Mayaaa - Thursday, July 04, 2013 4:29 AM -
Answered0Votes
distribution database size so big
HI, i got issue with my distribution database. the max retention already set to 48 hours and the automated job run every 10 minutes, but still the database size is huge. about 350 ...5 Replies | 1104 Views | kneeah - Friday, November 23, 2012 2:45 AM | Last Reply xristod - Wednesday, July 03, 2013 7:53 PM -
Unanswered0Votes
how to replicate user defined table type
I am creating a user define table type and would like replicate it to subscriber. However, I could not find it from publisher's articles list. Is there anyway to do ...2 Replies | 140 Views | TravelMan - Wednesday, July 03, 2013 4:04 AM | Last Reply TravelMan - Wednesday, July 03, 2013 1:27 PM -
Unanswered0Votes
The certificate <certname> cannot be dropped because it is bound to one or more database encryption key
Hi there, I am trying to recreate a database from a live backup file that was provided to us. Before I perform the restore, the ...1 Replies | 120 Views | AdamDonohoe - Wednesday, July 03, 2013 8:38 AM | Last Reply rksqldba - Wednesday, July 03, 2013 9:11 AM -
Unanswered0Votes
Invalid object name 'MSmerge_cpmv_0EAF7516BA284880950D495D478AC1EE'
Am receiving an error. Invalid object name 'MSmerge_cpmv_0EAF7516BA284880950D495D478AC1EE' Any idea how to troubleshoot them apart from ...2 Replies | 135 Views | KEROBIN - Wednesday, July 03, 2013 6:46 AM | Last Reply KEROBIN - Wednesday, July 03, 2013 7:08 AM -
Proposed2Votes
Metadata is not cleaning up - sp_MSmark_expired_subscriptions Performance
SQL 2008 R2 64Bit - 600 Subscribers Publisher/Distributor box has been increasingly suffering from excessive Blocking & ...2 Replies | 141 Views | GWilliy - Tuesday, July 02, 2013 11:00 AM | Last Reply GWilliy - Tuesday, July 02, 2013 9:13 PM -
Unanswered0Votes
Replication SQL Server 2008 to 2000 - incorrect syntax near max
Hello, We are attempting to resolve an issue stopping our backup server (SQL Server 2000) from properly performing replication from the production server (2008 ...5 Replies | 154 Views | Trevor Watson - Tuesday, July 02, 2013 1:30 PM | Last Reply Tom Phillips - Tuesday, July 02, 2013 8:35 PM - Items 1 to 20 of 9201 Next ›