Perform Point-In-Time Restore

1. Run the file PIT.EXE.
2. Point-In-Time command line utility opens and displays PIT$ command prompt.
3. For more information, view Understanding Point-In-Time Command Line Utility.
2. From the command prompt, run set pitbackup=1.
3. Point-In-Time backup is enabled.
3. From Arcserve UDP Console, perform a backup of SQL database.
4. The N recovery point is created.
4. Verify that the following files are generated under 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 internal string identity.
5. From Arcserve UDPConsole, perform another backup of SQL database.
6. The N+1 recovery point is created.
6. From the command prompt, run set pitrestore=1.
7. Point-In-Time restore is enabled.
7. From command prompt, run the below SQL queries to view the time point information of N+1 backup session:
   1. Query <SQLInstanceName>\<DatabaseName> <BackupDestination>\Catalog\<N+1 backup session folder name>
   2. Displays all time points summary in backup
8. From command prompt, run set pittime=”<MM/DD/YYYY HH:MM:SS:ss>"
9. From Arcserve UDP Console, perform database level restore to original location using the N recovery point.
10. The Point-In-Time restore is successfully completed. Verify that the expected data is restored to database.