Post reply

log of query fired on particular database

  • March 26, 2009 at 3:57 am

    #202286

    pls help me i need to have a log of the queries fired on a database as thru one of the query some data has been deleted or table has been emptied

  • March 26, 2009 at 6:30 am

    #966573

    unless you have a trace already set up and running, you cannot find out who deleted data, and aside from that, will most likely NOT be able to recover data that has been deleted. you will need to restore a previous database to a new name, and copy the old data into the current.

    the sole rare exception is if the database is in recovery mode FULL instead of SIMPLE, in that case, you can use a Log Reader program, like the one from RedGate(Red Gate Log Rescue for SQL 2000), to find and restore deleted data.If your database is not in Receovery Mode FULL, the data vhange is gone, and cannot be recovered.

    sorry to be the bearer of bad news.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply