Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Mumbai
    Posts
    1

    Unanswered: Unexpected table drop

    Hi
    We are a running sql server 2000(sp3) on a windows 2000 web server m/c.Recently one table on our database got unexpectedly dropped twice two weeks in a row .Our developers here are checking the code but havent found any code errors as such which could cause this.We are also suspecting a security breach but we are not sure.I would like to also mention that we use dts a lot.

    Can anybody tell me why this could have happened.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    The more you can find out by reading Transaction log if you haven't truncated and if you backed up then restore them to other machine to find out, where you can achieve this by using Lumigent's LOG EXPLORER and may use ENTEGRA to audit the events on the database.

    Also you can run PROFILER if this behaviour is consistent.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •