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.

Recommended Answers

All 3 Replies

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

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.