Export (0) Print
Expand All

Enable a Database for Replication (SQL Server Management Studio)

A database is implicitly enabled for replication when a member of the sysadmin fixed server role creates a publication with the New Publication Wizard. A member of the sysadmin fixed server role can also enable a database for replication explicitly, so that a member of the db_owner fixed database role can create one or more publications in that database. To enable a database explicitly, use the Publication Databases page of the Publisher Properties - <Publisher> dialog box. For more information about accessing this dialog box, see Create a Publication.

To enable a database for replication

  1. On the Publication Databases page of the Publisher Properties - <Publisher> dialog box, select the Transactional and/or Merge check box for each database you want to replicate. Select Transactional to enable the database for snapshot replication.

  2. Click OK.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft