Bak file How to open 2000w data how to open? _mssql

First of all, this bak file is a backup file for the SQL database, and you can use SQL recovery to query the

Find the file you need

Note that the decompression is 7gb+.

1. Download SQL Server Express (with manager)

2, the installation of the "New Installation"

3. Open SQL Server Management Studio

4, right click Red Circle "Database"-----"RESTORE Database"

Determine import---Waiting to complete

And then this database will appear.

Right button, click on the top 1000 lines, the right side will appear as shown

You can see that with this code you can display 1000 lines of information

So let's get rid of that top 1000.

Become like this

And then the most critical

Join at the bottom

Click "Execute"

The results will appear below.

I use SSD to search, about 10 seconds to complete the retrieval, so you weigh it yourself.