restore a transaction

Hello,
Someone came to me and asked me to restore a record, deleted by acident via
an ERP program. Problem is how do we restore only his record without
touching integrity of other peoples record. There are more then 20 table
involved when record is created or deleted.
MCWell I would restore the latest backup of the database to a dev enviornment
and locate that one record, then linked togeather all the information about
that record from each table and go from there to determine what can be
restored. It makes a difference on the type of data that was stored about
the record.. if that record is just a single entry or it it has several
detailed entries in a log table about that records activity in the database.
"CAMC1" wrote:
> Hello,
> Someone came to me and asked me to restore a record, deleted by acident via
> an ERP program. Problem is how do we restore only his record without
> touching integrity of other peoples record. There are more then 20 table
> involved when record is created or deleted.
> MC
>
>|||That is what I tought.
I told the user that it is faster to re-create the record via his
application the restoring 1 user transaction.
MC
"JosephPruiett" <JosephPruiett@.discussions.microsoft.com> wrote in message
news:A36EF0B2-03E8-476D-A8FD-AC867228C453@.microsoft.com...
> Well I would restore the latest backup of the database to a dev
enviornment
> and locate that one record, then linked togeather all the information
about
> that record from each table and go from there to determine what can be
> restored. It makes a difference on the type of data that was stored about
> the record.. if that record is just a single entry or it it has several
> detailed entries in a log table about that records activity in the
database.
>
> "CAMC1" wrote:
> > Hello,
> > Someone came to me and asked me to restore a record, deleted by acident
via
> > an ERP program. Problem is how do we restore only his record without
> > touching integrity of other peoples record. There are more then 20 table
> > involved when record is created or deleted.
> >
> > MC
> >
> >
> >|||ABSOLUTELY!!!
Good way to handle it! It's rarely cost effective to restore just a small
amount of data.
--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"CAMC1" <webmaster@.ozoptics.com> wrote in message
news:%23IEvOoDrGHA.3380@.TK2MSFTNGP04.phx.gbl...
> That is what I tought.
> I told the user that it is faster to re-create the record via his
> application the restoring 1 user transaction.
> MC
> "JosephPruiett" <JosephPruiett@.discussions.microsoft.com> wrote in message
> news:A36EF0B2-03E8-476D-A8FD-AC867228C453@.microsoft.com...
>> Well I would restore the latest backup of the database to a dev
> enviornment
>> and locate that one record, then linked togeather all the information
> about
>> that record from each table and go from there to determine what can be
>> restored. It makes a difference on the type of data that was stored
>> about
>> the record.. if that record is just a single entry or it it has several
>> detailed entries in a log table about that records activity in the
> database.
>>
>> "CAMC1" wrote:
>> > Hello,
>> > Someone came to me and asked me to restore a record, deleted by acident
> via
>> > an ERP program. Problem is how do we restore only his record without
>> > touching integrity of other peoples record. There are more then 20
>> > table
>> > involved when record is created or deleted.
>> >
>> > MC
>> >
>> >
>> >
>|||Thanks
MC
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:ecgEBzDrGHA.4032@.TK2MSFTNGP03.phx.gbl...
> ABSOLUTELY!!!
> Good way to handle it! It's rarely cost effective to restore just a small
> amount of data.
> --
> Arnie Rowland
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "CAMC1" <webmaster@.ozoptics.com> wrote in message
> news:%23IEvOoDrGHA.3380@.TK2MSFTNGP04.phx.gbl...
> > That is what I tought.
> > I told the user that it is faster to re-create the record via his
> > application the restoring 1 user transaction.
> > MC
> >
> > "JosephPruiett" <JosephPruiett@.discussions.microsoft.com> wrote in
message
> > news:A36EF0B2-03E8-476D-A8FD-AC867228C453@.microsoft.com...
> >> Well I would restore the latest backup of the database to a dev
> > enviornment
> >> and locate that one record, then linked togeather all the information
> > about
> >> that record from each table and go from there to determine what can be
> >> restored. It makes a difference on the type of data that was stored
> >> about
> >> the record.. if that record is just a single entry or it it has several
> >> detailed entries in a log table about that records activity in the
> > database.
> >>
> >>
> >>
> >> "CAMC1" wrote:
> >>
> >> > Hello,
> >> > Someone came to me and asked me to restore a record, deleted by
acident
> > via
> >> > an ERP program. Problem is how do we restore only his record without
> >> > touching integrity of other peoples record. There are more then 20
> >> > table
> >> > involved when record is created or deleted.
> >> >
> >> > MC
> >> >
> >> >
> >> >
> >
> >
>|||"CAMC1" <webmaster@.ozoptics.com> wrote in message
news:%23IEvOoDrGHA.3380@.TK2MSFTNGP04.phx.gbl...
> That is what I tought.
> I told the user that it is faster to re-create the record via his
> application the restoring 1 user transaction.
You forgot the "AND NEVER DO THAT AGAIN!" part. :-)
> MC
> "JosephPruiett" <JosephPruiett@.discussions.microsoft.com> wrote in message
> news:A36EF0B2-03E8-476D-A8FD-AC867228C453@.microsoft.com...
> > Well I would restore the latest backup of the database to a dev
> enviornment
> > and locate that one record, then linked togeather all the information
> about
> > that record from each table and go from there to determine what can be
> > restored. It makes a difference on the type of data that was stored
about
> > the record.. if that record is just a single entry or it it has several
> > detailed entries in a log table about that records activity in the
> database.
> >
> >
> >
> > "CAMC1" wrote:
> >
> > > Hello,
> > > Someone came to me and asked me to restore a record, deleted by
acident
> via
> > > an ERP program. Problem is how do we restore only his record without
> > > touching integrity of other peoples record. There are more then 20
table
> > > involved when record is created or deleted.
> > >
> > > MC
> > >
> > >
> > >
>