0

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.

3
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by sknake
1

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

0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.