Manage High Availability and Disaster Recovery

Question 1

When can you use the New-Volume cmdlet?

Answer 1

This is used with Storage Spaces Direct (S2D) to create Cluster Shared Volumes (CSV)

Question 2

What is Storage Spaces Direct?

Answer 2

It allows you to group three or more drives together in a storage pool and then use capacity from that pool to create storage spaces. Similar to RAID

Question 3

What are two ways that you can use to create Cluster Shared Volumes that are not using Storage Spaces Direct?

Answer 3

Using the Add-ClusterSharedVolume PS cmdlet and using Failover Cluster Manager

Question 4

How many listeners can be created for an AG using SQL Server? How would you configure more if needed?

Answer 4

One listener can be configured using SQL Server. Additional listeners would need to be configured using PowerShell or the Failover Cluster Management Console

Question 5

What are the steps to failover a database using Log Shipping?

Answer 5

1. Copy any uncopied backup files
2. Apply unapplied transaction logs to the secondary server
3. Perform a tail log backup on the primary server WITH NORECOVERY
4. Apply the tail log backup to the secondary server
5. Make the database in the secondary server available

Question 6

How would you specify that a connection is ReadOnly in the application connection string?

Answer 6

by adding “ApplicationIntent=ReadOnly” to the connection string

Question 7

Which servers would you add to a Read-Only routing list?

Answer 7

Only those that can assume the primary role

Question 8

Which versions of SQL Server allow you to move the TempDB to local storage, as opposed to shared storage, when using WSFC?

Answer 8

SQL Server 2012. Previous versions required you to place it on shared storage

Question 9

Which servers contain the Backup, Copy, Restore, Alert jobs for log shipping?

Answer 9

Primary - Backup
Secondary - Copy and Restore
Monitor - Alert

Question 10

When a Cluster Shared Volume is created, which folder is it created under?

Answer 10

C:\ClusterStorage\

Question 11

What are the steps to configure Log Shipping using T-SQL?

Answer 11

1. Restore full backup of primary on secondary
2. On primary, run sp_add_log_shipping_primary_database to add primary database
3. On primary, run sp_add_jobschedule to add a schedule for backup job
4. on monitor, run sp_add_log_shipping_alert_job to add alert job
5. on primary, enable backup job
6. on secondary, run sp_add_log_shipping_secondary_primary to supply details of primary server and database
7. on secondary, run sp_add_jobschedule to schedule copy and restore jobs
8. on secondary, run sp_add_log_shipping_secondary_database to add secondary database
9. on primary, run sp_add_log_shipping_primary_secondary add info about secondary to primary
10. on secondary, enable copy and restore jobs