January 11, 2006 at 10:34 am
I have successfully set up log shipping with two 2000 servers. I have a simple set up with a serverA and a serverB where serverA is primary and serverB is standby and log monitor. I go through the wizard and everything completes successfully. And there’s even more good news:--ServerB does indeed create a database in standby mode.--I can query a test table I created on both serverA and serverB.--The full backup shows up in the appropriate shares on both serverA and serverB.--The log backups show up in the appropriate shares on both serverA and serverB.--There are no errors in the Log Monitor.But here’s the bad news:--When I insert a few records into a table on serverA it never makes it over to serverB.--On serverB in the Sql Server error logs it says “The log shipping source SQL4.temcmtest2 has not backed up for 9 minutes.”--And when I look farther up in the logs it says things like this:“I/O error on backup or restore restart-checkpoint file 'e:\data\MSSQL\backup\temcmtest2.ckp'. Operating system error 3(The system cannot find the path specified.). The statement is proceeding but is non-restartable.”“Starting up database 'temcmtest2'.”“Bypassing recovery for database 'temcmtest2' because it is marked IN LOAD.”“I/O error on backup or restore restart-checkpoint file 'e:\data\MSSQL\backup\temcmtest2.ckp'. Operating system error 3(The system cannot find the path specified.). The statement is proceeding but is non-restartable.”Here’s what I don’t get: I never asked it to create a database on 'e:\data\MSSQL\backup’ nor is that the share. I never put that path anywhere in the wizard. Where is it getting that path? And what is a ckp file?Any help would be much appreciated. I need to get this working...
January 12, 2006 at 9:48 am
It sounds like a permissions problem, can server 'B' access server 'A's shares?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply