Results 1 to 4 of 4

Thread: Delete Database

  1. #1
    Join Date
    Jul 2003
    Location
    somerset
    Posts
    10

    Unanswered: Delete Database

    A database disappeared from one of our qa servers last night yet when we looked at the logs no record of the drop datbase command was to be found like wise no record of create database.
    Can any one tell me where we can look in sqlserver or on the windows 2000 server fro a record of these events

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Yikes! I'd never really looked at my SQL Error log files when I dropped a database, but it appears that there is no entry for this event in there. I dunno where to tell you to go from here...

    I would suggest that you audit your security settings, remove anyone from the sysadmin group that doesn't absolutely positively have to be there and for sure set up to audit failed logins.

    Regards,

    hmscott
    Last edited by hmscott; 12-08-05 at 13:18.
    Have you hugged your backup today?

  3. #3
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Might try the event logs on the server. At least you'll have an idea who was doing what and when.

  4. #4
    Join Date
    Jul 2003
    Location
    somerset
    Posts
    10
    Thanks for the advice fortunately it was a dev server so no real damange and we could restore it.
    Lokks like there may be a case to go to microsoft and see if it could be added .

Posting Permissions

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