Post reply

deleted databases

  • January 20, 2011 at 11:37 pm

    #245720

    Hi

    Are there any way to view the history of deleted databases on a SQL Server 2005 installation?

    /Andy

  • January 20, 2011 at 11:58 pm

    #1276392

    Andy,

    What sort of information are you looking for about the deleted databases?

    Satnam

  • January 21, 2011 at 12:17 am

    #1276396

    Hi

    Name would be a good start, just to see which ones been deleted, time would be beneficial as well.

    /Andy

  • January 21, 2011 at 3:46 am

    #1276453

    If it was deleted recently it may be in the default trace. Otherwise no. If you want audit info, you have to put something in place to capture and store it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

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