What are some free SQL Server inventory tools?

Question

I'm looking for a free or relatively cheap tools for inventory our SQL Servers. Basically this inventory would provide me the level of details that I can recreate the exact server specifications, store procedures, users/proxies users, number of databases, agent jobs, maintenance plans/dtsx packages, linked servers, views etc. in another location. Any recommendation is much appreciated. If there isn't an existing tools out there, what are some ideas/steps to go about gathering all of these information? Many thanks in advance.

Answer 1

Hi @CharlieLor ,

The information that needs to be collected for each database is very complex, like you said, each of these might need a separate inventory, the tools maybe you can find some through Google, but you need to identify yourself, here can only recommend the basic:

Powershell： SQL Server inventory scripts

Build an Automated SQL Server Database Inventory System

Inventory SQL Server Agent Jobs for all Instances with PowerShell

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Basically this inventory would provide me the level of details that I can recreate the exact server specifications, store procedures,

Also on database object level incl. code?
I don't think there is a tool for your requirement available.
And to recreate everything we have database backups for.