Whenever we restore a SQL database, a Restore Checkpoint
file is temporary generated in the default Backup folder and automatically
removed once restore is completed. It stores database log information which is
written during the database restore.
I checked the default backup location while restoring the
two databases and I saw two Restore check point files with .CKP extension. DB5
and DB6 in the file name are database ids which we are restoring.
If the default backup location is deleted or there is different entry for backup location than default and SQL services not having access to the location, in such case when database is restored we get an error related to “Restore Checkpoint file”.
If we get Restore checkpoint file related error message while restoration of database, we must check the default backup location (“Right click on SQL instance -> Go to Properties->database setting”) should match the windows Registry entry for SQL server “BackupDirectory”.
If we get Restore checkpoint file related error message while restoration of database, we must check the default backup location (“Right click on SQL instance -> Go to Properties->database setting”) should match the windows Registry entry for SQL server “BackupDirectory”.
Moreover, make sure
SQL server service account having the read/write access to backup location.
Interesting sidenote: even if you have Transparent Data Encryption / Backup encryption activated, the CKP-files seems to contain unencrypted data. And sometimes (if the restore fails whyever) the files are not deleted.
ReplyDeleteYou should be aware of this, when you are working in a high confidential environment, you could for example define your default backup directory on a drive with built in hardware encryption or on a RAM-Disk and monitor the directory for old CKP files. Of course you have to ensure, that your real backups are going to another manual defined drive / folder.