Shulou(Shulou.com)06/01 Report--

1. Installation of two SQL .net3.5 and cluster failover roles

2. Join the domain, create domain user sqlservice and sqladmin accounts, and join the domain admin group and two SQL local administrator groups

3. Production network and heartbeat network settings

4. Configure cluster cluster-set file arbitration and delete disks from cluster management

5. Install SQL 2012 on 2 SQL, stand-alone, on non-C disk.

6. Modify the service SQL Server and SQL Server Agent using sqlservice users to start

7. Enable Always ON in SQL Server configuration Manager

8. Add two SQL hostnames to SQL as login, add demo\ sql01 $to login, and assign sysadmin role

9. Create a DB that needs to be enabled for always on, and other partitions can be placed.

10. Confirm that the DB recovery model is complete, and right-click DB- Properties-options-recovery Model-FULL

Make a full backup of this DB and place it in a shared directory

Use the Always ON wizard to configure Always ON for DB

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.