Database Snapshot

Need some help, i have some database snapshots files provided from an external source. Need to be able to understand how i get them back into a database format if possible.

Files for example are table1.bcp, table2.bcp with als a file called scheme.sql which sets up these tables in sql but does not populate them. Nothing else was provided except a .vcd file which i dont know whtat its for.

any clues?

Dan

This link describes how to restore a database from a database snapshot

http://www.sqlservercentral.com/columnists/akhosla/2733.asp

unfortunately I don't have right now access to an SQL server to see how to 'make' SQL Server 'see' a snapshot created by another server

|||

I dont have the original database though, only these files and this link assumes you have the original database?/

Dan

|||

yes this link assumes you made the snapshot on the same sql server :(

|||

Are you CERTAIN that these files were created using the SQL Server Database Snapshot feature?

It looks to me as if you have a SQL script to create tables, and BCP data files to feed into the BCP (Bulk copy) utility to load the data.

I would read BOL on BCP and attempt to load the files that way.

|||

Yes you are correct, this does indeed seem to be a Bulk Copy in Native format, guess i was going down the wrong path.

Thanks i now have the data in the correct format, also the extract works in SQL 2000 which is good.

Much appreciated.

Dan