Does anyone know why would SQL throwing a Severity 016 alert following a successful db restore, and what I could do to prevent it?
I'm testing backup restores in a new development environment, and I'm seeing this error msg:
DESCRIPTION: During restore restart, an I/O error occurred on checkpoint file '\\BackupServer\Folder\SQLBackupFolder\RestoreCheckpointDB7.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.
The path \\BackupServerName\FolderName\SQLBackupFolder\ is the default backup location in my SQL server configuration and is on a separate server to my SQL one.
The location I'm pulling the back up from is different to the default:
I tried changing the default location in the server config to the folder where the .bak is but it still threw the error.
I'm new to db restore testing, so it could be I'm missing something obvious here! Should I even worry about these errors as the restore works?Any thoughts or ideas would be a great help!