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.
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
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.