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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Transaction History

Author  Topic 

jim_jim
Constraint Violating Yak Guru

306 Posts

Posted - 2011-01-25 : 08:31:19
Hi Everyone
I was asked to find out on a incorrect data update that happened

Where 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.
Go to Top of Page

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.
Go to Top of Page

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 servers
Will contact one of our DBA and get back

Thanks
Go to Top of Page
   

- Advertisement -