Upgrading the Microsoft SQL Server service pack

Log locator values and some Replication Agent transaction log objects are lost when updating the Microsoft SQL Server service pack. After upgrading the service pack and before performing migration tasks on Replication Agent, reset the locator values at Replication Agent and Replication Server.

Make sure that all data has been completely replicated.
Upgrade the Microsoft SQL Server service pack.
Set the value of the LTM Locator stored in the Replication Agent transaction log to zero:
```
ra_locator zero
```
Reset the locator value to zero for the primary database:
```
rs_zeroltm data_server, database
```
where data_server is the data server on which the primary database resides and database is the primary database.
Migrate Replication Agent:
```
ra_migrate
```