What are the challenges you face when working across database platforms? Take the survey

Error: 18272, Severity: 16, State: 1

pcorujopcorujo Posts: 14
edited July 12, 2011 8:41PM in SQL Backup Previous Versions
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
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,


Sign In or Register to comment.