Note: this applies only on a GN4 server.

IMPORTANT: DO THIS ONLY IF THE GN4 DATABASE DOES NOT EXIST ALREADY!

In the SQL Management Studio create an empty database, named GN4, using the default options.

As an alternative, since the version 1.4, you can use dbcreate command of srv4 to create a database from scratch with multiple file groups, each possible split in multiple files, and sized based on an estimate of the overall system size.

Note about optimizing SQL server for creation and growing of database

See the 'Perform Volume Maintenance Tasks (mandatory)' section in Prepare servers for better performances.

Note about quick installing of a test system

There is a quick way to create an empty database with the standard configurations and sample data, or to replicate an existing database in an empty one with the custom schema and configurations.

•To create an empty database with the standard configurations and sample data just run the following command.

•To replicate an existing database in an empty database with the custom schema and configurations, in the CONFIG folder and subfolders overwrite the standard files with your customized files before running the following command.

Important: Open the Command Prompt in the 'Run as Administrator' mode, otherwise it won't work! Make sure that the IIS server is running before running the following command.

Run:

srv4 dbupdate -config ..\config\Editorial_InstallConfig.xml -yes