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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » error 18272/16/1: during restore restart, an...

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

Rate Topic

Display Mode

Topic Options

Author

Message

snomad

Posted Thursday, January 17, 2013 3:33 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:07 AM
Points: 68, Visits: 374

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

snomad

Posted Friday, January 18, 2013 1:52 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:07 AM
Points: 68, Visits: 374

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 »

Permissions