|
|
Posted by JF Fortier on 12/14/06 20:32
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]
|