About database backup

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


About database backup

When you back up a database, you create a separate copy of it. There are several reasons to back up your database regularly.

Because the size of a database increases over time, you need to regularly back up the database. Backing up databases and removing unused space from databases is a necessary step in the maintenance of a production database.

If a disaster occurs, such as data corruption or hardware failure, you can restore the latest snapshot of the database. To get a clean copy of the database, you must revert to the point before the problem occurred. Some data may need to be reentered into the database during the recovery process. However, the main structure and a majority of the data is retained by using a recent backup.

You can back up the database from the Symantec Endpoint Protection Manager console or by using the Symantec Database Backup and Restore utility. The Symantec Database Backup and Restore utility is automatically installed during the installation.

You can back up in the following ways:

  • Microsoft SQL database only

    You can use the Microsoft SQL Server Enterprise Manager to set up a maintenance plan that includes automatic backups.

  • Embedded or a Microsoft SQL database

    You can perform an on-demand backup and also schedule automatic backups to occur from the console.

Backups should preferably be stored on a separate disk drive. You should back up the disk drive periodically.

See Backing up a Microsoft SQL database.

See Backing up an embedded database.

Legacy ID


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

Terms of use for this information are found in Legal Notices