Backing up your data manually when updating the Bitdefender plugin for Kaseya

This topic describes the steps you must take to manually back up your data when updating Bitdefender Endpoint Security Plugin for Kaseya.

The Endpoint Security Plugin for Kaseya is a module for Kaseya VSA that provides a management console for deploying, monitoring, and interacting with the Bitdefender Endpoint Security agent, an enterprise-class award-winning antimalware solution. Kaseya administrators can use the plugin to remotely install the Bitdefender Endpoint Security agent, manage agent licensing across their organizations, assign custom policies to organizations, machine groups or individual machines, and initiate different types of malware scans.

When updating Endpoint Security Plugin for Kaseya, the installer alters specific data in the database. To prevent any loss of important data, it is strongly recommended to perform a backup before continuing with the installation process.

To back up your data, please follow this step-by-step guide:

  1. Open Microsoft SQL Server Management Studio (open the Run window and execute ssms) and connect to the Kaseya database.

  2. Right-click the database name and select Tasks > Generate Scripts.

  3. In Introduction, click Next.

  4. Then, in Choose Objects, select Select specific database objects.

  5. Expand Tables and check the following tables:

    • bitdef.policies

    • bitdef.policyAdvanced

    • bitdef.policyDisplay

    • bitdef.policyExclusionItems

    • bitdef.policyExclusions

    • bitdef.policyOnaccess

    • bitdef.policyOndemand

    • bitdef.policyQuarantine

    • bitdef.policyScantasks

    • bitdef.policyUpdateLocs

    • bitdef.policyUpdates

  6. Click Next.

  7. In Set Scripting Options, click Advanced.

  8. Under General, look for the Types of data to script option and set its value as Schema and data. Then click OK.

  9. Set the backup file name and path in the File name box and click Next.

  10. In Summary, review the backup parameters, then click Next.

  11. In Save or Publish Scripts, wait for the backup process to finish, then you can close the wizard by clicking Finish.

Please verify that the backup script was created at the path you set.

If you need to restore the backup data, simply open the script in Microsoft SQL Server Management Studio and run to create/insert instructions as needed.

Once you have the backup script generated and saved, you can safely continue with the setup process.