How to find the size of Dynamics NAV database in SQL Server Management Studio?

I have shown you, how easy it is to find the size of the database from Dynamics NAV client. However sometimes you need to get the same information without the luxury of running Dynamics NAV client. For this, you can turn to SQL Server Management Studio…

Similar as in Dynamics NAV, you can achieve same results by following different routes.

How to find the size of Dyanmics NAV database in SQL Server Management Studio #1
1. In SQL Server Management Studio, right-click on the database and select Properties:
Database Size - SQL Database Properties
2. Click on “General” tab and check “Size” property:
Database Size - SQL Database Properties

How to find the size of Dyanmics NAV database in SQL Server Management Studio #2
1. In SQL Server Management Studio, right-click on the database and select “New Query”:
Database Size - New Query
2. Type sp_spaceused and click “Execute”:
Database Size - New Query

How to find the size of Dyanmics NAV database in SQL Server Management Studio #3
1. In SQL Server Management Studio, right-click on the database and select Reports > Standard Reports > Disk Usage:
Database Size - Reports - Disk Usage
2. Check report’s results:
Database Size - Disk Usage Report

Result!

Technorati Tags: , , , , ,

This entry was posted in Dynamics NAV / Navision, SQL and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *