Backup and Restore Application Database

Author: Kepion Product Team

Introduction

You can transfer an application between environments with the backup and restore process of SQL Server. This guide will cover both of these processes.

Backup Database

Expand the Databases node, and locate the application database. The application database will have the same name as the application in Kepion.

Click OK on the Locate Database Files dialog. To begin the backup, click OK on the main Back Up Database dialog. Once the backup is complete, the following dialog will appear:

Your database backup file will now be available at the specified file location.

Tip: You can choose to zip the <application_name>.bak file to minimize the size.

Restore Database

Open SQL Server Management Studio and connect to your instance of SQL Server.

 Right-click on the Databases node and choose Restore Database…

Ensure the Source is set to Device and click on the […] button next to Device to select the databases you wish to restore.

Once the Select backup devices window is open, ensure the backup media type is set to File and click the Add button to begin adding the .bak files you wish to restore.

Locate the file to restore and select OK.

Once all the files you wish to restore have been selected, click OK.

Finally, you will be taken back to the original pop-up window to verify that all the information is correct. Once you’re ready to restore the selected databases, click OK.