Skip to main content

SQL Server Databases

This report lists the properties of databases and database snapshots hosted on the selected SQL Server instance. Use this report for your SQL Server database inventory.

sqlserverdatabases_thumb_0_0

Reported data​

For each database, the following information is reported:

  • Database name
  • Restrict access mode— as set in the database properties >Options>State. Possible values are: Multi_user (for Multiple), Restricted, Single. See this Microsoft article for details.
  • State— as set in the database properties**>Options>State**. See this Microsoft article for details
  • Size (MB)
  • Shrink enabled— as set in the database properties >Options>Automatic>Auto Shrink. See this Microsoft article for details.
  • Encryption status— as set in the database properties >Options>State. See this Microsoft article for details.
  • Last full backup date— local date and time for the audited SQL Server instance.

In some cases, the backup time will be displayed in server ticks.

  • Data file path— .MDF file path.
  • Log file path— .LDF file path.

For each database snapshot, the following information is reported:

  • Database snapshot name
  • Source database name
  • Restrict access mode — as set in the database properties at snapshot creation time.
  • State — as set in the database properties at snapshot creation time.

Filters​

This report has the following filters:

  • Monitoring plan — name of the monitoring plan set to collect data from the SQL Server instance hosting the required database.
  • Item — name of the item within your monitoring plan, here — SQL Server instance.
  • Time zone — time zone where Netwrix Auditor server is located, for example, UTC-08:00. This value is filled in automatically.
  • Database name — database to report on. Default is all databases on selected SQL Server instance (%).

Considerations and recommendations​

Reporting for case-sensitive SQL Servers and databases isn't supported.

Usage example​

Database administrators in the Corp organization need to perform an inventory of the SQLSrv01\SQLServer2016 instance. This instance is included in the monitoring plan named SQL Servers Monitoring.

To examine the relevant data, they generated the SQL Server Databases report with the default filters.