This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
Microsoft Logo
Gray Pipe
Developer Network Developer Network Developer
:CreateViewProfileText: Sign in

Subscriber portal

Get tools
  • Downloads
    • Visual Studio
    • SDKs
    • Trial software
      • Free downloads
      • Office resources
  • Programs
    • Subscriptions
      • Overview
      • Administrators
    • Students
      • Microsoft Imagine
      • Microsoft Student Partners
    • ISV
    • Startups
    • Events
  • Community
    • Magazine
    • Forums
    • Blogs
    • Channel 9
  • Documentation
    • APIs and reference
    • Dev centers
    • Samples
    • Retired content
search clear
We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second.
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 | 49640 Views | Created by Greg Y - Thursday, December 7, 2006 8:22 PM | Last reply by Harry SQL DBA - Saturday, February 19, 2011 5:43 AM
  • large check mark
    1 Votes

    Schema changes to Transaction replcation setup 2018 R3 to 2014

    SQL Server
     > 
    SQL Server Replication
    Hi Currently my have transaction replication 2018 R3 to  2014. Now I business needs schema changes. add new Three tables add new three ...
    Unanswered | 7 Replies | 89 Views | Created by ashwan - Friday, February 15, 2019 4:45 AM | Last reply by Hilary Cotter - Friday, February 15, 2019 4:05 PM
  • large check mark
    0 Votes

    Clear sessions of Log Reader Agent

    SQL Server
     > 
    SQL Server Replication
    Can see multiple errors of the same type in Sessions of the Log Reader Agent (Publisher to Distributor History). I would like to clear these logs so as to easily monitor for genuine errors. Is it ...
    Answered | 7 Replies | 260 Views | Created by asthajn1009 - Monday, February 4, 2019 6:07 PM | Last reply by asthajn1009 - Friday, February 15, 2019 1:12 PM
  • large check mark
    0 Votes

    Transaction replication distributor to subscriber pending

    SQL Server
     > 
    SQL Server Replication
    Hi I am setting up 2008R2 to 2014 Transaction replication for propagate  same scenario as prod . When I checked with tracer token that  distributer to subscriber is pending.  ...
    Unanswered | 1 Replies | 42 Views | Created by ashwan - Friday, February 15, 2019 8:15 AM | Last reply by Bartosz Lewandowski - Friday, February 15, 2019 10:59 AM
  • large check mark
    0 Votes

    SQL server cross replication login failed

    SQL Server
     > 
    SQL Server Replication
    Hello All, We have DEV and UAT domain. I am trying to create replication from UAT to DEV and vice versa. As we have two different domain we can't use domain account. So, i have ...
    Unanswered | 10 Replies | 187 Views | Created by Chickoo79 - Tuesday, February 12, 2019 7:43 PM | Last reply by Emily Fei - Friday, February 15, 2019 9:54 AM
  • large check mark
    2 Votes

    sp_MSreplcheck_qv

    SQL Server
     > 
    SQL Server Replication
    I am trying to replicate a database from SS2005 to SS2008, I have setup the distribution server as the 2008 server and am now trying to publish from the 2005 server, on doing that I get a ...
    Answered | 9 Replies | 11407 Views | Created by Y Jack - Thursday, September 16, 2010 1:32 PM | Last reply by Chandan.mssqldba - Thursday, February 14, 2019 9:31 AM
  • large check mark
    0 Votes

    Can we have two different publication servers and single subscriber Server

    SQL Server
     > 
    SQL Server Replication
    Hi, I have a request to add a database from a server to the existing replication setup. Existing setup: Server1: ...
    Answered | 4 Replies | 138 Views | Created by Kranthi_666 - Monday, February 11, 2019 11:47 AM | Last reply by Emily Fei - Tuesday, February 12, 2019 6:59 AM
  • large check mark
    0 Votes

    Lock on Views at snapshot replication all the time

    SQL Server
     > 
    SQL Server Replication
    Hi I did setup a snapshot replication including some views. Did work without any problems. After the snapshot was finished and transfered to the subscriber I tried to do a drop of ...
    Unanswered | 2 Replies | 161 Views | Created by Beat hotelleriesuisse - Friday, February 8, 2019 2:15 PM | Last reply by Dedmon Dai - Monday, February 11, 2019 5:48 AM
  • large check mark
    0 Votes

    Unable to configure transactional replication using Listener name from SSMS 2014

    SQL Server
     > 
    SQL Server Replication
    Hi, We are running SQL Server 2014 Ent and 2017 Ent.  While setting up transactional replication with Publisher DB in ...
    Proposed | 1 Replies | 171 Views | Created by Rahul Gav - Sunday, February 10, 2019 7:11 AM | Last reply by Mohsin_A_Khan - Monday, February 11, 2019 12:32 AM
  • large check mark
    0 Votes

    Problem with CDC (change data capture)

    SQL Server
     > 
    SQL Server Replication
    On a high-load base (about a million commands per second) Included CDC on the table (about 1 000 000 000 rows) with changes of about 3 million per ...
    Unanswered | 6 Replies | 426 Views | Created by czar-wizard - Wednesday, January 16, 2019 1:35 PM | Last reply by Pr0ger - Thursday, February 7, 2019 7:17 PM
  • large check mark
    1 Votes

    How can I replicate data from SQL Server 2017 to SQL Server 2008 R2

    SQL Server
     > 
    SQL Server Replication
    SQL 2008 R2. I don't need real time replication, just daily. The servers run as virtual instance on the same physical server in Hyper-V. This is a membership database and is roughly 5 GB in ...
    Proposed | 4 Replies | 289 Views | Created by GrandpaDude - Thursday, January 24, 2019 10:29 PM | Last reply by Greg Y - Thursday, February 7, 2019 1:49 AM
  • large check mark
    1 Votes

    Configure replication from SQL server 2014 Enterprise Ed. to SQL server 2017 Enterprise Ed.

    SQL Server
     > 
    SQL Server Replication
    The query here is pertaining to Replication support between Publisher instance running on SQL Server 2014 Ent. Ed. and Subscriber instance being on SQL Server 2017 Ent. Ed. Currently all DB ...
    Unanswered | 2 Replies | 295 Views | Created by Rahul Gav - Saturday, February 2, 2019 11:15 AM | Last reply by Greg Y - Thursday, February 7, 2019 1:45 AM
  • large check mark
    0 Votes

    Always on replica and cached views

    SQL Server
     > 
    SQL Server Replication
    Hi All, I've a little suspect on returned rows from sql VIEWS created with(nolock) and pooled c# connections. My Installation is synch-commit availability ...
    Answered | 5 Replies | 281 Views | Created by dscaravaggi - Tuesday, January 29, 2019 5:39 PM | Last reply by dscaravaggi - Wednesday, February 6, 2019 3:59 PM
  • large check mark
    0 Votes

    Partition table Replication

    SQL Server
     > 
    SQL Server Replication
    Hi Experts, Am planning to migrate to a new version from SQL Server 2014 to 2017 enterprise. Am thinking of using the transactionreplication to keep the data sync. Am very new to ...
    Unanswered | 2 Replies | 166 Views | Created by Priya Bange - Tuesday, February 5, 2019 4:11 AM | Last reply by Hilary Cotter - Wednesday, February 6, 2019 2:46 PM
  • large check mark
    0 Votes

    Replicate to different network

    SQL Server
     > 
    SQL Server Replication
    Existing setup :  Server1 (cloud) as Publication & Distributor   (sql 2016)  to  Server2 (cloud) as Subscriber (sql 2016)   ( same ...
    Proposed | 3 Replies | 167 Views | Created by KIRUBAKARAN J A - Monday, February 4, 2019 10:17 AM | Last reply by Hilary Cotter - Monday, February 4, 2019 7:25 PM
  • large check mark
    0 Votes

    Expired subscription clean up failing with sp_MSdrop_expired_subscription

    SQL Server
     > 
    SQL Server Replication
    This issue is with 3 servers that are running SQL 2005 SP3 with transactional replication. The "Expired subscription clean up" job is failing with the message "The name ...
    Proposed | 17 Replies | 12949 Views | Created by Brian.Jones - Monday, August 3, 2009 1:06 PM | Last reply by MrPshaw - Friday, February 1, 2019 5:36 PM
  • large check mark
    0 Votes

    Removing a filtered article in merge replication

    SQL Server
     > 
    SQL Server Replication
    Hi all, I have a merge rep setup, and it includes hierarchy of filtered tables. At the top of the hierarchy there is a parameterised filter (user login) and join ...
    Proposed | 1 Replies | 203 Views | Created by backtothefuture - Wednesday, January 30, 2019 2:28 PM | Last reply by Emily Fei - Thursday, January 31, 2019 7:28 AM
  • large check mark
    1 Votes

    Oracle Publications

    SQL Server
     > 
    SQL Server Replication
    I am trying to setup Transactional Replication from Oracle to SQL Server, but SQL is not seeing the schema of the objects. It can see the table names, but not the columns. Oracle is on 12.2 and SQL ...
    Answered | 1 Replies | 189 Views | Created by John Couch - Wednesday, January 30, 2019 2:44 PM | Last reply by Puzzle_Chen - Thursday, January 31, 2019 2:01 AM
  • large check mark
    1 Votes

    SQL Server 2008 Replication Agent missing required privilege

    SQL Server
     > 
    SQL Server Replication
    So our replication publisher was once an Active Directory domain controller. We removed it as a domain controller and have noticed that certain replication setups have stopped. we are getting the ...
    Answered | 16 Replies | 10772 Views | Created by Phillip Couto - Friday, April 29, 2011 4:03 PM | Last reply by ElementOmicron - Wednesday, January 30, 2019 6:19 PM
  • large check mark
    0 Votes

    How to get last synchronization date and time of a database in SQL

    SQL Server
     > 
    SQL Server Replication
    Hi Team, How to get last synchronization date and time of a database in SQL? Any query to check or what is the log file? Please let me ...
    Unanswered | 6 Replies | 278 Views | Created by boopathi subramaniam - Tuesday, January 29, 2019 4:39 PM | Last reply by Olaf Helper - Wednesday, January 30, 2019 9:10 AM
  • large check mark
    0 Votes

    SQL 2012 Replikation - can't create subscriber

    SQL Server
     > 
    SQL Server Replication
    Hi, gestern wollte ich einen Abonnenten für eine Replikation anlegen, es gibt noch keine weiteren Abonnenten. Der Publisher ist ein SQL 2012 Standard, der Abonnent ein SQL 2012 ...
    Answered | 4 Replies | 722 Views | Created by SIH007 - Monday, February 12, 2018 3:58 PM | Last reply by SIH007 - Saturday, January 26, 2019 4:24 PM
  • Items 1 to 20 of 11760 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.
Help us improve MSDN.
Visit our UserVoice Page to submit and vote on ideas!
Make a suggestion

Dev centers

  • Windows
  • Office
  • Visual Studio
  • Microsoft Azure
  • More...

Learning resources

  • Microsoft Virtual Academy
  • Channel 9
  • MSDN Magazine

Community

  • Forums
  • Blogs
  • Codeplex

Support

  • Self support

Programs

  • BizSpark (for startups)
  • Microsoft Imagine (for students)
United States (English)
  • Newsletter
  • Privacy & cookies
  • Terms of use
  • Trademarks
logo © 2019 Microsoft