3PAR Recovery Manager 4.1.0 for Microsoft SQL Server User’s Guide
8.3 Recovering from Logical Errors with Point-in-Time Recovery
Point-in-time recovery is useful for recovering from logical errors. For example, if you
accidentally altered an entry or deleted a table, you can use a virtual copy to restore your
instance or database back to a consistent, known prior state. Point-in-time recovery restores
the instance or database to the state it was in at the time the virtual copy was created.
To perform a point-in-time recovery, use Recovery Manager to perform a file copy restore or a
volume restore. The restore steps depend on whether your SQL servers are in a clustered or
non-clustered environment:
■
If you are performing a file copy or volume restore on an instance on a standalone SQL
production server in a non-clustered environment, stop the SQL Server service for the
instance, perform a standard file copy restore or volume restore, and start the SQL Server
service.
■
If you are performing a volume restore on a database on a standalone SQL production
server in a non-clustered environment, stop the SQL Server service, perform a standard
volume restore, and start the SQL Server service.
■
If you are performing a file copy restore on a database on a standalone SQL production
server in a non-clustered environment, perform a standard file copy restore. (Do NOT stop
and start the SQL Server service .)
NOTE: You must schedule downtime to perform a restore. For more information
about performing a standard restore using the Recovery Manager GUI, see
Chapter 6, Using the Recovery Manager GUI. For more information about
performing a standard restore using the CLI RMSql restore command, see
Chapter 7, Using the Recovery Manager CLI.
■
If you are performing the restore in an MSCS (clustered) environment, you must follow the
instructions provided in one of the following sections, depending on the type of restore
you are performing:
◆
Restoring a SQL Instance in an MSCS Environment Using File Copy Restore on page 8.4
◆
Restoring a Volume in an MSCS Environment Using Volume Restore on page 8.4
Recovering from Logical Errors with Point-in-Time Recovery
8.3
3PAR Confidential

---

...

Other models in this manual:
Software - HP 3PAR StoreServ Application Suite for Microsoft SQL Media (1.27 mb)