Backing up SQL transaction logs

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

Product(s)

Subject


Backing up SQL transaction logs

You can use Backup Exec to back up SQL transaction logs.

See How to back up SQL transaction logs.

See About restoring SQL databases and file groups

See Restoring from SQL transaction logs up to a point in time

See Restoring from SQL transaction logs up to a named transaction

To back up SQL transaction logs

  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, 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.

  5. To select 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



id-SF700193162_be2010_adm


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


Terms of use for this information are found in Legal Notices