Forcing transaction log removal

When you invoke the ra_deinit command, Mirror Replication Agent creates a script (partdeinit.sql) that, when executed successfully, removes all transaction log objects from the primary database.

In the event that the partdeinit.sql script fails for some reason, some transaction log components may be removed from the primary database and some components may remain.

NoteIf errors cause a script execution failure, refer to your primary database error logs and the Mirror Replication Agent system log to evaluate the errors and determine if any corrective action is necessary.

To finish removing transaction log components after a script execution failure, invoke the ra_deinit command with the remove keyword, followed by the force keyword:

ra_deinit remove, force

When you use the force keyword, the removal processing continues—even when errors are encountered.