About database backup
| Article:HOWTO26908 | | | Created: 2010-01-08 | | | Updated: 2010-01-15 | | | Article URL http://www.symantec.com/docs/HOWTO26908 |
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:
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.
|
|
Legacy ID
349265
Article URL http://www.symantec.com/docs/HOWTO26908
Terms of use for this information are found in Legal Notices
Thank you.