Post reply

Database Droped

  • May 6, 2005 at 12:19 pm

    #88388

    Hi, I have a problem, Today I saw that one of my databases is missing, I look at Management, Sql server agents, Jobs to verify backup task and it fails because tha database no longer exist.

    Exists a way to know who drops it, when, or what happened with the table, I'm looking at error.log but nothing is there, maybe in a systable?

     

    Thanks for your help.

     

  • May 6, 2005 at 11:50 pm

    #557487

    Theres really no way to find out what happened unless you have some solution put in place to monitor this. Using a log reading tool you can read the transaction log backup to determind when the log was dropped.

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

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