Perform Point-In-Time Restore
- Run the file PIT.EXE.
- Point-In-Time command line utility opens and displays PIT$ command prompt.
- For more information, view Understanding Point-In-Time Command Line Utility.
- From the command prompt, run set pitbackup=1.
- Point-In-Time backup is enabled.
- From Arcserve UDP Console, perform a backup of SQL database.
- The N recovery point is created.
- Verify that the following files are generated under Catalog folder:
- If the SQL Server Instance name is MSSQLSERVER (default Instance Name):
- _<DatabaseName>.idx.pit
- Contains fixed size of time point summary.
- _<DatabaseName>.cat.pit
- Contains variable size of time point details.
- _<DatabaseName>.map.pit
- Contains mapping between the internal string and internal string identity.
- If the SQL Server Instance name is other than MSSQLSERVER (not the default Instance Name):
- <SQLInstanceName>_<DatabaseName>.idx.pit
- Contains fixed size of time point summary.
- <SQLInstanceName>_<DatabaseName>.cat.pit
- Contains variable size of time point details.
- <SQLInstanceName>_<DatabaseName>.map.pit
- Contains mapping between the internal string and internal string identity.
- If the SQL Server Instance name is MSSQLSERVER (default Instance Name):
- From Arcserve UDPConsole, perform another backup of SQL database.
- The N+1 recovery point is created.
- From the command prompt, run set pitrestore=1.
- Point-In-Time restore is enabled.
- From command prompt, run the below SQL queries to view the time point information of N+1 backup session:
- Query <SQLInstanceName>\<DatabaseName> <BackupDestination>\Catalog\<N+1 backup session folder name>
- Displays all time points summary in backup
- From command prompt, run set pittime=”<MM/DD/YYYY HH:MM:SS:ss>"
- From Arcserve UDP Console, perform database level restore to original location using the N recovery point.
- The Point-In-Time restore is successfully completed. Verify that the expected data is restored to database.