Does the Master database play a role in MS SQL Server merge replication?

Posted on 2007-07-25
Last Modified: 2010-03-19
I have a Microsoft SQL server 2005 database which is merge replicated between 2 servers with a push subscription.  We lost the operating system disk (C:) on the subscriber which held the master database. Is the loss of the master database going to break replication?
Question by:AndyMagruder
    LVL 6

    Accepted Solution

    Unfortunately this will most likely cause a problem because Replication does use one table (MSreplication_options) in master.

    See for a full list of the tables.

    Chances are you will have to setup new replication after restoring the master database.

    Author Comment

    Luckily Replication did come back up in working order. The machine affected was a subscriber that had a Push subscription being pushed to it.  The options were all default before and after the OS rebuild.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    combine data in sql 1 23
    count vs exists 9 33
    What is the best way to calculate hours worked 5 41
    by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now