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 |
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
 Posted - 2011-01-25 : 08:31:19
|
| Hi EveryoneI was asked to find out on a incorrect data update that happenedWhere should I be starting.I am not an admin on the database and do not have permissions to track everything.Based on the directions I will contact our DB admins for more informations |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-01-25 : 08:36:55
|
| Not really much you can do unless there's some auditting enabled.If you have tr log backups you could replay them to find out when it happened maybe.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-01-25 : 08:38:00
|
 Do you have data audit tables? That would be the very first question I would ask. If you do, then ask to look at them for the data you require, else give up as it will be nearly impossible to track back. |
|
|
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
Posted - 2011-01-25 : 08:49:14
|
| I am not sure whether we have auditing setup on our database serversWill contact one of our DBA and get back Thanks |
|
|
|
|
|
|
Transaction History