Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


error 18272/16/1: during restore restart, an i/o error occurred ... *.CKP file not found. 2005 SP4....


error 18272/16/1: during restore restart, an i/o error occurred ... *.CKP file not found. 2005 SP4. Log shipping.

Author
Message
snomadj
snomadj
SSC-Enthusiastic
SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)

Group: General Forum Members
Points: 158 Visits: 615
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.

Smile
snomadj
snomadj
SSC-Enthusiastic
SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)

Group: General Forum Members
Points: 158 Visits: 615
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search