How to determine current database space usage?

For MS SQL Server, follow these steps:

1. Open a command shell cmd.exe
2. >sqlcmd -S .\<instance> -U <user> -P <password>
   default values:
   • instance: NETX_SERVER_SQL
   • user: sa
   • password: netxnetx_123456
3. execute following command:
   select name AS DBName, SQL_Server_Edition = serverproperty('Edition'), SQL_Server_Version = serverproperty('ProductVersion'), 
   (CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT) / 128.0) as SpaceUsedMB FROM sys.database_files WHERE type = 0 and name = 'NETX_<your workspace>'
   go
4. The usage of the databases in the given instance is shown.

Related articles

• Page:
  XDB_ENGINE; Connect to SysDatabase failed. (NETx BMS Server 2.0)

  • bms-server
  • error-message-description
  • database
• Page:
  XDB Status OFFLINE -- What Can I Do? (NETx BMS Server 2.0)

  • database
  • server
• Page:
  What kind of MS SQL Server license do I need? (NETx BMS Server 2.0)

  • bms-server
  • database
  • sql
• Page:
  Manual installation of the SQL Server instance (NETx BMS Server 2.0)

  • database
  • bms-server
• Page:
  Is there a maximum database size? (NETx BMS Server 2.0)

  • bms-server
  • database
  • space
  • sql