Adding a database to a clustered SQL Server instance

Before you begin

Ensure that the clustered SQL Server instance already exists and is running.

To add a database to a clustered SQL Server instance

1. From the Management Console, navigate to the SQL Server instance on which you want to create a database, and select the cluster.

   Note

   Starting the SQL Server instance starts all services on which the instance depends. However, services that depend on the SQL Server instance are not started. If you have applications that depend on the SQL Server instance, these services must be started outside of BMC Database Automation.

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.

   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.

   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 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.