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 |
kamii47
Constraint Violating Yak Guru
353 Posts |
Posted - 2006-07-28 : 15:32:01
|
AOA i have a problem regarding SQL Server 2000 i have a database in LAN envoirnment, any user delete some important rows from a table, now how can i come to know that when and which user delete these rows. i opened the log file (.ldf) but it in binary format. waiting your reply |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-07-28 : 17:01:27
|
hopefully you have backups.-ec |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-07-29 : 04:36:47
|
You can retrieve this data from Transaction Backups, if you have any, or from a transaction backup that you make now (after the fact) if you have a FULL backup from before the accident AND your database is set to FULL (and not SIMPLE).You could probably also restore a FULL backup from before the accident (to a SEPARATE database) and compare the databases to see what was lost, and re-insert the missing data, but this will only be up to the point at which the FULL backup was made and NOT to the point at which the accident happened.If you do not have Transaction backups consider an appropriate backup policy NOW - before it happens again.If you have NO backups then Tough! but see previous point anyway!See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=How%20Backup%20works,What%20type%20of%20backup%20should%20I%20use,Backup for some more detailsKristen |
|
|
|
|
|