Example of Restoring a Database to a Point In Time

Provided is an example of restoring a database to a point-in-time based on the dump database dates and times.

Example of dump history
Date	Dump time	Type of dump
Aug 14	11:04 AM	database dump
	12:20 PM	transaction dump
	2:20 PM	transaction dump
	7:00 PM	transaction dump
Aug 17	9:00 AM	transaction dump
	9:00 AM	transaction dump
	2:16 PM	transaction dump
Aug 23	10:27 AM	database dump
	2:00 PM	transaction dump
	9:30 PM	transaction dump
Sep 28	8:00 AM	transaction dump
	9:00 AM	transaction dump
	12:14 PM	transaction dump

sybrestore prompts you to select a range of time based on the database dump history.

For example, based on the information in the above table, you see:

1 : [Aug 23 2012 10:27:45:206AM, Sep 28 2012 12:14:50:063PM]
2 : [Aug 14 2012 11:04:58:330AM, Aug 17 2012  2:16:17:206PM]

You can select a time range by entering the list number. For example, enter 2 for the time range [Aug 14 2012 11:04:58:330AM, Aug 17 2012 2:16:17:206PM].

Next, enter a time that falls between Aug 14 2012 11:04:58:330AM and Aug 17 2012 2:16:17:206PM. For example, enter:

Aug 16 2012 10:00 A.M