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)
 What is a .ckp file?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-12 : 23:03:22
writes "When I restore my backup by means of coding in VB, there is a file created on the directory where my backup is located.

I issued this command:

Restore Database Mydatabase from disk = 'c:\mssql7\backup\Mydatabasebak'

When this statement was executed, a file named Mydatabase.ckp was created on the same location. What is this file all about? Please help me..."

chadmat
The Chadinator

1974 Posts

Posted - 2002-03-13 : 13:20:30
A .ckp file is a checkpoint file that SQL creates behind the scenes. I'm not sure under what circumstances it is used, but I have seen them when using DMO for backup/restore.

-Chad

Go to Top of Page
   

- Advertisement -