Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hizakemi
Starting Member
33 Posts |
 Posted - 2006-05-02 : 15:27:15
|
| I have a table is sql server which has analyst name, decision type, decision date and other fields. For some reason analyst name, decision type, decision date were updated yesterday by mistake. I need to put it back they way it was before the update took place. Are the scripts I can use to solve this problem?Please, let me know if you need more clarification.Thank much! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-02 : 15:28:19
|
| Do you have a full backup from yesterday? Do you have transaction log backups?Tara Kizeraka tduggan |
 |
|
|
hizakemi
Starting Member
33 Posts |
Posted - 2006-05-02 : 15:29:48
|
This is an old server- dont have any backupThkquote:
Originally posted by tkizer
Do you have a full backup from yesterday? Do you have transaction log backups?Tara Kizeraka tduggan
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-02 : 15:33:00
|
| It is not possible to restore your data without a backup. Regardless of the age of it, you should have backups. Now is the time to start performing them in case this happens again.Tara Kizeraka tduggan |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-03 : 01:48:33
|
| Also when performing updates and deletes, do them in Test server. After you are happy with the results apply them in Production serverMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
sql help