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, provision the following fields, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   
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.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   

5. In the Primary Datafiles page, provision the following fields, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   

   Warning

   Note

   Click Add to create another datafile.

6. In the Additional Datafile Groups page, provision the following fields, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   
7. In the Logfiles page, provision the following fields, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   
8. In the Job Options page, specify any of the following Job options, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   

9. If the Change Control page displays, provision the following fields, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   

   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.