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 Yosemite Server Backup

Configuring Backup for Microsoft SQL Server

  • Last updated on

You can watch a short video on configuring the Yosemite Server Backup agent for backing up and restoring SQL Server databases.

You can configure any Yosemite Server Backup feature by selecting the object from the Catalog  view and updating information on its property pages.

  1. Select the Administration desk bar and open the Catalog view.
  2. Select Network, then select the Microsoft SQL Server on your system.
  3. Expand the object until you see a list of database instances.

    Switch to the Folders view to display a hierarchical tree of the Yosemite Server Backup management domain.

     

  4. Right-click the database instance and display its property pages.
  5. Select the Configuration command to display the Configuration page.

    Barracuda Networks recommends that you use the default values on the Configuration page.

     

SettingDescription
User name Yosemite Server Backup sends this name to Microsoft SQL Server whenever the SQL administrator user name is required. Type the Microsoft SQL administrator name in this field. The default is sa.
PasswordYosemite Server Backup sends this SQL administrator password to Microsoft SQL Server with the SQL administrator’s user name whenever required. There is no default value.
Force Modes

As explained in the next section, the Backup mode setting of a backup job affects Microsoft SQL Server database instances differently than file types. The Force Modes settings control how Yosemite Server Backup backs up the database instances.

The settings here are only applicable to Microsoft SQL Server database instances; all other file types are backed up in the job’s default mode. For example, if the Backup mode of a job is set to Incremental  and the Force modes setting for incremental jobs is set to Full, Yosemite Server Backup will back up the SQL Server database instance in Full mode, but all other file types in Incremental mode.

You can use this feature to ensure that databases in the instance are always backed up in Full mode but that other files are only backed up when changed. This guarantees the greatest security for the most crucial files. that is, the SQL Server database instances. By backing up only the changed files and not the entire network, backup jobs are kept to a manageable size.

Full

When the Backup mode of a job is set to Full, Yosemite Server Backup checks this setting to see how the job should be run with SQL database instances. Full is the only possible setting, so the database instances will be backed up in this mode. In this case, both the databases and the transaction logs are backed up.

Differential

 When the Backup mode of a job is set to Differential, Yosemite Server Backup checks this setting to see how the job should be run with SQL database instances. By default, Yosemite Server Backup runs the jobs as an incremental job and so only the transaction logs are backed up.

There is no distinct Differential job mode for SQL Server database instances.

If you want jobs with a Differential backup mode to back up both the database and the transaction logs, change this setting to Full. In this case, Yosemite Server Backup will treat the SQL Server database instances as if it were running a job in Full backup mode.

IncrementalWhen the Backup mode of a job is set to Incremental, Yosemite Server Backup checks this setting to see how the job should be run with SQL databases. By default, Yosemite Server Backup runs the jobs as an incremental job and so only the transaction logs are backed up.
Last updated on