Post reply

finding old/inactive databases

  • May 4, 2009 at 12:12 pm

    #133839

    I need a way to identify old/used/inactive databases in SQL 2005, what is the best and most reliable way to do this?

  • May 4, 2009 at 1:03 pm

    #988317

    I recently did that by running a server-side trace for a month. There were several databases where the only connections to them were maintenance plans.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • May 4, 2009 at 7:55 pm

    #988504

    Heh... if you want to play the part of a BSOFH, take the databases offline one at a time and wait for someone to sqawk. 😛

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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