Problem with Simple Log Shipping
Posted on 2006-05-25
I have the following problem. I am trying to log ship between two standard SQL 2000 servers. I have installed SP_ShipLog on the primary server, in the master database, and sp_applystandbylog on the secondary server in the master database.
When I run the sp_shiplog from the primary server, the log.bak gets copied correctly to a share on the secondary server. However, when the job on the primary server trys to apply the log to the secondary server's database (which is read-only and set up accept the application of transaction logs), I get the following message:
Executed as user: domain1\troutSQL. ...roup\mssql\TransLogs\TEST_20060525_1037_LOG.BAK [SQLSTATE 01000] (Message 0) BACKUP LOG successfully processed 0 pages in 0.372 seconds (0.000 MB/sec). [SQLSTATE 01000] (Message 3014)
Execute [SQLServer01].master.dbo.sp_ApplyStandByLog N'Yoda',N'\\SQLServer01\data\data_srv\dbagroup\mssql\TransLogs\Yoda_20060525_1037_LOG.BAK',N'\\SQLServer01\data\data_srv\dbagroup\mssql\TransLogs\undo_yoda.dat' [SQLSTATE 01000] (Message 0)
Executing RESTORE LOG Yoda FROM DISK='\\SQLServer01\data\data_srv\dbagroup\mssql\TransLogs\Yoda_' WITH STANDBY='\\SQLServer01\data\data_srv\dbagroup\mssql\TransLogs\undo_yoda.dat [SQLSTATE 01000]
(Message 0) RESTORE LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013)
Cannot open backup device '\\SQLServer01\data\data_srv\dbagroup\mssql\TransLogs\Yoda_'.
Device error or device off-line. See the SQL Server error log for more details. [SQLSTATE 42000] (Error 3201) Error severity levels greater than 18 can... The step failed.