How to convert snapshot files to any other format?

Question

Hi All, Is there any way to convert the Sql Server 'Snapshot' files (*.ss files) to some other format...like 'xml','xls' or 'txt'...etc.

Thanks.

Answer 1

snapshot files are sparse files that only contain pages that have been 'copied on write'. They may appear to be the size of the source database, but they are not. They are useless without the source database.

Best way to get the data out is via something like a BCP out, or an SSIS package to export what you need