-
Building Microsoft SQL Server AlwaysOn Availability Groups – Part 5 – Make another DB Highly-Available – Add it to Availability Databases
When you create a new DB or for example when you install application that will create a new DB then you need to add it to the Availability Databases. Add new database to Availability Databases Change the Recovery Model of the new DB to Full. Do a Full backup of the database. \\contmng0\Replicas\contdb1c0\AG\agscvmm0\VirtualManagerDB.bak Add Database Wizard […]
-
Building Microsoft SQL Server AlwaysOn Availability Groups – Part 3 – Installation
The Failover Cluster was created so now we can continue with installation of the Microsoft SQL Server. Create domain accounts for each service Best practice is to have separate account for each service. PowerShell # Only for TESTING – Not secure because all accounts will have same password. # Copyright (c) Rudolf Vesely $users = […]
-
Building Microsoft SQL Server AlwaysOn Availability Groups – Part 2 – Create cluster and configure OS
Storage We do not need any clustered disk for this type of SQL cluster that we will create but unless you do not want to store all database data and logs on the C volume (not recommended in the production environment) you need enough local disks. In our case we do not need too many […]
-
Building Microsoft SQL Server AlwaysOn Availability Groups – Part 1 – Design
It is not always easy to divide Low-level Design and High-Level Design. How to differentiate between high-level and low-level design depends on the entity that we refer to. When we need to design our cloud then high-level decision could be choice of the technology that makes our SQL Servers highly-available. But when we talk about our […]