# Database Backups

P4W warehouse management system provides data base backups available every 24 hours. The backups are in a Microsoft bacpac file format. Bacpac is easy to import into any Microsoft SQL version 2008 and up.

{% embed url="<https://learn.microsoft.com/en-us/sql/relational-databases/data-tier-applications/import-a-bacpac-file-to-create-a-new-user-database?view=sql-server-ver15>" %}

To download a backup file, navigate to Setup > System > Database backups and click 'Download' next to the chosen option.&#x20;

<figure><img src="https://4069128715-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F5fCRH6psoWyRQyD8J9vh%2Fuploads%2F2n6SJjRpsKtepWpdhBny%2Fdatabackups.png?alt=media&#x26;token=7dc426b2-d651-47c4-9c94-206228fb5682" alt=""><figcaption></figcaption></figure>

With this database user can connect to PowerBI, run queries, generate reports as well as various other options without affecting live system.