Determining If Existing Servers Contain Replicated Databases

Determine if existing servers contain replicated databases before upgrade.

1. Use isql to connect to the Server you are upgrading.
2. If your server uses Replication Agent™ to replicate data, connect to the server and execute:

   1> sp_config_rep_agent
   2> go

   The above command displays the list of databases enabled for replication agent.
   1. If you use another application to replicate data, LTM or Mirror Activator, run the following command in each database including the master database:

      1> dbcc gettrunc 
      2> go