You administer a SQL Server 2008 instance that contains a database named Adventure
Works. The AdventureWorks database contains the Products table.
You create a Merge Replication topology and a Publication to replicate the Products table to
the SQL Server instances at remote locations. The Publication has a 21-day retention
period.
When a user returns from a one-month vacation, she discovers that her database does not
contain the most recent data. The Windows Event log states the following error message:
“Replication: expired subscription dropped.”
You need to obtain the most recent data in the database of the user.
You also need to ensure that future data changes are appropriately replicated.
What should you do?
A.
Recreate the publication.
B.
Upload unsynchronized changes.
C.
Upload unsynchronized changes, and then reinitialize the publication.
D.
Reinitialize the publication and immediately generate a new snapshot.