Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 .ckp file

Author  Topic 

Sarat
Constraint Violating Yak Guru

265 Posts

Posted - 2004-03-09 : 12:53:05
Hi,
Whenever I restore a database, I see a dbname.ckp file created where the dbname.mdf is being restored. What is this .ckp file and why is it created? Then it is gone after the restore is completed. Does it have something to do with checkpoint event?
Thanks,
Sarat.

**To be intoxicated is to feel sophisticated, but not be able to say it.**

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-03-09 : 14:04:38
It's a restart-checkpoint file. I believe it is used in case the restore is cancelled or fails so that it can be undone.

Tara
Go to Top of Page
   

- Advertisement -