space managment

  • hello experts i have around 700 databases in my UAT server and soo many logins, i have strong feeling in thease DBs and logins most of them are unusable, but thing is that how wud i know unused DBs and logins to remove them.

    pls help

    thanks in advance

  • You can make use of the scripts mentioned in this article to find out when was the database last accessed.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • which version of sql server are using in your UAT server.

    Is databases & Logins created by you (DBA)?

    Are you using UAT server as Database Hosting server?

    Ram
    MSSQL DBA

  • i am using 2005

    ya m a DBA and DBs and login created by me

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

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