| Groups | Blog | Home |
sql server (alternate) : SQL can it be done ?
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 If you've lost some data then first see if you can restore it from a backup. Assuming you want to recover some data selectively then you can restore to a new database and extract the data you want. Maybe you just need to know how to insert an IDENTITY column value. In that case, use the SET IDENTITY_INSERT option: SET IDENTITY_INSERT tbl ON; INSERT INTO tbl (id, col1, col2) VALUES (1234, 'foo','bar'); SET IDENTITY_INSERT tbl OFF; Hope this helps. -- David Portas, SQL Server MVP Whenever possible please post enough code to reproduce your problem. Including CREATE TABLE and INSERT statements usually helps. State what version of SQL Server you are using and specify the content of any error messages. SQL Server Books Online: http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx --
[quoted text, click to view] 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 If you're asking if a value can be reverted back after a commit, I strongly doubt it. What are your backup policies? PLEASE don't say you haven't backed up this db in the whole 6 years...?
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
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. [quoted text, click to view] 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
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... [quoted text, click to view] > 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 >
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? [quoted text, click to view] 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 on= e, > 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 wi= th > Backup Manager, it won't allow my to select source from a file.... > > Thank you all for your help > > > <othellomy@yahoo.com> a =E9crit 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 cre= ate > >> 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 fu= ll > >> consequence of her act, now I lost all reference from 6 years of repor= ts > >> job > >> cost because of that, so when creating the new key and replacing the R= ow# > >> with the original, all link to that will be restore. > >> > >> Thank you > >> > >> JF Fortier > >
Don't see what you're looking for? Try a search.
|
January 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |