LSBackup_<server> Log Shipping Problem

[peterlyttle]

Hello,

Has anyone had the following problem? I have setup log shipping on my primary server to ship to my secondary. However the LSBackup_<server> job has not been created in the sql agent. The LSCopy and LSRestore jobs have been created properly on the secondary server though.

Anyone have any ideas?

Thanks,
Pete

 

[peterlyttle]

FYI I resolved this issue -

SELECT @@SERVERNAME returns NULL

so do a

sp_dropserver 'SQL2005'
go
sp_addserver 'SQL2005', 'local'
go

Restart the SQL Services and do a

SELECT @@SERVERNAME and this will return SQL2005