Restarting the sql server services is not possible in this server. Let me explain clearly what is the exact issue.

This is the log shipping server. The logshipping is failed for 2 days. When we cross-checked the log with size of 389KB is restoring for more than 2 days. The session id which is restoring the log is 55. We are unable to kill this session. When we kill this session, we get error as:

Server: Msg 6101, Level 16, State 1, Line 1

Process ID 55 is not a valid process ID. Choose a number between 1 and 32817.

We are having full backup in production server. It is easy for us to configure the log shipping with this backup. But we are unable to drop the existing DB in log shipping server. The session which I have mentioned has taken 129163145 CPU time and 63200955 DISK IO. Restoring log of 389 kb should not take this much. Please suggest us a solution without restarting the sql services.

Note: We have already planned of restarting the sql services by coming 3rd. But till that we should not be without logshipping for this DB.

Thanks in advance.