How to Determine Current PlateSpin Database Sizes

  • 7018474
  • 10-Jan-2017
  • 19-Jan-2017

Environment


NetIQ PlateSpin Forge
NetIQ PlateSpin Migrate
NetIQ PlateSpin Protect

Situation

Microsoft SQL Server Express limits the size of the databases ranging from 4 GB to 10 GB depending on the version. You suspect that an issue may be caused by hitting the size limit imposed by SQL Express, but do not know how to determine if this is the case.

Resolution

Execute the following query from Microsoft SQL Server Studio to determine if you are indeed hitting the upper limit imposed by Express.

select
 SQL_Server_Version = @@version,
 SQL_Server_Edition = serverproperty('Edition'),
 SQL_Server_Name = serverproperty('ServerName'),
 Database_Name = a.Name,
 Maximum_Database_Size_MB = case when serverproperty('EngineEdition') in (1, 4) then case when cast(serverproperty('ProductVersion') as nvarchar(128)) like '8.%' then '2048 MB' when cast(serverproperty('ProductVersion') as nvarchar(128)) like '9.%' then '4096 MB' when cast(serverproperty('ProductVersion') as nvarchar(128)) like '10.0%' then '4096 MB' else '10240 MB' end else 'Effectively no limit' end,
 Data_Size_MB = convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)),
 Available_Growth_MB = case when serverproperty('EngineEdition') in (1, 4) then case when cast(serverproperty('ProductVersion') as nvarchar(128)) like '8.%' then 2048 when cast(serverproperty('ProductVersion') as nvarchar(128)) like '9.%' then 4096 when cast(serverproperty('ProductVersion') as nvarchar(128)) like '10.0%' then 4096 else 10240 end end - convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2))
from
 sys.sysfiles a
where
 a.name not like '%_log';

From the MS SQL Studio open the Object Explorer by selecting View > Object Explorer (or by pressing F8).
To execute the query select the desired PlateSpin Database, click on New Query from the menu bar and paste the statement above into the query window. Once the query has been pasted into the window, click on Execute. The results will show the maximum database size and how much space is available.

Feedback service temporarily unavailable. For content questions or problems, please contact Support.