How to restore BACPAC file via SSMS

Created by Eugene Lum, Modified on Wed, 2 Oct at 12:52 PM by Eugene Lum

Overview:

Backup package (BACPAC) contains schema and data for SQL Server database, user may export and import bacpac file via SSMS.

Scenario:

User get backup file with bacpac format and want to restore.

Solution:

1. Login SSMS with the respective login details

2. Right click on the database folder and click on Import Data-tier Application option

3. The restore wizard will pop up

4. Click on Browse and select bacpac file and click on Next

5. SSMS will guide to database settings page, user can rename the database name here and change data file and log file path.

6. Verify the setting and click Finish

7. After import complete click on Close and can go to QNE Business Solution and append the database