This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
  • TechNet
  • Products
  • IT Resources
  • Downloads
  • Training
  • Support
Products
  • Windows
  • Windows Server
  • System Center
  • Microsoft Edge
 
  • Office
  • Office 365
  • Exchange Server
 
  • SQL Server
  • SharePoint Products
  • Skype for Business
  • See all products »
Resources
  • Channel 9 Video
  • Evaluation Center
  • Learning Resources
  • Microsoft Tech Companion App
  • Microsoft Technical Communities
  • Microsoft Virtual Academy
  • Script Center
  • Server and Tools Blogs
  • TechNet Blogs
 
  • TechNet Flash Newsletter
  • TechNet Gallery
  • TechNet Library
  • TechNet Magazine
  • TechNet Wiki
  • Windows Sysinternals
  • Virtual Labs
Solutions
  • Networking
  • Cloud and Datacenter
  • Security
  • Virtualization
Updates
  • Service Packs
  • Security Bulletins
  • Windows Update
Trials
  • Windows Server 2016
  • System Center 2016
  • Windows 10 Enterprise
  • SQL Server 2016
  • See all trials »
Related Sites
  • Microsoft Download Center
  • Microsoft Evaluation Center
  • Drivers
  • Windows Sysinternals
  • TechNet Gallery
Training
  • Expert-led, virtual classes
  • Training Catalog
  • Class Locator
  • Microsoft Virtual Academy
  • Free Windows Server 2012 courses
  • Free Windows 8 courses
  • SQL Server training
  • Microsoft Official Courses On-Demand
Certifications
  • Certification overview
  • Special offers
  • MCSE Cloud Platform and Infrastructure
  • MCSE: Mobility
  • MCSE: Data Management and Analytics
  • MCSE Productivity
Other resources
  • Microsoft Events
  • Exam Replay
  • Born To Learn blog
  • Find technical communities in your area
  • Azure training
  • Official Practice Tests
Support options
  • For business
  • For developers
  • For IT professionals
  • For technical support
  • Support offerings
More support
  • Microsoft Premier Online
  • TechNet Forums
  • MSDN Forums
  • Security Bulletins & Advisories
Not an IT pro?
  • Microsoft Customer Support
  • Microsoft Community Forums
SQL Server
 
Sign in
United States (English)Drop down arrow
Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語)
 
 
Home20122008 R2200820052000LibraryForums
Ask a question
Quick access
  • Forums home
  • Browse forums users
  • FAQ
Announcement: 1

SQL Server Replication announcement

  • Link
    SQL Server 2005 SP3 is now available
    Greg Y Thursday, December 18, 2008 5:10 AM
    SQL Server 2005 SP3 is released, access it here.

    Read about what's new for Replication here.

    Many replication bugs were fixed in SP3, you can find your way through them here.

  • Remove From My Forums

Forums [ view all ]

Selected forums

Clear
SQL Server Replication
x
Filter : All threads
All threads
Answered
Unanswered
Proposed answers
General discussion

No replies
Helpful
Has code

All languages
Sort : Most recent post
  • Most recent post
  • Most recent thread
  • Total votes
  • Total replies
  • large check mark
    2 Votes

    Reminder - please indicate if a reply has answered your question.

    SQL Server
     > 
    SQL Server Replication
    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 ...
    Sticky | 4 Replies | 48154 Views | Created by Greg Y - Thursday, December 07, 2006 8:22 PM | Last reply by Harry SQL DBA - Saturday, February 19, 2011 5:43 AM
  • large check mark
    0 Votes

    Drop rogue Subscription issue.

    SQL Server
     > 
    SQL Server Replication
    Greetings. We're having an issue dropping a Subscription on the Subscriber database, even though the Publication has already been removed from the Publisher. We're not sure how we ...
    Answered | 10 Replies | 187 Views | Created by ChrisRDBA - Monday, March 19, 2018 6:33 PM | Last reply by ChrisRDBA - 18 hours 25 minutes ago
  • large check mark
    0 Votes

    Timeout error on snapshot

    SQL Server
     > 
    SQL Server Replication
     I have a post snapshot script that gets applied after the snapshot is loaded to the subscriber whenever I reinitialize my replication, few times I keep getting the query timeout errors ...
    Answered | 3 Replies | 40 Views | Created by prudhvi1589 - Monday, April 23, 2018 5:36 PM | Last reply by prudhvi1589 - Monday, April 23, 2018 9:56 PM
  • large check mark
    1 Votes

    Article addition causes severe locking,High waiting task in SQL server 2016 Transactional Replication

    SQL Server
     > 
    SQL Server Replication
    Problem Description: Unusual High Waiting Tasks & Sudden dip in CPU usage with lots of locking while try to add an article Table(s) in an existing Transactional Replication ...
    Unanswered | 2 Replies | 134 Views | Created by MI00712 - Monday, April 16, 2018 6:55 AM | Last reply by Bartosz Lewandowski - Monday, April 23, 2018 4:29 PM
  • large check mark
    0 Votes

    CDC to offload operational database - Need f a read-only replica

    SQL Server
     > 
    SQL Server Replication
    Hi experts I need to replicate an operational database to offload it from ad-hoc reporting and other readonly operations. These adhoc  queries sometimes take 50% of the ...
    Unanswered | 3 Replies | 52 Views | Created by uldoman - Monday, April 23, 2018 11:23 AM | Last reply by Hilary Cotter - Monday, April 23, 2018 4:25 PM
  • large check mark
    0 Votes

    Merge Replication failover

    SQL Server
     > 
    SQL Server Replication
    Hi, I have merge replication between 4 databases where one is publisher and the rest are subscribers but if publisher is down replication stops. Are there any ways to prevent one point of failure to ...
    Answered | 1 Replies | 54 Views | Created by Gumvert - Friday, April 20, 2018 1:42 PM | Last reply by Hilary Cotter - Friday, April 20, 2018 2:36 PM
  • large check mark
    0 Votes

    Can i clear the content of "MSmerge_past_partition_mappings" ?

    SQL Server
     > 
    SQL Server Replication
    What will happen if i deleted the content of "MSmerge_past_partition_mappings" metadata table ? I think it should be fine, since it stores old tracking ...
    Unanswered | 12 Replies | 2477 Views | Created by Abdo Ahmed - Sunday, June 02, 2013 4:46 AM | Last reply by Hilary Cotter - Thursday, April 19, 2018 7:35 PM
  • large check mark
    0 Votes

    Strange error in Profiler while trying to diagnose another issue.

    SQL Server
     > 
    SQL Server Replication
    Folks, I'm trying to diagnose a completely separate issue(or it may be not but we'll see) related to web merge replication. The environment is a SQL 2008 R2 server and separate web ...
    Answered | 2 Replies | 68 Views | Created by andyew - Monday, April 16, 2018 3:55 AM | Last reply by Martin.Cairney - Monday, April 16, 2018 12:29 PM
  • large check mark
    0 Votes

    Transaction replication

    SQL Server
     > 
    SQL Server Replication
    Hi We have Transaction replication has configured from 2008 R3 to 2014 (pull subscriptions) . Technically working fine. Now I need to configure other replication from  same prod DB on ...
    Proposed | 3 Replies | 105 Views | Created by ashwan - Monday, April 09, 2018 1:29 PM | Last reply by Hilary Cotter - Friday, April 13, 2018 2:18 PM
  • large check mark
    0 Votes

    Why is Subscriber consistently using 25GB RAM?

    SQL Server
     > 
    SQL Server Replication
    Hi everyone, I'd like to preface this by saying that this is the first time I've set up replication in any form, and as such I'm at a loss as to why my subscriber DB instance is ...
    Unanswered | 2 Replies | 95 Views | Created by C Backlund - Wednesday, April 11, 2018 9:41 PM | Last reply by Hilary Cotter - Thursday, April 12, 2018 2:24 PM
  • large check mark
    0 Votes

    DR for On-premise Hyper V Clustered SQL servers and NLB based Web app Server for Azure with 15 minutes of replication

    SQL Server
     > 
    SQL Server Replication
    I am looking for DR option for On-premise Clustered SQL servers and NLB based Web app Server for Azure with 15 minutes of replication but on Azure all VM's should not be running ...
    Proposed | 1 Replies | 73 Views | Created by sunilsharma2012 - Thursday, April 12, 2018 4:55 AM | Last reply by Pirlo Zhang - Thursday, April 12, 2018 9:54 AM
  • large check mark
    0 Votes

    Merge Replication SP Conflict Resolver

    SQL Server
     > 
    SQL Server Replication
    Hi All, Running SQL Server 2008 R2 in a merge replication topology with pull subscriptions.  Publisher and Distributor are on same machine.  ...
    Unanswered | 10 Replies | 217 Views | Created by 2012S4 - Friday, March 30, 2018 2:37 AM | Last reply by Hilary Cotter - Monday, April 09, 2018 7:01 PM
  • large check mark
    0 Votes

    Data replication question

    SQL Server
     > 
    SQL Server Replication
    We are planning to do the following: 1. Create a new database with SQL 2016 Ent edition 2. Replicate data from this new SQL 2016 db to existing SQL 2008R2 env, ...
    Unanswered | 6 Replies | 209 Views | Created by sqldev1 - Thursday, April 05, 2018 4:00 AM | Last reply by Hilary Cotter - Monday, April 09, 2018 2:28 PM
  • large check mark
    0 Votes

    SQL Replication reg.

    SQL Server
     > 
    SQL Server Replication
    We have 4 SQL server 2008 version we have transaction replication between A pair of DB / Server and Pair of SQL mirror between 2 Db Servers. Kindly the see Present scenario of ...
    Proposed | 5 Replies | 160 Views | Created by Jagskml - Tuesday, March 27, 2018 6:58 AM | Last reply by Tom Phillips - Monday, April 09, 2018 1:13 PM
  • large check mark
    0 Votes

    snapshot delivered, then reapplied

    SQL Server
     > 
    SQL Server Replication
    I initialized transactional replication from a current snapshot, waited 9 hours while the snapshot was applied and received the message that the snapshot had been successfully delivered. While I ...
    Unanswered | 4 Replies | 109 Views | Created by JayMeerdink - Monday, April 02, 2018 1:48 PM | Last reply by JayMeerdink - Thursday, April 05, 2018 2:57 PM
  • large check mark
    0 Votes

    Merge Replication what is the order of processing of downloaded pre sch bcp files at Subscriber?

    SQL Server
     > 
    SQL Server Replication
    I'm not sure I'm going to get too much help here as this is really in the bowels of SQL Merge Replication but here goes. I have two publications. One that contains tables. Works ...
    Answered | 2 Replies | 98 Views | Created by andyew - Wednesday, April 04, 2018 2:42 AM | Last reply by andyew - Thursday, April 05, 2018 2:14 AM
  • large check mark
    1 Votes

    Test handling SQL replication errors. RAISERROR seems to not work with MSSQL_REPL errors numbers

    SQL Server
     > 
    SQL Server Replication
    Folks, I'm not specifically after assistance with the error I'm dealing with although if someone has a clue to fix the actual issue that would be great. My question relates to ...
    Unanswered | 2 Replies | 126 Views | Created by andyew - Wednesday, March 28, 2018 4:51 AM | Last reply by andyew - Wednesday, April 04, 2018 2:19 AM
  • large check mark
    0 Votes

    Tran. replication best practice

    SQL Server
     > 
    SQL Server Replication
    Are there any best practices for setting up article properties of "statement deliver" for update  / delete / insert. I assume by default SQL Server executes bunch of internal stored ...
    Proposed | 3 Replies | 123 Views | Created by ManOfSteel75 - Friday, March 30, 2018 4:41 PM | Last reply by Hilary Cotter - Tuesday, April 03, 2018 2:43 AM
  • large check mark
    0 Votes

    SQL Replication - rebuilding MSReplication_Objects indexes and Stats system tables.

    SQL Server
     > 
    SQL Server Replication
    Fellow SQLers I have a subscription database that I have built index rebuilds and stats updates that will run weekly. As a best practice for my indexing stats routine, I ...
    Answered | 3 Replies | 144 Views | Created by mg101 - Sunday, April 01, 2018 2:53 PM | Last reply by Hilary Cotter - Monday, April 02, 2018 3:11 PM
  • large check mark
    0 Votes

    difference bwn distribution property vs publication property

    SQL Server
     > 
    SQL Server Replication
    can someone tell me difference between distribution agent property of "Transaction retention" and "history retention" period VS the publication property of "Subscription ...
    Unanswered | 3 Replies | 134 Views | Created by ManOfSteel75 - Thursday, March 29, 2018 1:46 AM | Last reply by Hilary Cotter - Friday, March 30, 2018 3:11 PM
  • large check mark
    3 Votes

    eMail Notification for Agent Job Failure

    SQL Server
     > 
    SQL Server Replication
    New to replication. I see that when you create transactional replication, it creates several jobs related to it below (Publisher + Distributor + Subscriber). My question is, which ...
    Unanswered | 4 Replies | 165 Views | Created by ARPRINCE - Thursday, March 29, 2018 3:59 PM | Last reply by ARPRINCE - Friday, March 30, 2018 2:59 PM
  • Items 1 to 20 of 11568 Next ›
Announcement: 1

SQL Server Replication announcement

  • Link
    SQL Server 2005 SP3 is now available
    Greg Y Thursday, December 18, 2008 5:10 AM
    SQL Server 2005 SP3 is released, access it here.

    Read about what's new for Replication here.

    Many replication bugs were fixed in SP3, you can find your way through them here.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.

Would you like to participate?

  
Privacy statement
 
© 2018 Microsoft. All rights reserved.
Newsletter|Contact Us|Privacy Statement|Terms of Use|Trademarks|Site Feedback