November 14, 2005 at 10:01 am
I have been using simple log shipping with SQL 2000 for over a year. All of a sudden after rebooting both the primary and seconday servers, I receive the following error mesage:
sp_ShipLog Error 2754 occurred on database NWSAegisMSPDB to server VPDSQLRD using backup file...Error: 50000, Severity: 19, State: 1
I have found a couple of threads through google discussing this same error, but cannot get an answer from any of them.
Any ideas?
November 15, 2005 at 10:30 am
You might want to start by checking logs: the SQL Server error log, the Log Shipping Monitor Backup History and Copy/Restore History (right click on Monitor). Error 2754 in Books on Line only says that Error messages over (50000 in your case) can only be specified by members of the sysadmin role. It may be better just to see what's actually going on with the Log Shipping itself. Also check the job histories on the secondary server to see if files can still be copied, restored, etc. Also check the SQL error log there too. Good luck.
Linda
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply