You can use ESI to create and configure new SQL Server databases.
To create one or more SQL Server databases:
In the left pane of the ESI window, select Applications > SQL Server Groups.
In All Groups, select the SQL Server and instance for the database.
Click Script Execution and then click Create Database.
On the Create Database page, specify the following.
|
Field |
Description |
|
Use Selected Instance Storage |
Select to use the selected instance for the database, which you select in All groups. |
|
Data Storage |
Select Create New Storage and click Go to create a new disk, which opens the Create Disk wizard for to specify the disk details. Or if using a selected instance, select the disk folder for the data storage and click Go. |
|
Log Storage |
Select Create New Storage and click Go to create a new disk, which opens the Create Disk wizard for to specify the disk details. Or you can select an existing disk and click Go. |
|
Use Selected Server or Instance |
Select to use the selected server or instance for storage. |
|
Server |
Select the server for the new database or databases. |
|
Instance |
Select the instance for the new database or databases. |
|
Database Name |
Type a unique database name. |
|
File Name |
Type a unique file name for the database or databases. |
|
Folder(s) |
Type a folder path for the database or databases. |
|
Bulk Create |
Select Create Multiple Databases to create multiple databases. Or leave the default of 1 to create one database. |
Confirm or change the following default settings for the new database or databases.
|
Field |
Description |
|
Bulk Create Create a folder for each database |
Default is False. |
|
Number of Databases to Create |
Defaults to the Bulk Create number value set in step 4. |
|
Database Data File Growth Rate |
Default is 1. |
|
Data Growth Rate Type |
Default is MB. |
|
Default Log File Size |
Default is 1. |
|
Log File Growth Rate |
Default is 10. |
|
Log Growth Rate Type |
Default is Percentage. |
|
Maximum Data File Size |
Default is -1. |
|
Maximum Log File Size |
Default is based on the Log Storage setting in the previous step. |
|
Use Separate Data and Log Disks |
Default is False. |
|
Misc Remember My Settings |
Default is True. |
|
Server and Instance Create Database on Default Instance |
Default is True. |
|
Storage Creation Create Shared Folder |
Default is False, you can change it to True to create a shared folder for the new database or databases. |
|
T-SQL Show Script Before Creating Database |
Default is True, which displays the T-SQL script after you click Create database. |
Click Create database to create the database.
When the Created Database message appears, click OK.
