May 24, 2004 at 9:27 am
Hello, everyone.
We have a very interesting problem. Fortunately, this was happened with test database. We lost information from one of the tables. There are some developers who worked with this table.
How can we define what happend?
Database backed up once a week, and transaction log every hour?
Thanks in advance.
May 25, 2004 at 6:34 am
Use a Trigger instead of delete in a table
and rollback or other things
May 25, 2004 at 9:03 am
When managing permissions for the table, do not grant delete. Grant permissions to stored procedures that do any necessary deleting.
May 25, 2004 at 1:28 pm
I think what you are asking is, Is there a way to see how this occured? It is possible to view the transaction log file and view the transactions by using Log Viewers like Lumigent. Beware though! These products are VERY expensive.
The best thing to do is to recreate and trace the activity with SQL Profiler.
Hope that helps.
steve
May 25, 2004 at 1:29 pm
Thank you. Yesterday we did these.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply