Forum / Password Vault Manager - Support

Backup Best Practices for PVM?

  • Create an Issue
  • Cancel

We have been really enjoying PVM and would like to put in place ideally an automatic backup method of the database. Is there a way to do this? If not, what is the best export/backup process to backup the entire structure of a database so we can quickly recover in case the production database is down?

We are using Azure SQL services to host our DB.

Thanks.

Clock3 yrs

With SQL Azure you best bet would be to read the following post. I will help match the strategy with your desired protection level.

https://azure.microsoft.com/en-us/documentation/articles/sql-database-business-continuity/

Best regards,

Stefane Lavergne

signaturesignature

Clock3 yrs

The export route is an option but has some limitations. We talk about it here (the post is for RDM but the same holds true for PVM).
Keep in mind that a .pvm export is an encrypted XML file of the data (only the data, not the users & rights or database schema). So if all fails you must create a new database, import the .pvm file & recreate all the users and tweak the settings to match the initial setup.

If you want a "full" restore capabilities (sessions, settings, user*), you can run an Azure SQL backup and download the .bacpac file from storage for local cold storage. You could restore the file locally or upload to Azure in case of a major failure and restore on Azure. Note: Even with this method users will need to be "fixed". PVM now has a "Fix SQL User" button in the user administration screen to recreate the SQL login and link it to the database user.

Regards,

Stefane Lavergne

signaturesignature

Clock3 yrs