Backing Up Microsoft SQL Server Databases › Back Up a Database

Previous Topic: Mark Objects for Explicit Job Packaging

Next Topic: Restoring Microsoft SQL Server Databases

Back Up a Database

Use the Backup Manager in CA ARCserve Backup to back up databases.

To back up a database

  1. Ensure that Microsoft SQL Server is running on your server. The Microsoft SQL Server service must be started.
  2. Start the CA Backup Universal Agent, if necessary.

    Note: This service is started automatically when the agent is installed and is set to start automatically if the machine is restarted.

  3. Open the Backup Manager and locate the Microsoft SQL Server instance, listed under the name of the computer on which it is running. Expand the Microsoft SQL Server instance to display a list of databases.
  4. Click Options to access Global Options and then click the Agent Options tab to access the Global Agent Options, if desired. For more information about setting Global Agent Options, see Backup Manager Agent Options.
  5. If you are backing up from a Microsoft SQL Server 7.0 or 2000 instance, right-click the Microsoft SQL Server instance and select Transfer Method from the pop-up window. The Remote Protocol dialog opens. Select a data transfer mechanism and click OK.

    If you are backing up from a Microsoft SQL Server 2005 or 2008 instance, go to the next step.

    The default mechanism is Virtual Devices.

    Note: Select Named Pipes only if you have backup operator rights, but do not have system administrator rights, or if you cannot use Virtual Devices. Named Pipes is not available for Microsoft SQL Server 2005 and later.

    In prior releases of this agent, Virtual Devices were always used for local backups and TCP/IP backups.

  6. Choose a database under the Microsoft SQL Server instance. Information about the selected database appears in the right pane of the Backup Manager.

    Note: For information about how you can select a database to apply options properly for backup, see Dynamic and Explicit Job Packaging.

  7. Right-click the database object and select Agent Options from the pop-up window. The Agent Options dialog for Microsoft SQL Server opens. The options available vary based on the version of the Microsoft SQL Server instance and the Recovery Model of the database.
  8. Select the backup method you want to perform, and the subset type you want to perform it on. For more information about backup methods and subsets, see Backup Methods.
  9. If you chose the Files-and-FileGroups subset, click the Browse button. The Specify FileGroups and Files dialog opens.

    Select the specific files and FileGroups you want to back up and click OK.

  10. (Optional) Enable a Database Consistency Check and select the Database Consistency Check options. For more information about Database Consistency Checks, see Database Consistency Checks and the Microsoft SQL Server documentation.
  11. If you selected the Transaction Log backup type, or the Backup Transaction Log After Database option, select a Transaction Log Truncation Option.
  12. Click OK.
  13. Repeat the preceding steps for each database you are backing up in this job.
  14. On the Destination tab in the Backup Manager, select a backup destination.

    Note: You can use the * symbol in the Group or Media fields to create partial wildcards when you select a backup destination. For example, if you have two sets of device groups, one with all members beginning GroupA and the other with all members beginning GroupB, you can select all the GroupA members by entering GroupA* in the Group field. For more information about selecting devices and media, see the Administration Guide.

    Click the Schedule tab and select the scheduling options for this backup. For information about scheduling backups, see the Administration Guide.

  15. Click Submit. The Security and Agent Information dialog opens.

    Note: In this dialog, the column and button labeled Agent refer to the Client Agent for Windows, not the Agent for Microsoft SQL Server. You can edit client agent information at this time. For more information about client agents, see the Administration Guide.

    Verify the user name and password for the target machine and for Microsoft SQL Server. To change the security information for Microsoft SQL Server, click Security and change the information in the dialog.

  16. After verifying or changing the security information, click OK. The Submit Job dialog opens.
  17. (Optional) Use the Submit Job dialog to select the job execution time, submit the job on hold, add an optional job name for the backup job, or select source priority.
  18. Click OK.

    The job is submitted.

    If you selected the Run Now option, the Job Status window opens. Use this window to monitor the current status of your job. For more information about the Job Status window, see the Administration Guide.