Final Cleanup

After you have removed all Replication Agent objects from all the databases on a given primary data server by issuing ra_admin deinit in each database in which you had issued ra_admin init, you may want to remove all the remnants of Replication Agent and completely clean the primary data server.

To clean up all Replication Agent remnants from the primary data server:

Stop the Microsoft SQL Server service.
1. In Control Panel > Administrative Tools > Services, find the service named SQL Server (SERVER), where SERVER is the name of your Microsoft SQL Server data server.
2. Stop this service.
Open a command window, and restart Microsoft SQL Server in single-user mode:
```
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe” -m -s instanceName
```
where instanceName is the name of the Microsoft SQL Server instance.
Make sure the Microsoft SQL Server SQL Browser service is running, and connect to the data server using the sqlcmd utility with -A option or using the Management Studio. Specify the server name as Admin: servername, where servername is the name of your data server.
Remove the pds_username user if it has been created for Replication Agent:
```
drop user pds_username
```

Remove the special marking procedures from the mssqlsystemresource database:

drop procedure sp_SybSetLogforReplTable;
drop procedure sp_SybSetLogforReplProc;
drop procedure sp_SybSetLogforLOBCol;

Stop Microsoft SQL Server in single-user mode by shutting down the Windows service or by issuing the shutdown command with the sqlcmd utility.
To undo the effects of the sybfilter driver on each of the log devices, remove the log path entry by editing the configuration file or by using the sybfilter manager console.
Restart Microsoft SQL Server in multiuser mode (normal start).
1. In Control Panel > Administrative Tools > Services, find the service named SQL Server (SERVER), where SERVER is the name of your Microsoft SQL Server data server.
2. Start this service.