| Author |
How to restore a Transaction Log and do a forward roll?
|
|
| T.Taylor 2006-02-17, 11:23 am |
| We have SQL Server 7.0 and the drive it was on died before we completed
our weekly backup. The logs are on a different drive so that was ok.
We were able to restore the previous weeks data but now we would like
to do a forward roll from the Transaction logs. How do we restore the
transaction logs (*.TRN) files and how do we do a forward roll?
Thanks.
| |
| Andrew J. Kelly 2006-02-17, 11:23 am |
| When you restored the FULL backup from last week you needed to do it with
the NORECOVERY option to allow logs to be applied. Then you apply (restore)
each log backup in order with a NORECOVERY option as well except for the
very last one. That one will need to be with the RECOVERY option to allow
the db to be usable again. You might want to consider doing nightly full
backups in the future.
--
Andrew J. Kelly SQL MVP
"T.Taylor" <taylort2@juno.com> wrote in message
news:1140191971.583239.89750@g44g2000cwa.googlegroups.com...
> We have SQL Server 7.0 and the drive it was on died before we completed
> our weekly backup. The logs are on a different drive so that was ok.
> We were able to restore the previous weeks data but now we would like
> to do a forward roll from the Transaction logs. How do we restore the
> transaction logs (*.TRN) files and how do we do a forward roll?
>
> Thanks.
>
| |
| T.Taylor 2006-02-17, 11:23 am |
| Do you have any sample scripts we could use or any links to them? The
scripts we have been finding are for SQL Server 2000. We are looking
for SQL Server 7.0 scripts.
Thanks again.
| |
|
|
|
|