Get tables and columns from existing sql server backup file

[venkatseerla]

Hi all,

How to get tables and columns from existing sql server backup file without connect to SQL Server?
Is it possible to get table names and column names form raw file like *.bak ?

I would like to display the Tables & columns names which are there in backup file. Here we will not use any sql Connection String.... ( without connecting SQL Server)

Please help me.............

Thanks
Venkat

[nelo]

Well. You can scan through the backup file and find a way identifying the tables in there. I'm not sure how easy this given that SQL Server is likely to be using a proprietary format. Can I ask why you can't use SQL Server to do this? Then you would be able to SQL Server Management Objects. These are classes that allow you to perform a host of operations against a SQL Server database like restoring backups, etc.