If you attended my SharePoint Conference Session on SharePoint 2010 on SQL Server Denali you’re probably ready to get started with some of the features and capabilities we discussed and demonstrated today, particularly AlwaysOn Availability Groups which provide a robust, ready to use solution supporting both local redundancy and remote disaster recovery.

NOTE

SharePoint 2010 is not currently supported on SQL Server Code Name “Denali”.

While SQL Server Denali does not need to be clustered from a SQL Server perspective, the nodes on which SQL Server Denali is installed should be members of the same WSFC if configuring an AlwaysOn scenario.

NOTE

The steps in this post make several assumptions about the SQL Server environment where SQL Server Codename “Denali” will be installed. The steps to install and configure SQL Server Codename “Denali” may differ as a result.

These steps will help you configure AlwaysOn in a SQL Server Code Name “Denali” environment.

Right-click Named Pipes and select Enable from the list of available options.

NOTE

MSSQLSERVER will need to be restarted to commit the changes.

In SQL Server Code Name “Denali” you will need to include the startup option 9532 (TraceFlag 9532) to enable enabling AlwaysOn High Availability Groups. To configure the required startup option on each Windows Server where SQL Server Code Name “Denali” is installed:

The Windows Failover Cluster Name should appear on the AlwaysOn High Availability dialog. MSSQLSERVER will need to be restarted to commit the changes.

Create a Seed or select an existing Database

Create a seed database.

NOTE

At least one database must exist to create a new Availability Group in Step 9 below. This step is not required when installing SharePoint Server 2010 using DBA created databases. For information on installing SharePoint Server 2010 using DBA created databases see Deploy by using DBA-created databases (SharePoint Server 2010).

Prior to adding a database to an Availability Group a FULL backup of the database must exist.

Create a Network Share

Create a Network Share

A network share must exist and must be accessible by all nodes in the AlwaysOn configuration in order to perform initial data synchronization.

Create an Availability Group

Create a new Availability Group

In Object Explorer, connect to the server instance that hosts the primary availability replica, and expand the server tree.

To launch the New Availability Group Wizard, expand the Management node, right-click the Availability Groups node, and click New Availability Group.

On the Specify Availability Group Name page, enter the name of the new availability group in the Availability group name field. This name must be a valid SQL Server identifier that is unique on the WSFC failover cluster and in your domain as a whole.

On the Select Databases page, the User databases meeting high-availability requirements grid lists local user databases that are eligible to become the availability databases for the new availability group. Select one or more of the listed databases to participate as availability databases in the availability group. These local availability databases will initially be the primary databases of the new availability group.

On the Replicas tab, the Selected instances grid initially displays only the instance of SQL Server to which you are connected. This server instance will host the initial primary replica. To specify the server instance that will host the secondary replica, click Add. Note that in CTP3, you must add a single secondary replica now.

Select the desired configuration for each instance in the Selected instances grid.

The following restrictions exist for using the New Availability Group wizard to start data synchronization:

If the file paths on the secondary replica location from the file paths on the primary location, click Close to exit the New Availability Group wizard now and then start data synchronization manually.

If any secondary database already exists, using the New Availability Group wizard to start data synchronization requires manually deleting these secondary databases before you click Start Data Synchronization. If want to use your existing secondary databases, click Close to exit the New Availability Group wizard now and then start data synchronization manually.

In the Client Access Point dialog specify a name for the network name, and then click Next.

In the Confirmation dialog box, click Next.

In the Summary dialog box, click Finish.

In the Summary of AG1 navigation pane, right-click AG1 under Other Resources, and then click Take this resource offline.

In the Please confirm action dialog box, click Take AG1 offline.

Right-click AG1 and then click Properties.

In the AG1 Properties dialog box, click the Dependencies tab.

Click Insert, and then click the drop-down box under the Resource column.

In the drop-down list, select the network name, and then click OK.

In the Summary of AG1 navigation pane, right-click AG1, and then click Bring this resource online.

Configure SharePoint Server 2010

Start the SharePoint 2010 Products Configuration Wizard.

Create a new server farm specifying the name of the Client Access Point as the name of the database sever.

Add Databases to the Availability Group

In Object Explorer, connect to the server instance that hosts the primary replica of the availability group, and expand the server tree.

Expand the Management node, the AlwaysOn High Availability node, and the Availability Groups node.

Right-click the availability group to which you are adding a database, and select the Add Database command. This command launches the Add Database to Availability Group Wizard.

On the Select Databases page, select one or more databases.

On the Select Initial Data Synchronization page, choose how you want your new secondary databases to be created and joined to the availability group. Choose one of the following options:

· Full

In the Specify a shared network location accessible by all replicas: field, specify a backup share to which all of the server instance that host replicas have read-write access.

On the Connect to Existing Secondary Replicas page, Information_still_to_come.

The Validation page verifies whether the values you specified in this Wizard meet the requirements of the New Availability Group Wizard. If the validation changes, you can click Previous to return to an earlier wizard page to change one or more values. The click Next to return to the Validation page, and click Re-run Validation.

On the Summary page, review your choices for the new availability group. To make a change, click Previous to return to the relevant page. After making the change, click Next to return to the Summary page.

If you are satisfied with your selections, optionally click Script to create a script of the steps the wizard will execute. Then, to create and configure the new availability group, click Finish.

The Progress page displays the progress of the steps for creating the availability group (configuring endpoints, creating the availability group, and joining the secondary replica to the group).

When these steps complete, the Results page displays the result of each step. If all these steps succeed, the new availability group is completely configured. If any of the steps result in an error, you might need to manually complete the configuration. For information about the cause of a given error, click the associated “Error” link in the Result column.

When the wizard completes, click Close to exit.

Once all databases have been added to one or more Availability Groups the configuration is complete.

NOTE

SharePoint 2010 is not currently supported on SQL Server Code Name “Denali”.