SQL Server : database recovery from snapshot files We have completely lost our SQL Server 2000 database in an accident. The only thing left is a snapshot folder which contains bunch of .sch, .idx and .bcp files.

The sch and idx files have a clear text format and holding the database schema.

The .bcp files looks to be binaries encoded somehow.

Is there any way to recover the data from the .bcp files?
Depends on what these bcp files are. If there is a plenty of them and they are named after tables in your database, then chances are, they are table dumps created with (probably) bcp.exe. Also looking at their creation dates might provide some insight.

If the naming pattern does not correlate with tables, maybe these are database backups. You can check this by running restore headeronly against them - if they are indeed MSSQL backups, you will see some data about when they were created and what kind of backups they are.