Administrating the Core Database Engine - Microsoft SQL Server 2008 R2 Administration - page 83

6. Determine if the publication database backup contains the latest configuration for all
publications and subscriptions. If yes, then the restore is completed. If no, then go to
the next step.
7. Remove the replication configuration using the sp_removedbreplication
statement from the Publisher, Distributor, and Subscribers, and then recreate the
configuration. The restore is completed.
8. To restore transactional replication with updated subscriptions, restore the latest
backup of the publication database.
9. Run the Distribution Agent until all Subscribers are synchronized with the outstanding
commands in the distribution database.
10. Verify that all commands are delivered to Subscribers by using the Undistributed
Commands tab in Replication Monitor, or by querying the MSdistribution_status
view in the distribution database.
11. If you are using queued updating subscriptions, connect to each Subscriber and
delete all rows from the MSreplication_queuetable in the subscription database.
12. Run the Distribution Agent until all Subscribers are synchronized with the outstanding
commands in the distribution database.
13. Verify that all commands are delivered to Subscribers by using the Replication
Monitor or by querying the MSdistribution_status view in the distribution database.
14. Use the tablediff Utility or another tool to manually synchronize the Publisher with
the Subscriber. This enables you to recover data from the subscription database that
was not contained in the publication database backup.
Script every component and configuration change
in your replication. Use SSMS tool to create
objects and script them, or only script them.
15. To script an object or multiple objects from Management studio, connect to the
Distributor, Publisher, or Subscriber in Management Studio, and then expand the
server node. Right-click the Replication folder and then click on Generate Scripts.
16. Specify options in the Generate SQL Script | <ReplicationObject> dialog box.
17. Click Script to File. Enter a file name in the Script File Location dialog box, and then
click Save. Click OK, and then click Close.
18. The key aspect of administration practices is monitoring replication to ensure that it
is up and running. Replication monitor displays the status information for publication
and subscriptions. To view information for a publication, connect to the Publisher
group in Management Studio, and then expand a publisher and select a publication.
19. To view and modify publication properties, right-click on publication to
select properties.
20. To view information about subscriptions, click the All Subscriptions tab.