Creating a database on an instance of SQL Server

This topic describes how to create a database on an SQL Server instance.

Before you begin

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.

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.

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

   Warning

   Note

   Click Add to create another datafile.

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

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

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

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

   Warning

   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.

    Warning

    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.