Restoring replication objects from script

  • On which database should I run the script of the replication objects (distribution, the publication database, master, ??)to properly restore them and maintain all replication settings??

    Are there any other procedures that should be considered when restoring a critical replication server (Log shipping is not an option because I don't have extra hardware)?

    Thanks,

    Paul

  • You'd run the scripts to create the publications in the appropriate database. Before you could do that you would need a script that enabled replication on the server, created Distribution db, set up subscribers maybe, etc.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • Thank you Andy.

    This gives me a solid "starting point" and ties in some of what I've read up to this point.

    I'm off to experiment now on my test server.

    Thanks again!!

    Paul

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

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