Sharepoint 2010 Restore problem with SqlException The restart-checkpoint
22/03/2012 Leave a comment
Object <Content Database> failed in event OnRestore. For more information, see the spbackup.log or sprestore.log file located in the backup directory. SqlException: The restart-checkpoint file ‘Drive:\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\xxxx.CKP’ could not be opened. Operating system error ’3(The system cannot find the path specified.)’. Correct the problem, or reissue the command without RESTART. RESTORE DATABASE is terminating abnormally.
When SQL Server has been installing , it creates a default SQL Server Database backup folder like ‘Drive:\MSSQL10_50.MSSQLSERVER\MSSQL\Backup’
This error occurs that the BACKUP or RESTORE process needs to create a checkpoint file that will indicate at what point any failure occurs. This allows the WITH RESTART option to be used . The WITH RESTART option specifies that SQL Server should restart a restore operation that has been interrupted and continue restore operation where the interruption has occured . The information about how much data the BACKUP or RESTORE command had processed before the interruption occurred is stored in a checkpoint file in the BACKUP directory like ‘Drive:\<SQL INSTANCE>\MSSQL\Backup
The checkpoint file is a temporary file, deleted when the restore process is completed, and is normally placed in the default backup folder.
Some of the reasons the checkpoint file cannot be created :
- The “backup” directory does not exist under the directory where SQL Server is installed.
- The drive where the “backup” directory resides is full.
- The “backup” directory is not accessible to the SQL Server account.
For fixing the issue you may check fallowings.
- Verify that the BACKUP directory exists under the directory where SQL Server is installed. If it does not exist, create it.
- Verify that there is available space on the drive where the BACKUP directory resides.
- Verify that the SQL Server startup account has permission to read from and write to the BACKUP directory.
This error has a limited impact and does not prevent a restore operation from succeeding. This error message occurs when a restore is interrupted, and the checkpoint file that is used to restart a restore is not written, or the checkpoint file is not written correctly. If you receive this error, it means that, if for some reason the restore operation is interrupted in the middle of the process, you have to restart it from the beginning of the backup file rather than the checkpoint file.