Post reply

How to audit a sql server instance

  • November 13, 2007 at 3:44 pm

    #183851

    Hi,

    I have to audit a large number of databases and gather some pretty simple information such as database name,size, collation, datafile location, backups etc etc.

    I've been looking for some scripts that would do the job as I cant believe I'm the first out there to look for something similar. I'm pretty new to sql server to perhaps that’s why I haven’t found it.

    Any help much appreciated.

    Cheers,

  • November 13, 2007 at 7:46 pm

    #750906

    Have you checked the script library here at SQL Server Central. If you can't find exactly what you are after, you are pretty likely to get something fairly close

    e.g. http://www.sqlservercentral.com/scripts/Miscellaneous/31608/

  • November 13, 2007 at 8:26 pm

    #750911

    I dont know how I missed that one, works really well. I might try add a backup componet also.

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

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