How to Backup and Restore Without Using .BAK

In previous tutorial, we have given tutorial about how to backup SQL database to local. In this tutorial, we will explain how to backup and restore database without using .bak file.

1. Backup Database

  • First of all, log into your SQL Server Management Studio using your username and password.
  • After login, go to Databases folder in the Object Explorer and click on the database that you want to take the backup of.
  • After that, right-click on that database name and go to Tasks -> Export Data-tier Application, as shown in the below image.

A pop-up Screen will appear where you need to click on “Next”.

On the next screen, select the “Settings” tab and click the first radio button, i.e., “Save to local disk”. Click on the Browse button and select the path where you want to save the file and give its name. This will take the extension as .bacpac and the screen looks like below.

Click “Next” and again click “Finish”. And after that, it will take some time.

Finally, click “Close”.

Now, go to the path where you have saved the file and you can see there is a bacpac file available there, as shown in below figure.

Restore Database

Go to SQL Server Management Studio -> Databases, and right-click on it. Now, click on “Import Data-tier Application”.

Click “Next” and from the next pop-up screen, check the “Import From local Disk” radio button.

After that, click the “Browse” button and select the Demo.bacpac file which you had previously exported. Now, our screen will look ike below.

Click “Next”.

A new screen appears where we can change our database name (it is optional).

Click “Next” and again, click “Finish”. It will take some time to restore. Once done, click “Close”.

Now, refresh your databases in SQL Server Management Studio and you can see that the restored database in the Object Explorer of SQL Server Management Studio.

Here, we used the .bacpac file to backup and restore the database. A bacpac file (.bacpac) is a zipped file that can contain tables, procedures, and the entire schema, similar to the .bak file.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *