Backing up SQL databases

Article:HOWTO24055  |  Created: 2010-01-01  |  Updated: 2011-06-15  |  Article URL http://www.symantec.com/docs/HOWTO24055
Article Type
How To

Product(s)

Subject


Backing up SQL databases

The following procedure provides details on how to back up SQL databases.

See About backing up SQL databases.

See Backing up SQL transaction logs

To back up SQL databases

  1. On the navigation bar, click the arrow next to Backup.

  2. Click New Backup Job.

  3. On the Properties pane, under Source, click Selections, and then select the data you want to back up.

    See How to use Backup Exec logon accounts for SQL resources.

  4. To select SQL data from local or remote selections, click the domain name icon or icons that contain the SQL installations, and then click the actual Windows computer icon that contains the SQL installation. If you are using a cluster, make backup selections from the virtual server.

    A list of shared network directories appears, along with an icon that represents the SQL installation.

    To select all databases in SQL, click the check box preceding the SQL icon, or you can select specific databases by clicking the SQL icon, and then selecting individual databases.

    Whether you make SQL database selections using the Windows domain, Active Directory, DNS names, or IP addresses, you must use the same method when making full, differential, and incremental backups of your SQL databases. For example, do not make full backup selections of your SQL databases using the Windows domain, and then make incremental or differential selections using an IP address.

  5. To select the SQL backup job properties, on the Properties pane, under Settings, click Microsoft SQL.

  6. Select options for the backup job.

    See SQL backup options.

  7. Start the backup job or select other backup options from the Properties pane, and then start the backup job.

    See Creating a backup job by setting job properties


Legacy ID



v20055253_be2010_adm


Article URL http://www.symantec.com/docs/HOWTO24055


Terms of use for this information are found in Legal Notices