User's Manual

3PAR Recovery Manager 3.0.2 for Microsoft SQL Server User’s Guide
8.1
Recovery for Microsoft SQL Server
3PAR Confidential
8
Recovery for Microsoft SQL
Server
In this chapter
8.1 Recovery 8.1
8.1.1 Point-In-Time Recovery 8.2
8.1.2 Point-Of-Failure Recovery 8.3
8.1.3 SQL Instance Level File Copy Restore in an MSCS Environment 8.4
8.1.4 Volume Restore in an MSCS Environment 8.5
8.1 Recovery
The SQL Server offers three disaster recovery models:
■ Simple Recovery Model
■ Full Recovery Model
■ Bulk-logged Recovery Model
With simple recovery it is not possible to restore a database to a specific point in time, you can
only restore a database to the exact time when a backup occurred. Therefore, any data
modifications made between the time of the most recent backup and the time of the failure
are lost. This recovery model uses circular logging to minimize the amount of space used for
transaction logs.