Error: 18272, Severity: 16, State: 1

pcorujo

Hi All,

I have a job which backups up databases and copies them to another server. There they are restored and upgraded from 2005 to 2008. The restores succeed but i get the following error:

Error: 18272, Severity: 16, State: 1
Message
During restore restart, an I/O error occurred on checkpoint file 'D:\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\RestoreCheckpointDB8.CKP' (operating system error 1784(The supplied user buffer is not valid for the requested operation.)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.


Is there a way to disregard any transaction logs during the restore?

Thank you in advance,
Paul

petey

Was SQL Backup actually restoring any transaction logs during the restore process? It could be that SQL Server itself writes checkpoint data during the upgrade process, so that it does not need to restart from the beginning should the upgrade/restore process be interrupted.

pcorujo

No it's not restoring any tlogs. Is there anyway around the checkpoint? The restores are fine but the jobs always appears to fail so the alerts go out.

petey

There is a Microsoft Support article on this,http://support.microsoft.com/?kbid=2022254, whose resolution is to install certain cumulative update packages.