How to determine current database space usage?
For MS SQL Server, follow these steps:
- Open a command shell cmd.exe
- >sqlcmd -S .\<instance> -U <user> -P <password>
default values:- instance: NETX_SERVER_SQL
- user: sa
- password: netxnetx_123456
- 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 - The usage of the databases in the given instance is shown.
Related articles
-
XDB_ENGINE; Connect to SysDatabase failed. (NETx BMS Server 2.0)
-
-
-
-