V
V
Vladdden2020-05-08 01:00:52
C++ / C#
Vladdden, 2020-05-08 01:00:52

How to extract data from a database backup (SQL Server)?

Good afternoon, I am a final year student, now I am writing a diploma (a kind of corporate application for document archives). One of the functions that the customer indicated as "key" -

I want to attach a database backup, press the "create" button, and have your application automatically generate some kind of IPS (information retrieval system) that allows you to work with this data.

The customer is using sql server. I looked through the bak file itself through a hex editor, hoping to find all the data there in clear text, but to no avail (I understand that this is stupid and not safe, but it was worth a try). Google surfing didn't give anything either(( Perhaps there is a way to import it as a file with a large sql query, but I didn't find it in SQL Server Management Studio.
Are there any ways to implement this? Or should I give up this idea?
Appendix I write on a scarf.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2020-05-08
@Vladdden

"Tasks", "Disconnect". After that you will be able to copy your database files ( mdf, ldfand maybe ndf) to the customer and "Attach" it there.
Documentation: Detaching a Database , Attaching a Database .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question