Enhancement request: Unable to create SpotlightPlaybackDatabase (4280437)

Enhancement request: Unable to create SpotlightPlaybackDatabase

During installation selecting 'Create' to create the SpotlightPlayback database yields the following error: "Error creating SpotlightPlaybackDatabase...The primary file must be at least 1000MB to accommodate a copy of the model database." Why is this happening after several years it was first raised.The problem is that the createPlaybackDatabase.sql script needs to be modified to allow for the model database being larger than the size specified by the script.

Failed to create Playback database.

This issue has been accepted for enhancement request with reference numeber PT48217643.

To apply work around edit below files:

C:\Program Files (x86)\Quest Software\Spotlight on SQL Server\Console\Scripts\createPlaybackDatabase.sql

Change

 SELECT @sql = N' create database [{{DATABASE_NAME}}]
     on   (name=[{{DATABASE_NAME}}_Data],
             filename='''+@szPath+'{{DATABASE_NAME}}_Data.mdf'',
             size=' + convert(varchar(20),@datasize) + 'mb,filegrowth=10%)
     log on (name=[{{DATABASE_NAME}}_Log],
            filename='''+@szPath+'{{DATABASE_NAME}}_Log.ldf'',
            size=' + convert(varchar(20),@logsize) + 'mb,filegrowth=10%) '

To

 SELECT @sql = N' create database [{{DATABASE_NAME}}]
     on   (name=[{{DATABASE_NAME}}_Data],
             filename='''+@szPath+'{{DATABASE_NAME}}_Data.mdf'')
     log on (name=[{{DATABASE_NAME}}_Log],
            filename='''+@szPath+'{{DATABASE_NAME}}_Log.ldf'') '

C:\Program Files (x86)\Quest Software\Spotlight on SQL Server\Console\Scripts\createPlaybackDatabaseWithFiles.sql

Change similar section of code to

 SELECT @sql = N' create database [{{DATABASE_NAME}}]
     on   (name=[{{FILENAME}}],
             filename=''{{FULL_FILENAME}}'')
     log on (name=[{{LOGNAME}}],
            filename=''{{FULL_LOGNAME}}'') '

PT 48217643