SQL Simple Recovery Restore

The array supports the simple recovery process to restore data. In order to recover database backups from snapshots, choose a consistent set of database and log volumes, online them, and attach them to the database. You can have the original database together with its snapshot to compare entries, or have the snapshot replace the original.

Under the simple recovery model, logs are flushed or truncated either immediately after some activity or periodically if the server is idle. When you use VSS Services to take snapshots, all that is needed to take snapshots is to setup a volume collection. Because snapshots are taken instantaneously, the array can take backups every hour or more frequently, instead of the traditional 24-hour period or longer. These backups are stored efficiently, minimizing the capacity used by backups.