Tuesday, February 21, 2012

RESTORE

Hi all,
Which tool can I use to RESTORE a database to a point in time 3 day before.
This database has only one FULL daily backup that overwrites the last one.
I´ve tried to use the STOPAT clause, but it didn´t work.
Thanks in advance
Adolfo JaborandyAdolfo Jaborandy wrote:
> Hi all,
> Which tool can I use to RESTORE a database to a point in time 3 day before.
> This database has only one FULL daily backup that overwrites the last one.
> I´ve tried to use the STOPAT clause, but it didn´t work.
> Thanks in advance
> Adolfo Jaborandy
>
Without transaction log backups, you can't... A full database backup is
a snapshot of the COMMITTED activity in the database. In order to
restore to a point in time, you need to start with a full backup that
was done prior to that point in time, and then you "replay" (by
restoring transaction log backups) all of the transactional activity
that has taken place since the full backup, stopping at the specific
point in time that you desire.
Tracy McKibben
MCDBA
http://www.realsqlguy.com

No comments:

Post a Comment