Complete all the steps outlined below to remove and re-replicate a Sage 300 CRE database properly.

1. Stop Replicator

1. Exit out of all Sage 300CRE applications.
2. Stop the SQL Replicator.
   • To Stop v1 Replicator:
     1. Start System Administration at the Sage 300 CRE server.
     2. Log in with Application Administrator permissions.
     3. Click Connect to connect to the Microsoft SQL Server.
     4. Click Stop to stop the replicator.
     5. Exit out of Configuration Manager.
     6. Exit out of System Administrator.
   • To Stop v2 Replicator:
     1. Start System Administration at the Sage 300 CRE server.
     2. Log in with Application Administrator permissions.
     3. Connect to the Microsoft SQL Server.
     4. Click the Sage 300 CRE folder associated with the SQL database you want to remove and select Configure.
     5. Once Configuration Manager opens select Connect.
     6. Click Stop.
     7. Exit out of Configuration Manager.
     8. Exit out of System Administrator.

2. Delete SQL Databases

1. Start Microsoft SQL Server Management Studio.
2. Connect to the appropriate Microsoft SQL Server.
3. Click the + sign to expand Databases.
4. Right-click on the database you want to remove.
5. Select Delete.
6. Select Close existing connections and Delete backup and restore history information for databases.
7. Click OK.
8. Repeat the above to delete the following databases.
   • Izenda
   • SageCREGlobalConfiguration
   • SageApplicationTelemetry
   • User Datasets (as listed in the 300CRE Open Company dialog)
9. Verify it removed the SQL LDF and MDF files from the Microsoft SQL Server folder. If they still exist, delete them.
   • Example Location: C:\Program Files\Microsoft SQL Server\MSSQL13.SAGE300CRE\MSSQL\DATA (actual location can vary)
   • You can use a command line such as "dir \*.mdf /s" to find the files on your drive (check *.mdf and *.ldf)

3. Re-replicate the database

Once you've complete the steps above, you can re-replicate the database.