All Game List

As we know SQL Clustering is not Supported. But you can still use it but Microsoft will not support it.

In this Blog we will see how to create SQL Mirroring 

In this i will be using as i did in my Lab I have Configured two sql server in my Enterprise pool Sql01 and Sql02.

And I will be using Witness server has my Domain controller For just the Lab purpose. In my DC Sql server 

First we will be creating SQL Mirror File Share in my Domain Controller 

Create a Folder SQLMirrorShare under C drive 

1) Right Click the newly created Folder SQLMirrorShare and select Properties

2) Click the Sharing tab. Then Click Advanced Sharing Button.

3) Check the "Share this folder" Checkbox

4) Click the Permissions button.

5) In the permissions for SQLMirrorShare dialog box, Click Everyone group and the Remove it.

6)Click the Add button.click the object types button. In the object types dialog box select service accounts checkbox. Leave the other checkboxes checked and clieck ok

7).  In the Enter the object names to select textbox, type in Administrators;SQLSvc and click Check