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 2000 Forums
 SQL Server Administration (2000)
 Problem in SQL Server 2000, (Help Required)

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

Posted - 2006-07-28 : 15:52:10
You'll need a third party tool to read the transaction log. Here are two such tools:

http://www.red-gate.com/products/sql_log_rescue/index.htm
http://www.lumigent.com/products/le_sql.html

Tara Kizer
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-07-28 : 17:01:27
hopefully you have backups.



-ec
Go to Top of Page

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 details

Kristen
Go to Top of Page
   

- Advertisement -