Return
-
Title
LogShipping restore jobs on subscriber is not being Created and Not Working -
Description
Going through the process of the Log Shipping Wizard indicates that the Log Shipping Process has been set up successfully. However on checking the plan it can be seen that no LiteSpeed Restore job has been created on the subscriber so transaction logs are never restored. -
Cause
The most common cause of this problem is a server name mismatch. This could have been caused by the subscriber server being renamed. Upon installing LiteSpeed, an error message may have displayed indicating that there is a Server name mismatch but allowed continuation of the installation. To confirm the servername mismatch run the query Select @@SERVERNAME and confirm the results. -
Resolution
If there is a servername mismatch then perform the following actions: In Query Analyzer, run the following sp_proc to alter the server name: sp_dropserver 'old_name', 'droplogins' go sp_addserver 'new_name', 'local' go
Note: After you run the sp_addserver stored procedure, the SQL Server service must be restarted for the change to @@SERVERNAME to take effect.