Post reply

Restore Live Replicated Database to Standalone copy in Test Environment

  • October 6, 2011 at 9:52 am

    #258500

    I'd like to create a test server that has a copy of a live database that is currently set up for replication as a publisher. When I restore a copy of this database to the test server, I do not want this test copy engaged in any replication, I want it to be a standalone database in the test environment. Will just restoring the database to the test environment accomplish this or will the database be looking for replication jobs and a distributor database.

    Thanks

  • October 6, 2011 at 10:01 am

    #1391292

    Restore without "Preserve the Replication Settings" being checked and you should be fine.

    Thanks,

    Jared

    Jared
    CE - Microsoft

  • October 6, 2011 at 10:03 am

    #1391293

    Brilliant, Thanks Jared

  • October 6, 2011 at 10:10 am

    #1391298

    Here are some scenarios: http://msdn.microsoft.com/en-us/library/ms152560.aspx

    Basically there is an option REPLICATION_WITH_KEEP_REPLICATION option that you do not need. The checkbox includes this option.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply