You should back up a database immediately after you create it and continue to back it up on a regular schedule to ensure smooth recovery from a database or media failure. Maintain regular backups of all databases, including:
Important! Microsoft SQL Server 2000, 2005, 2008, 2012 and 2014 Mirror databases and Point-in-Time Snapshots cannot be backed up and do not appear in the database list. For more information about database mirroring and Point-in-Time Snapshots of databases, see the Microsoft SQL Server documentation.
During backup jobs, certain files are excluded. Arcserve Backup has two registry keys you can use to control the files to include or skip. The type of database agent you are using determines which registry key to use for this purpose. To include SQL database files in a backup job, set the BackupDBFiles registry key to 1. Do not use SkipDSAFiles with SQL database files. For more information, refer to the topic, Skip or Include Database Files in Backups.
Important! Performing a backup can slow the system down. For better backup performance and to minimize impact on applications using the database, run backups when the database is not being heavily updated.
|
Copyright © 2016
|
|