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