# Database backups

P4 Warehouse has database backups available every 12 hours. The backups are in a Microsoft bacpac file format. Bacpac is easy to import into any Microsoft SQL version 2008 and up.

{% hint style="info" %}
[Microsoft bacpac instructions](https://docs.microsoft.com/en-us/sql/relational-databases/data-tier-applications/import-a-bacpac-file-to-create-a-new-user-database?view=sql-server-ver15) (click)
{% endhint %}

Step one is to download your data from P4 Warehouse.

Step 2 is In SQL Manager (SSMS) right click on databases and select Import Data-tier Application

Step 3 select the bacpac file you downloaded, then give your database a name.

Step 4 click Finish, (The process normally will take 1-3 minutes to complete.).

![P4 Warehouse Database import in Microsoft SQL Server](https://2764542787-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MdqvtgkbuySRnxUkZY_%2F-Mj912YnGOlQn1B6OHqZ%2F-Mj99cHwqgwanihCB5DE%2Fimage.png?alt=media\&token=bc1d08b4-f0d5-47c3-afdb-d4c9b143b5bd)

![P4 Warehouse Database Tables](https://2764542787-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MdqvtgkbuySRnxUkZY_%2F-Mj912YnGOlQn1B6OHqZ%2F-Mj99vmmcWDywjzRvUw1%2Fimage.png?alt=media\&token=2fa5bdd0-e392-4634-bf65-4feeecab21cc)

### With this database you can connect to PowerBI, run queries, generate reports as well as various other options.

You will find database backups under Setup/System/Database backups

![P4 Warehouse Database backups](https://2764542787-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MdqvtgkbuySRnxUkZY_%2F-Mj912YnGOlQn1B6OHqZ%2F-Mj91fGFveMf2o3xdcd8%2Fimage.png?alt=media\&token=e6be5fa0-b3cf-47a1-94e0-3f9c5286e77c)

By clicking the download button, you will save the backup to your local computer.

{% hint style="info" %}
This is a bacpac file that can be restored onto SQL 2008 R2 or newer. 
{% endhint %}