SQL Server

On occasion we have had trouble with Microsoft SQL Server 2005 causing us an issue with Replication.

It returns an error message like the following:

Error messages:
The process could not execute 'sp_repldone/sp_replcounters' on 'SQL-09'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)
Get help: http://help/MSSQL_REPL20011
An error occurred while processing the log for database 'TursSearchEngine'. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log. (Source: MSSQLServer, Error number: 9004)
Get help: http://help/9004
The process could not set the last distributed transaction. (Source: MSSQL_REPL, Error number: MSSQL_REPL22017)
Get help: http://help/MSSQL_REPL22017
The process could not execute 'sp_repldone/sp_replcounters' on 'SQL-09'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)
Get help: http://help/MSSQL_REPL22037

It is still unknown as how it happens or when.

The work around solution is to:
1. Run a query on the screener Database server with the following:
a. Set [DatabaseName]
b. exec sp_replrestart
c. GO
2. Then you will have to reinitialize the subscription.

This should allow the service to restart and fix the problem. If anyone has any further pointers as to why this occurs or How to fix it better, please post a comment.