|
|
Posted by othellomy on 12/15/06 04:01
Hi,
You should restore from device and set it up to choose the backup file
name making sure you have the right file directory under the options
tab. Can you ask someone to show you how?
JF Fortier wrote:
> Hi
>
> OK, Phase 2
>
> I have restore the backup file from the tape, it's now a Database_Dt1_Bak
> file on my HD
> All I want to know now is how do I get to see inside that file ??
> I'm going to look inside and see what whore the 5 Identity that are erase
> and using identity on/off, I will go back and put the 5 news keys to the
> original key are VOILA it's done.
>
> In the database dt1 I have many sub-database..... and the one that I need to
> set back to original is about 15 rows only.....
>
> With Entreprise Manager, I can go see the database, I can create a new one,
> but I don't know how to setup this new temporary database to the server as
> dt1_Bak.
>
> The only option I have is to create a new one, then I try to restore data
> from my file into the database.... I can't it ask for backup file done with
> Backup Manager, it won't allow my to select source from a file....
>
> Thank you all for your help
>
>
> <othellomy@yahoo.com> a écrit dans le message de news:
> 1166074174.862413.301830@l12g2000cwl.googlegroups.com...
> > Hello JF,
> > You need to tell me:
> > 1. What is the structure of the table where data is lost(?). Primary
> > keys, foreign keys etc.
> > 2. What is the nature of the problem ie what data was there before and
> > what got lost and what data is there now.
> > 3. Any other relevant issues.
> > Once you provide these 3 details maybe we can look into it. Doesn't
> > sound like a complex issue though.
> >
> > JF Fortier wrote:
> >> Hi group
> >>
> >> I'm not familiar with the name, newbies user.
> >>
> >> The SQL key is call Row # ?? if that correct can it be possible to create
> >> a
> >> new record and replace that unique ID key to a previous erase value ??
> >>
> >> Some one did a terrible mistach by erasing data without knowing the full
> >> consequence of her act, now I lost all reference from 6 years of reports
> >> job
> >> cost because of that, so when creating the new key and replacing the Row#
> >> with the original, all link to that will be restore.
> >>
> >> Thank you
> >>
> >> JF Fortier
> >
Navigation:
[Reply to this message]
|