Creating a database on an instance of SQL Server

Before you begin

Ensure that the instance already exists and is running. See Creating an instance of SQL Server.

To create an SQL Server database on a node

1. From the Management Console, navigate to the SQL instance on which you want to create a database.
2. Select Provision > Add SQL Server Database.

3. In the Identification page, populate the following fields, and click Next.

   Field	Description
   Choose Template	(Optional) Select a template for this operation. See Setting up SQL Server media. If you select a template, click Skip Ahead to advance directly to the next step that requires input. An informational message appears on these steps, in green type, listing the fields that require entries before advancing to the next step.
   SQL Server Database Name	Type the name of the new database.

4. In the Custom Scripts Configuration page, select any pre-provisioning or post-provisioning scripts that you want to run as follows, and click Next.

   Section	Description
   Pre-Provisioning Script Directory	(Optional) Select the scripts that you want to run before this event and click to move them to the Selected list box. The scripts in Selected are run in the order listed. Use Move Up and Move Down to re-order the scripts when necessary. See also Managing pre-provisioning and post-provisioning script files.
   Post-Provisioning Script Directory	(Optional) Select the scripts that you want to run after this event and click to move them to the Selected list box. See also Managing pre-provisioning and post-provisioning script files.

5. In the Primary Datafiles page, populate the following fields, and click Next.

   Field	Description
   Logical Name	Type the logical name of the datafile.
   Fully Qualified file name	Type the physical path of the datafile.
   Initial Size	(Optional) Type the initial size of the datafile.
   Maximum Size	(Optional) Type the maximum size of the datafile.
   Growth Increment	(Optional) Type the size to grow the database file with each increase.

   Note

   Click Add to create another datafile.

6. In the Additional Datafile Groups page, populate the following fields, and click Next.

   Field	Description
   Datafile Group Name	(Optional) Type the logical name of the datafile group.
   Logical Name	Type the logical name of the datafile.
   Fully Qualified file name	Type the physical path of the datafile.
   Initial Size	(Optional) Type the initial size of the database file.
   Maximum Size	(Optional) Type the maximum size of the database file.
   Growth Size	(Optional) Type the size to grow the database file with each increase.

7. In the Logfiles page, populate the following fields, and click Next.

   Field	Description
   Logical Name	Type the logical name of the logfile.
   Fully Qualified file name	Type the physical path of the logfile.
   Initial Size	(Optional) Type the initial size of the logfile.
   Maximum Size	(Optional) Type the maximum size of the logfile.
   Growth Size	(Optional) Type the size to grow the logfile with each increase.

8. In the Job Options page, specify any of the following Job options, and click Next.

   Type	Option	Description
   Notification Emails	Email List	(Optional) Click Add Email to add email addresses to the notification list.
   Job Administration	Cleanup Agent Logs	(Optional) Select to automatically remove logs that are generated by BMC Database Automation on the Agent after the Job is complete.

9. If the Change Control page displays, populate the following fields, and click Next.

   Section	Field	Description
   	Bypass Change Control	(Optional) Select to bypass using BMC Remedy ITSM to control the change process. Selecting this option removes the rest of the fields from this page.
   	Change Control Options	Select to determine whether to open a new BMC Remedy ITSM change ticket, or to use an existing BMC Remedy ITSM change ticket to control the change process. Selecting Use Existing Change Ticket displays the fields in the Use Existing Change Ticket section on this page. Selecting Create New Change Ticket displays the fields in the Create New Change Ticket section on this page.
   Use Existing Change Ticket	ITSM Change ID	Specify the BMC Remedy ITSM change ticket number to associate with this change process.
   	ITSM Task ID	Specify the BMC Remedy ITSM task ID number to associate with this change process.
   Create New Change Ticket	Change Type	Assign the type of change for the new BMC Remedy ITSM change ticket.
   	Change Impact	Assign the impact level of this change process for the new BMC Remedy ITSM change ticket.
   	Change Urgency	Assign the urgency level for the new BMC Remedy ITSM change ticket.
   	Change Risk-Level	Assign the risk level of this change process for the new BMC Remedy ITSM change ticket.
   	Change Class	Assign the change class for the new BMC Remedy ITSM change ticket.
   	Change Summary	Type a summary of the change process.

   Note

   The Change Control page appears only when change control is configured for your environment. See Configuring change control.

10. In the Summary page, review the provisioning information.
    To make changes, do the following:
    1. Click Go to to return to the provisioning step that you want to edit.
    2. Make your changes.
    3. Click Save and Review to return to the Summary page.
11. Click Create SQL Server Database.
    After the process completes, a success message similar to the following appears.

12. You can select the magnifying glass icon for detailed information about this operation.

    Note

    Detailed current and historical information about this action can be viewed in the Jobs section of the Management Console. See Monitoring jobs and viewing job history.

13. If this procedure was not successful, see Troubleshooting.