Change SQL Server Database Auto Growth Settings for Omnissa Access

When you create the database, the default settings for auto growing is 1 MB for data files. The auto growth setting for the Omnissa Access database must be increased to 128 MB.

To see the vIDMDB database file auto growth setting, navigate to DataBase Properties > Files. The setting is displayed in the Autogrowth / Maxsize column.

Procedure

1. Log in to the Microsoft SL server Management Studio session as the sysadmin or a user account with sysadmin privileges.

2. In the toolbar, click New Query.

3. To change the auto growth setting, run the following command.

   ALTER DATABASE <saasdb>
   
           MODIFY FILE ( NAME = N'<saasdb>', FILEGROWTH = 128MB )
   
   GO
   

Results

The auto growth setting is changed to 128 MB.