6.2

Table Of Contents
You can also set database growth settings with scripts. The script commands to set the IaaS database to
VMware defaults are as follows. In these examples, "dbname" is the name of the database.
ALTER DATABASE dbname
MODIFY FILE
(NAME = dbname, MAXSIZE = UNLIMITED, FILEGROWTH = 1024MB)
ALTER DATABASE dbname
MODIFY FILE
(NAME = dbname_log, MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
Create the IaaS Database Manually
The system administrator can create the database manually using VMware-provided scripts.
Prerequisites
n
.NET 4.5.1 or later must be installed on the SQL Server host.
n
Use Windows Authentication, rather than SQL Authentication, to connect to the database.
n
Verify the database installation prerequisites. See IaaS Database Server Requirements.
n
Download the IaaS database installer scripts from the vRealize Appliance by navigating to
https://vcac-va-hostname.domain.name:5480/installer/.
Procedure
1 Navigate to the Database subdirectory in the directory where you extracted the installation zip
archive.
2 Extract the DBInstall.zip archive to a local directory.
3 Log in to the Windows database host with sufficient rights to create and drop databases sysadmin
privileges in the SQL Server instance.
4 Review the database deployment scripts as needed. In particular, review the settings in the
DBSettings section of CreateDatabase.sql and edit them if necessary.
The settings in the script are the recommended settings. Only ALLOW_SNAPSHOT_ISOLATION ON and
READ_COMMITTED_SNAPSHOT ON are required.
5 Execute the following command with the arguments described in the table.
BuildDB.bat /p:DBServer=db_server;
DBName=db_name;DBDir=db_dir;
LogDir=[log_dir];ServiceUser=service_user;
ReportLogin=web_user;
VersionString=version_string
Installation and Configuration
VMware, Inc. 89