Back Up a Database
42 Agent for Microsoft SQL Server Guide
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.
(see page
30)
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.
(see page 38)
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.
