Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

error 18272/16/1: during restore restart, an i/o error occurred ... *.CKP file not found. 2005 SP4. Log shipping. Expand / Collapse
Author
Message
Posted Thursday, January 17, 2013 3:33 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 10:55 AM
Points: 79, Visits: 427
I'm getting the above error.

I know it has little impact & I can suppress the errors but, it's bugging me & I'd love to get to the bottom of it so any ideas would be gratefully recieved.

I log ship tran logs from A to B every 15 mins.
The restore succeeds but I get this error every time.
Google results show it being an issue for 2008 & 2005 sp3 but I'm on 2005 SP4.
I've checked that the default backup dir in regedit is the same as the one in the error message - it is. It exists on both servers & the agent user, the same as the sql service user has full permissions to this path on both servers.

I've re-configured log shipping & re-done 3 times but no change.

Does anyone have anything else I should check or try?

Thanks.

:)
Post #1408284
Posted Friday, January 18, 2013 1:52 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 10:55 AM
Points: 79, Visits: 427
Well, I can report that the error has gone. I'm not sure which of the following steps taken previously 'resolved' the issue, but last night I re-re configured log shipping. I can only presume that the permissions changes worked but I needed to re-set up log shipping in order for them to take effect.

Post #1408759
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse