HELP: Point in time restore

Pagus,
you options are:
(a) Restore full backup 1: 13:00
(b) Restore full backup 2: 17:00
(c) Restore full backup 2 and log 1 17:05
(d) Restore full backup 2 and do a point-in-time restore
of the log to any time between 17:00 and 17:05
To restore to 15:10, you'd need to have backed up a log
between the 2 database backups. Point-in-time is only
possible as part of the log restore, which has a concept
of transactions performed at specific times, while a
database backup only knows when the backup was created.
HTH,
Paul Ibison (SQL Server MVP)
[vbcol=seagreen]
Yup, full backup at 17:00 was mistake !
Many thanks Paul,
Pagus
On Wed, 20 Oct 2004 01:52:13 -0700, "Paul Ibison"
<Paul.Ibison@.Pygmalion.Com> wrote:

>Pagus,
>you options are:
>(a) Restore full backup 1: 13:00
>(b) Restore full backup 2: 17:00
>(c) Restore full backup 2 and log 1 17:05
>(d) Restore full backup 2 and do a point-in-time restore
>of the log to any time between 17:00 and 17:05
>To restore to 15:10, you'd need to have backed up a log
>between the 2 database backups. Point-in-time is only
>possible as part of the log restore, which has a concept
>of transactions performed at specific times, while a
>database backup only knows when the backup was created.
>HTH,
>Paul Ibison (SQL Server MVP)
>
>