We use cookies on our website to ensure we provide you with the best experience on our website. By using our website, you agree to the use of cookies for analytics and personalized content.This website uses cookies. More Information
It seems like your browser didn't download the required fonts. Please revise your security settings and try again.
Barracuda Managed Workplace

Backing Up Databases - Hosting Provider

  • Last updated on

Barracuda Managed Workplace uses Microsoft SQL Server databases for its data repository. Backing up your databases daily lets you respond quickly to failures and maintain high-availability for your customers. Back ups should also be created before upgrading, applying hotfixes or Barracuda Managed Workplace Feature Packs to your production servers. Database backups should be done using a method that results in the SQL engine backing up the database (creating a checkpoint). Windows file level backups (backing up .mdf or .ldf files) is not recommended and can cause problems.

The Barracuda Managed Workplace databases that must be backed up are shown in the table below.

Note: Back up the user databases frequently to ensure the transaction logs do not become full. Daily differential back ups or weekly full back ups are recommended to manage log file growth.

Configuring the Database to use Simple Recovery Model

  1. Open SQL Management Studio and connect to the database server.
  2. Right-click the database and select Properties.
  3. Select Options and choose Simple from the Recovery Model list.
  4. Click OK.

Back Up Strategy for Databases

It is not recommended to shrink the database file as this can be a timely operation, can cause fragmentation and it won’t release any space if there isn’t any white space available.

  1. The maintenance plan below is an example Launch SQL Management Studio and connect to the Service Center database server.
  2. Expand Management and right-click Maintenance Plans. Select Maintenance Plan Wizard. Click Next.
  3. Enter a name for the plan and select the Separate schedules for each task option button. Click Next.
  4. Select the tasks you want to schedule and click Next. recommend including the following:
    • Back Up Database (Full)
    • Back Up Database (Differential)
    Note: The Back Up Database (Transaction Log) is only applicable if you are using the Full recovery model.
  5. Use the Move Up and Move Down buttons to adjust the order in which the maintenance tasks will execute. Click Next.
  6. Configure each task as described below.
  7. Optionally, choose to write a report to a text file (suitable for monitoring with a Barracuda Managed Workplace custom log monitor) or supply an address to which an email will be sent. Click Finish.
To configure a back up database (full) task
  1. Select SCData_Default and click OK.
  2. Choose a location (Disk or Tape) and to Overwrite existing back up files.
  3. Click Change to open the Job Schedule Properties. Set a schedule that suits your needs. Click OK and then Next if it appears.
    Note: We recommend a full back up at least once a week.
To configure a back up database (differential) task
  1. Select SCData_Default and click OK.
  2. Choose a location (Disk or Tape) and to Overwrite existing back up files.
  3. Click Change to open the Job Schedule Properties. Set a schedule that suits your needs. Click OK and then Next if it appears.
    Note: We recommend differential back ups every day when a full back up does not take place.

Best Practice: Perform a full back up of the program directories of Service Center and its associated foundation technologies. This will allow you to examine the file system in the event of failure, including parsing text log files for relevant errors and scanning executables for malware infection.

Creating Backups of the Barracuda Managed Workplace Databases

Beyond scheduling regular backups, you must also take manual backups prior to upgrades or migrations.

  1. Launch SQL Management Studio and connect to the Service Center database server. Expand Databases.
  2. Right-click the database you want to back up and select Tasks > Back Up.
  3. Note the location where the back up file will be created, and click OK. When a dialog box appears advising the back up completed successfully, click OK.
  4. 4Copy the database back up file to a secure storage location.

Backing Up the Reporting Services Encryption Key

The contents of the Reporting Services databases are encrypted. You must back up the encryption key as part of the back up process.

  1. Open the Reporting Services Configuration tool from the SQL program group on your start menu, and select Encryption Keys from the left-hand pane.
  2. Click Backup.
  3. Enter a strong Password then click Browse [...] and select a name and location to store the encryption key file. Click Save. Click OK.
  4. Copy the encryption key file to a secure storage location.
Last updated on