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 |
|
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 ..
|
|
|
|
|
|
|
Need to know details about old data update