August 1, 2017 at 12:35 pm
The full error is:
Error: 18272, Severity: 16, State: 3.
During restore restart, an I/O error occurred on checkpoint file '<path omitted>\RestoreCheckpointDB5.CKP' (operating system error 5(Access is denied.)).
The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.
A little background, using log shipping pretty much OOB (SQL Server 2012 Enterprise - varying SPs / CUs - most SP1). The restore log command succeeds. The default backup location has been changed after the installation to a location that resides on a mount point. I'm thinking permissions are missing (obviously), but which account needs permissions? The engine or agent? I am using domain accounts. I attempted to grant the agent account full control on the mount point of the default backup directory, and the applied permissions show "This folder, all subfolders and files" but no go.
Thoughts?
August 1, 2017 at 1:00 pm
Presuming you have access, I'd give the Windows Event Log (Security Log) a look-over for about the time that error happened. Best-case, it'll tell you what account was trying to access the file in question.
If you don't have access, I'd get with someone who does, and check the Security Log.
August 1, 2017 at 1:01 pm
Tony Fountain - Tuesday, August 1, 2017 12:35 PMThe full error is:
Error: 18272, Severity: 16, State: 3.
During restore restart, an I/O error occurred on checkpoint file '<path omitted>\RestoreCheckpointDB5.CKP' (operating system error 5(Access is denied.)).
The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.A little background, using log shipping pretty much OOB (SQL Server 2012 Enterprise - varying SPs / CUs - most SP1). The restore log command succeeds. The default backup location has been changed after the installation to a location that resides on a mount point. I'm thinking permissions are missing (obviously), but which account needs permissions? The engine or agent? I am using domain accounts. I attempted to grant the agent account full control on the mount point of the default backup directory, and the applied permissions show "This folder, all subfolders and files" but no go.
Thoughts?
Both the Engine and Agent accounts would need permissions.
Sue
August 1, 2017 at 2:04 pm
UPDATE: this was indeed the problem... sigh... just glad it was this simple all the time lol...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply