June 10, 2003 at 1:22 pm
where does sql server store the file location
of the checkpoint file? I have some extraneous directory that I want to remove, but evidently sqlserver uses it for checkpointing. How do I change the file location? If I just remove it, when I try to restore i get "i/o error on backup or restore restart-checkpoint file 'e:\mssql\data\MSSQL\backup\xxxx.ckp'
operating system error - system can not find the path specified. the MSSQL\backup is the subdirectory i want to delete (it is empty when i look at it)
June 13, 2003 at 8:00 am
This was removed by the editor as SPAM
June 13, 2003 at 9:51 am
I don't ever see the *.ckp files in my backup folder. Checkpointing is an operation that writes out the transaction logs automatically and ensures data is on disk.
Steve Jones
June 13, 2003 at 10:10 am
if i try to remove the MSSQL\backup subdirectory (which is empty) and then do a restore, I get this i/o error looking for that subdirectory..., if i create the directory it doesn't give me an error. I don't understand where that directory string is stored as a path.....it it in the backup file somewhere?
June 13, 2003 at 10:44 am
Might be. Perhaps there is some temporary file there. Can you move the location for backup files and then restart?
Steve Jones
June 13, 2003 at 10:58 am
I'm not sure I understand what you want me to do. The backup directory is e:\mssql\backups
my backups don't even go in e:\mssql\data or any subdirectory under it. This is why its confusing.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply