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.
  4. From the command prompt, run set pitbackup=1.
  5. Point-In-Time backup is enabled.
  6. From Arcserve UDP Console, perform a backup of SQL database.
  7. The N recovery point is created.
  8. 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.
      3. _<DatabaseName>.cat.pit
      4. Contains variable size of time point details.
      5. _<DatabaseName>.map.pit
      6. 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.
      3. <SQLInstanceName>_<DatabaseName>.cat.pit
      4. Contains variable size of time point details.
      5. <SQLInstanceName>_<DatabaseName>.map.pit
      6. Contains mapping between the internal string and internal string identity.
  9. From Arcserve UDPConsole, perform another backup of SQL database.
  10. The N+1 recovery point is created.
  11. From the command prompt, run set pitrestore=1.
  12. Point-In-Time restore is enabled.
  13. 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
  14. From command prompt, run set pittime=”<MM/DD/YYYY HH:MM:SS:ss>"
  15. From Arcserve UDP Console, perform database level restore to original location using the N recovery point.
  16. The Point-In-Time restore is successfully completed. Verify that the expected data is restored to database.