Perform Point-In-Time Restore

This section provides information about how to perform Point-In-Time recovery.

Follow these steps:

1. Log into the Arcserve UDP Console.
2. Navigate to resources > Plans > All Plans.
3. If you have created plans earlier, those plans are displayed on the center pane.
3. From the Action drop-down list of a plan, select Modify.
4. To enable PIT restore for respective nodes, under Advanced tab, select the Enable Point-in-time recovery for SQL Server check box, and then click Save.
5. 
6. The Point-in-time backup is enabled.
5. On the Arcserve UDP Console, perform a backup of SQL database.
6. The N recovery point is created.
6. Verify that the following files are generated under the Catalog folder:
   1. If the SQL Server Instance name is MSSQLSERVER (default Instance Name):
      1. _<DatabaseName>.idx.pit
      2. Contains fixed size of time point summary.
      2. _<DatabaseName>.cat.pit
      3. Contains variable size of time point details.
      3. _<DatabaseName>.map.pit
      4. Contains mapping between the internal string and internal string identity.
   2. If the SQL Server Instance name is other than MSSQLSERVER (not the default Instance Name):
      1. <SQLInstanceName>_<DatabaseName>.idx.pit
      2. Contains fixed size of time point summary.
      2. <SQLInstanceName>_<DatabaseName>.cat.pit
      3. Contains variable size of time point details.
      3. <SQLInstanceName>_<DatabaseName>.map.pit
      4. Contains mapping between the internal string and the internal string identity.
7. On the Arcserve UDP Console, perform another backup of SQL database.
8. The N+1 recovery point is created.
8. Access the restore method selection dialog in one of the following ways:
9. From Arcserve UDP Console:
1. Log into the Arcserve UDP Console.
2. Navigate to resources > Node > All Nodes.
3. All the added nodes are displayed in the center pane.
3. Right-click the node, and then click Restore.
4. You are automatically logged into the agent node console, and the Restore dialog opens.
10. From Arcserve UDP Agent (Windows):
1. Log into the Arcserve UDP Agent (Windows).
2. On the home page, select Restore.
3. The Restore dialog opens.
9. On the Restore dialog, click the Browse Recovery Points option.
10. The Browse Recovery Points page appears.
10. To perform the Point-in-time restore, select the date for recovery from Recovery Point Date, the scheduled time for recovery from Time Range, select the Microsoft SQL Server database to be restored, and then click Next.
11. Note: You can enable the PIT option only when the N and N+1 backup sessions have PIT enabled.
12. 
13. The Restore Options page opens.
11. On the Restore Options page, do the following, and then click Next:
• Destination: Select the Restore to original location option as the restore destination.
• Backup Encryption or Password Protection: Specify the backup encryption password when the data you are trying to restore is encrypted, if necessary.
• Notes:
• Password is not required if you are attempting to restore from the same Arcserve UDP Agent (Windows) computer from where the encrypted backup was performed. However, if you are attempting to restore from a different Arcserve UDP Agent (Windows) computer, a password is required.
• If a clock icon appears with a lock symbol, it indicates that the recovery point contains encrypted information and may require a password for restore.
12. 
13. The Restore- Job Level Options page appears
12. Select the Job level options for restore, and then click Next.
13. Recovery State
• RECOVERY Mode: By default, this option is enabled. It makes the SQL database online to allow data recovery and provides you permission to access the restored database.
• NORECOVERY Mode: The database transitions to a ‘RESTORING’ state to prevent users from accessing the database. To restore the last backup and bring the database online for usage, use the RECOVERY Mode option.
14. Database Consistency Check
15. To make sure that the database is consistent after a restore, select the Run database consistency check after the restore checkbox. This option checks the physical and logical integrity of objects in an SQL Server database. If you want to mark the restore job as failed when the consistency check fails for the selected database, select the Mark the restore as failed if the consistency check fails check box.
16. Miscellaneous
• Force restore over existing files or database: This option overwrites the existing database files located at the restore destination. Not selecting this option for an existing database file can make the restore incomplete. You can skip this option when the database file is new.
• Restricted user access after restore: This option restricts access to the database file for a specific group of users such as sysadmin, dbcreator, and/or db_owner. These users have permissions to modify the database.
• Note: If the source database was already in the restricted mode during the backup, the restored database automatically stays in the same mode.
17. 
18. The Restore Options- Original Location page appears.
13. To configure or change the configuration at a database level, click the Configure button.
14. 
15. The Additional Database Options dialog appears.
14. To perform PIT restore, under Miscellaneous, select the Log point-in-time restore check box, set the time point, and then click OK.
15. 
16. Note: To view transaction details, click the Click here hyperlink.
17. The Transaction Details dialog appears and displays the list of transactions based on the date time selected on the Additional Database dialog.
18. On the Transaction Details dialog, do the following:
1. To configure the transactions listed at a database level, click the Select this event button.
2. 
3. Note: To view the transactions performed between N and (N+1) recovery points, use the Previous and Next buttons.
4. The Additional Database Options dialog appears.
2. Select the Log point-in-time restore check box, set the time point, and then click OK to return to the Restore Options- Original Location page.
19. The Restore Options- Original Location page appears.
15. Click Next.
16. The Restore Summary page opens.
16. On the Restore Summary page, review the displayed information to verify that all the restore options and settings are correct.
• If the summary information is not correct, click Previous to go back to the applicable dialog and change the incorrect setting.
• If the summary information is correct, click Finish to launch the restore process.
17. 
18. The Point-In-Time restore is successfully completed.
19. After the restore finishes, view the restore status in the Activity Log. Also verify that the expected data is restored to database.