How to get tables and columns from existing sql server snapshot/backup file

[team_ferrari22]

Hi,
We are designing a windows application where we need to 'Get tables and columns from existing sql server snapshot file or backup file' .

Does anybody know how it can be done.
Please provide help.

Thank you.

[shine_jose]

Hi,
We are designing a windows application where we need to 'Get tables and columns from existing sql server snapshot file or backup file' .

Does anybody know how it can be done.
Please provide help.

Thank you.

For restoring backup file

1)Create a database with same name
2)Go to enterprise manager in sql
3)Expand the console root select the server where new database created exist.
4) right click database select all task restore database select the backup file

[team_ferrari22]

Hi,

Actually we are not going to use the backup & restoring techniques of sql server.

Simply we want to allow user to select a backup/snapshot file and our application has to list & display the Tables & columns names which are there in those files. Here we will not use any sql Connection String.... we want to get info in offline manner.

Thank you for replying.

[sknake]

If that functionality exists it would be in SMO:
http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.backupdevice_members(SQL.90).aspx

I looked around but didn't see anything at a glance