> For the complete documentation index, see [llms.txt](https://docs.p4warehouse.com/v2/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.p4warehouse.com/v2/system/database-backups.md).

# 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="/files/cBqZgudVeZVVgnIZJf5U" 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.