Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    16

    Unanswered: Resotring a replicated database

    I have a database A on server_1 that is being merge replicated to database B on server_2 which is production a box

    NOW

    I want to restore database A on server_3 that is being merge replicated to database B on Server_4 which is test box.

    How about do I do that with replication being involved?

    Thanx

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I don't know that there is any way to restore a database that is involved in replication. It smells like a VERY bad thing to me because it would do horribly confusing things to the data and especially the log information that could send replication into hysterics!

    If you really want to do this, I'd delete the server from the replication schema (probably all of the servers from the schema for Merge Replication), then do the restore. After that restore was complete, then I'd rebuild whatever replication I needed.

    -PatP

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You can backup the replicated database but follow what Pat referred and go with this MSDN http://msdn.microsoft.com/library/de...ackup_8enn.asp link for more details.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •