Sunday, December 19, 2010

Restoring database replication tables like sysmergepublications

For Microsoft SQL Servers,

To restore a database backup and keep the merge replication tables like sysmergepublications and sysmergearticles you need to restore the database from T-SQL using the RESTORE command and use the keep_replication

This will allow you to restore the merge replication required data and the publication definition.

No comments: