| Author |
sql 7 back up and restore questions
|
|
| Mike Drewery 2002-06-28, 3:25 pm |
| I am running sql 7 for an internal ordering system. I do nightly full
backups and transaction log backups every 2 hours during business hours.
Today we had a data crash. I traced it back to a poorly written update
statement in some asp code that happened at 11:30 today. So I know the why
and have fixed it.
My question is this how should I have recovered. I did a restore from full
back up. The transaction log backups occurred at 10 and 12. I found the
error at 12:30. I then restored from the transaction log made at 10:00.
What about the changes made between 10 and 11:30?
I have been looking into transaction log analysers is this what I need to
pursue? Today I was lucky! I can trace by emails sent from asp that 15
changes occurred between 10 and 11:30 and can have users redo. What if it
were 1500?
Any information or links greatly appreciated.
Thanks
Just call me Lucky
| |
| Andrew J. Kelly 2002-06-28, 3:25 pm |
| Mike,
There is an option to stop at a particular time in the transaction log
restores. It is called "STOPAT" oddly enough.. Take a look at RESTORE in
BooksOnLine for more information.
--
Andrew J. Kelly SQL MVP
Targitinteractive, Inc.
"Mike Drewery" <Mike@nowhere.com> wrote in message
news:OPuhWOuHCHA.1180@tkmsftngp09...
> I am running sql 7 for an internal ordering system. I do nightly full
> backups and transaction log backups every 2 hours during business hours.
> Today we had a data crash. I traced it back to a poorly written update
> statement in some asp code that happened at 11:30 today. So I know the
why
> and have fixed it.
>
> My question is this how should I have recovered. I did a restore from
full
> back up. The transaction log backups occurred at 10 and 12. I found the
> error at 12:30. I then restored from the transaction log made at 10:00.
> What about the changes made between 10 and 11:30?
>
> I have been looking into transaction log analysers is this what I need to
> pursue? Today I was lucky! I can trace by emails sent from asp that 15
> changes occurred between 10 and 11:30 and can have users redo. What if it
> were 1500?
>
> Any information or links greatly appreciated.
>
> Thanks
> Just call me Lucky
>
>
| |
| Mike Drewery 2002-06-28, 3:25 pm |
| Thanks for the info. I used the mmc to restore and I saws the restore to a
point in time but I didn't realize I could go down to a specific time. I
thought it was asking for the log time. Well I guess this is how we learn.
If I hadn't known when would an analyzer have helped? Are they worth
getting?
Thanks again
Mike
"Andrew J. Kelly" <akelly@targitinteractive.com> wrote in message
news:#5V52SuHCHA.956@tkmsftngp10...
> Mike,
>
> There is an option to stop at a particular time in the transaction log
> restores. It is called "STOPAT" oddly enough.. Take a look at RESTORE in
> BooksOnLine for more information.
>
> --
> Andrew J. Kelly SQL MVP
> Targitinteractive, Inc.
>
>
>
> "Mike Drewery" <Mike@nowhere.com> wrote in message
> news:OPuhWOuHCHA.1180@tkmsftngp09...
> > I am running sql 7 for an internal ordering system. I do nightly full
> > backups and transaction log backups every 2 hours during business hours.
> > Today we had a data crash. I traced it back to a poorly written update
> > statement in some asp code that happened at 11:30 today. So I know the
> why
> > and have fixed it.
> >
> > My question is this how should I have recovered. I did a restore from
> full
> > back up. The transaction log backups occurred at 10 and 12. I found
the
> > error at 12:30. I then restored from the transaction log made at 10:00.
> > What about the changes made between 10 and 11:30?
> >
> > I have been looking into transaction log analysers is this what I need
to
> > pursue? Today I was lucky! I can trace by emails sent from asp that 15
> > changes occurred between 10 and 11:30 and can have users redo. What if
it
> > were 1500?
> >
> > Any information or links greatly appreciated.
> >
> > Thanks
> > Just call me Lucky
> >
> >
>
>
| |
| Andrew J. Kelly 2002-06-28, 6:25 pm |
| The only tool like that is from www.lumigent.com and it has lots of uses.
They have a pretty good web site you may want to check it out.
--
Andrew J. Kelly, SQL Server MVP
TargitInteractive
"Mike Drewery" <Mike@nowhere.com> wrote in message
news:egoq#cuHCHA.2060@tkmsftngp11...
> Thanks for the info. I used the mmc to restore and I saws the restore to
a
> point in time but I didn't realize I could go down to a specific time. I
> thought it was asking for the log time. Well I guess this is how we
learn.
>
> If I hadn't known when would an analyzer have helped? Are they worth
> getting?
>
> Thanks again
> Mike
>
>
> "Andrew J. Kelly" <akelly@targitinteractive.com> wrote in message
> news:#5V52SuHCHA.956@tkmsftngp10...
> > Mike,
> >
> > There is an option to stop at a particular time in the transaction log
> > restores. It is called "STOPAT" oddly enough.. Take a look at RESTORE
in
> > BooksOnLine for more information.
> >
> > --
> > Andrew J. Kelly SQL MVP
> > Targitinteractive, Inc.
> >
> >
> >
> > "Mike Drewery" <Mike@nowhere.com> wrote in message
> > news:OPuhWOuHCHA.1180@tkmsftngp09...
> > > I am running sql 7 for an internal ordering system. I do nightly full
> > > backups and transaction log backups every 2 hours during business
hours. [colo
r=darkred]
> > > Today we had a data crash. I traced it back to a poorly written[/color]
update
> > > statement in some asp code that happened at 11:30 today. So I know
the
> > why
> > > and have fixed it.
> > >
> > > My question is this how should I have recovered. I did a restore from
> > full
> > > back up. The transaction log backups occurred at 10 and 12. I found
> the
> > > error at 12:30. I then restored from the transaction log made at
10:00. [colo
r=darkred]
> > > What about the changes made between 10 and 11:30?
> > >
> > > I have been looking into transaction log analysers is this what I need
> to
> > > pursue? Today I was lucky! I can trace by emails sent from asp that[/color]
15[co
lor=darkred]
> > > changes occurred between 10 and 11:30 and can have users redo. What[/color]
if
> it
> > > were 1500?
> > >
> > > Any information or links greatly appreciated.
> > >
> > > Thanks
> > > Just call me Lucky
> > >
> > >
> >
> >
>
>
| |
| Mike Drewery 2002-06-29, 2:47 pm |
| Thanks again I will check it out.
Mike
"Andrew J. Kelly" <akelly@targitinteractive.com> wrote in message
news:#Tov24vHCHA.2232@tkmsftngp12...
> The only tool like that is from www.lumigent.com and it has lots of uses.
> They have a pretty good web site you may want to check it out.
>
> --
> Andrew J. Kelly, SQL Server MVP
> TargitInteractive
>
>
> "Mike Drewery" <Mike@nowhere.com> wrote in message
> news:egoq#cuHCHA.2060@tkmsftngp11...
> > Thanks for the info. I used the mmc to restore and I saws the restore
to
> a
> > point in time but I didn't realize I could go down to a specific time.
I
> > thought it was asking for the log time. Well I guess this is how we
> learn.
> >
> > If I hadn't known when would an analyzer have helped? Are they worth
> > getting?
> >
> > Thanks again
> > Mike
> >
> >
> > "Andrew J. Kelly" <akelly@targitinteractive.com> wrote in message
> > news:#5V52SuHCHA.956@tkmsftngp10...
> > > Mike,
> > >
> > > There is an option to stop at a particular time in the transaction log
> > > restores. It is called "STOPAT" oddly enough.. Take a look at
RESTORE
> in
> > > BooksOnLine for more information.
> > >
> > > --
> > > Andrew J. Kelly SQL MVP
> > > Targitinteractive, Inc.
> > >
> > >
> > >
> > > "Mike Drewery" <Mike@nowhere.com> wrote in message
> > > news:OPuhWOuHCHA.1180@tkmsftngp09...
> > > > I am running sql 7 for an internal ordering system. I do nightly
full[
color=darkred]
> > > > backups and transaction log backups every 2 hours during business
> hours.
> > > > Today we had a data crash. I traced it back to a poorly written
> update
> > > > statement in some asp code that happened at 11:30 today. So I know
> the
> > > why
> > > > and have fixed it.
> > > >
> > > > My question is this how should I have recovered. I did a restore[/color]
from[
color=darkred]
> > > full
> > > > back up. The transaction log backups occurred at 10 and 12. I[/color]
found
> > the
> > > > error at 12:30. I then restored from the transaction log made at
> 10:00.
> > > > What about the changes made between 10 and 11:30?
> > > >
> > > > I have been looking into transaction log analysers is this what I
need
> > to
> > > > pursue? Today I was lucky! I can trace by emails sent from asp
that
> 15
> > > > changes occurred between 10 and 11:30 and can have users redo. What
> if
> > it
> > > > were 1500?
> > > >
> > > > Any information or links greatly appreciated.
> > > >
> > > > Thanks
> > > > Just call me Lucky
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|