A backup is a copy or image of a database, Transaction Log, or collection of files or FileGroups that is stored on another device (typically, a media drive). A differential backup is a collection of changes or differences that have been made within a database and can be combined with an earlier backup to create a newer image. Use Arcserve Backup and the Agent for Microsoft SQL Server to generate backups using the SQL Server Backup statement.
To back up a database is to create a copy of its tables, data, and user-defined objects. In the event of media failure, you can recover your databases if you made regular backups of your databases and their Transaction Logs.
Important! Transaction Logs are not backed up or truncated during full or differential database backups. To back up and truncate Transaction Logs, perform a separate Transaction Log backup or use the Backup Transaction Log After Database option, and select the "Remove inactive entries from Transaction log" option to truncate the log files. For more information about Transaction Log backups, see Transaction Log Backups.
When a Microsoft SQL Server backup is started in Arcserve Backup, the Agent for Microsoft SQL Server initiates an online backup of a database or Transaction Log. This backup takes place while the database is active. The backup captures the state of the data at the moment the statement is executed. No partial transactions are captured. Any data changes made after the backup begins are not captured in the backed up copy of the database.
|
Copyright © 2015 Arcserve.
All rights reserved.
|
|