Home > Sample chapters > Programming > SQL Server

Administering Microsoft SQL Server 2012 Databases: Clustering and AlwaysOn

Suggested Practices

To help you successfully master the exam objectives presented in this chapter, complete the following tasks.

Implement a SQL Server Clustered Instance

Prior to completing each task in the following practices, list the steps you would take to accomplish the task. After completing the task, assess how accurately you predicted the necessary steps.

  • Practice 1 Create a new database on the failover clustering instance you created during the exercises at the end of Lesson 1.

  • Practice 2 Shut down server SQL-C. Verify that the database you created on the cluster is still available on server SQL-D.

Implement AlwaysOn

Prior to completing each task in the following practices, list the steps you would take to accomplish the task. After completing the task, assess how accurately you predicted the necessary steps.

  • Practice 1 Create a new database and add it to availability group Alpha.

  • Practice 2 Delete the existing listener and create a new listener for availability group Alpha by using Transact-SQL.