Specifications

Copyright © Acronis, Inc., 2000-2010 30
- Transaction Logs backup every twenty minutes
• Database size is large and activity is high, recovery model is Simple:
- Full backup once a week
- Differential backup twice a day
For advice on creating the best strategy you can also rely upon Acronis Recovery for MS SQL
Server Assistant while working with the Create Backup wizard. See
Using Acronis Recovery
for MS SQL Server Assistant
(p. 39) for detailed information.
We recommend that you do not to use several third-party backup tools simultaneously since
backup operations may conflict or affect the operation of your databases. Instead, combine
different backup methods to protect your data with Acronis Recovery for MS SQL Server.
5.1.4 Recovery Models
There are three database recovery models: Full, Simple and Bulk-logged. In most cases
databases use the simple or full recovery models.
Full Recovery Model
Full recovery model requires backing up logs, which allows you to restore to the point in time
just before the data was corrupted and prevent data loss.
The disadvantage of this recovery model is that it requires storage space and makes
restoration slower and complicated.
Simple Recovery Model
The Simple recovery model does not store transaction logs, so you can recover your
databases only to the point in time when the last backup was created. Therefore, it is
recommend that you create backups (full or differential, in accordance with the backup
strategy you defined) often enough to prevent significant data loss. For critical databases it
is better to use the full recovery model.
Bulk-logged Recovery Model
Bulk-logged recovery model uses transaction logs for non-bulk operations fully logged and
bulk operations minimally logged. Data may be lost when restoring from bulk operations
(e.g. SELECT INTO).
The bulk-logged recovery model requires log backups. It is an adjunct of the full recovery
model and provides recovery to the end of any backup (but not to any point-in-time). In
case the log was damaged or bulk-logged operations occurred after the latest log backup,
data changes will be lost. This is the least secure recovery model.
5.1.5 Backup Levels
Acronis Recovery for MS SQL Server backs up databases as well as separate filegroups.
You can choose to back up databases by separate filegroups when the database size and
performance requirements make it not practical to create full database backups. In this case,
each time the task is being executed, only one filegroup will be backed up.
As with instances and databases, you can create full and differential backups for filegroups
as well, but this is available for Microsoft SQL Server 2000 only.