topic SQL server 7 in Operating System - Microsoft

SQL server 7

mackowiak_2 — Thu, 15 May 2003 13:08:40 GMT

Is there a tool or a tip to analyse SQL log.
We have detected that a part of our database have been deleted, but we don't know how.
someone to help us ?
thanks...

Re: SQL server 7

Jon Finley — Thu, 15 May 2003 22:13:05 GMT

There ARE some tools some free and some NOT:

http://www.windowsitlibrary.com/Content/77/21/1.html

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_0tyf.asp

http://www.windowsitlibrary.com/Topics/Topic.cfm?TopicID=79&Topic=SQL%20Server%20and%20Database

http://www.embarcadero.com/downloads/downloadlogexplorer.asp

http://www.lumigent.com/AboutLumi/News/2001-01-29.htm

http://www.lumigent.com/products/le_sql/le_sql.htm

Jon

Re: SQL server 7

mackowiak_2 — Fri, 16 May 2003 05:51:53 GMT

In your links I only find one tool (log explorer but expensive for use it one time) and nothing to really explorer the logs after the delete.
thanks

Re: SQL server 7

Jon Finley — Fri, 16 May 2003 14:55:43 GMT

Both of the $$ utility liks I gave you have a 30 day free trial. You can't solve it within that time period? :-)

The other links gave information of how to decipher the logs using the built-in utilities that came with SQL Server.

Jon