Need to know details about old data update

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

SQL Server 2005 Forums

SQL Server Administration (2005)

Need to know details about old data update

Author

Topic

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2011-10-31 : 12:37:28

Hi Team!!

someone update my critical database somedays ago with mass update, now i wanna know details about that transaction. please help me to find out the Login details for the seesion that mass update my DB.

FYIP,
i dont have any auditing enabled on the db.
i Have full backup and transaction log backups for the DB availiable.

Guys please give me some wayout to the problem

Thanks in advance

Thanks
Chander

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-31 : 13:27:19

not very sure you will be able to retrive those details if you dont have auditing enabled or captured trace.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2011-10-31 : 14:01:49

quote:
Originally posted by visakh16

not very sure you will be able to retrive those details if you dont have auditing enabled or captured trace.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Thanks for the reply Visakh!
I think there must me a wayout.. nothing is impossible!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-01 : 04:36:57

quote:
Originally posted by chander_2580

quote:
Originally posted by visakh16

not very sure you will be able to retrive those details if you dont have auditing enabled or captured trace.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Thanks for the reply Visakh!
I think there must me a wayout.. nothing is impossible!

Good luck is what i can say

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Sachin.Nand

2937 Posts

Posted - 2011-11-01 : 12:04:29

what exactly are you trying to achieve here ? Do you want to know who updated the records or do you want to get the records in the same state as the before the updation ?

If you want the former then I am afraid it is not possible without having some kind of auditing or traces but if you want the later then it is possible if you have log backups and have a rough idea at what time the updation happened so that you can restore it to a time before the updation occurred.

PBUH

chander_2580
Yak Posting Veteran

76 Posts

Posted - 2011-11-02 : 08:39:26

thanks guys for your comments .. i think its time to enable auditing on every sql server to avoid such situations ..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources