File Action Media Clipboard View Help
SeCCGCO 1 BD 'S
File fit View Project Debug Tools Window Help
+ Gd Bl Newey 4 bid S| 4 a) 9-O - -lt| >
O Dashboard: NODE!\SQL2014. x
Connect 37 32 @ F215 = ss
NODEN'SQL2014 (SQL Server 1202000 | (jpg Availability groups on
Databases
@ Ga Security Availability group:
@ Gd Server Objects Availability Group Name —_Primaryiinstance —_—FailoverMode iss
# Ga Replication
Last updated: 12/26/2014 9:28:37 PM
Auto refresh:on Ht
& Ga Integratio
(B SOL Serve File Action Media
@e0000
File Edit View
= [G NObENsat2014 |
3 Gi Databeses
Clipboard View Help
UD is 5%
=
rel Specify Availability Group Name
Introduction
Specify an availability group name.
Select Databases Availability group name:
Specify Replicas I
Select Data Synchronization
Validation
Summary
Results File Action Media
sa
Server Objects
Replication
Clipboard View Help
U Dis D\%
Specify Replicas
Select Data Synchronization
Validation
Summary
Results
Select user databases for the availability group.
User databases on this instance of SQL Server:
Name Size ‘Status
Meets prerequisites File Action Media
$0000
Vi
# Gi Detaboses
# Gy Security
& Gil Server Objects
# Gi Replication
& (a Integration
£B SQL Server Agi
Clipboard View Help
U Dis 9%
B Specify Replicas
Introduction
Specify Neme
Select Databases
Select Data Synchronization
Validation
Summary
Results
Specify an instance of SQL Server to host a secondary replica.
| Replicas | Endpoints | Backup Preferences | Listener |
Availability Replicas:
‘ritig) Automatic Synchronous
Server instance ie Failover(Up to Commit (Upto Readable Secot
2 2
Qo Qa No
k
|< [eT]
Add Replica... || Add Azure Replica...
‘Summary for the replica hosted by NODE1\SQL2014
Replica mode: Asynchronous commit
‘Ths repica wil use asynchronous-commt avadabity mode and support only forced falover (wth
possible data oss)
Readable secondary: No
| Inthe secondary roe, ths avalabaty repica wil not alow any connections File Action Media
& Gia Integration Sex
BB SOL Server Agi
Clipboard View Help
> | iis
Select Data Synchronization
Validation
Summary
Results
Specify an instance of SQL Server to host a secondary replica.
Replicas | Endpoints | Backup Preferences | Listener
Availability Replicas:
‘itis Automatic Synchronous
| | Server instance Roe Failover(Upto Commit (Upto Readable Secot
2 3)
voor ry | CREA
z
‘Add Replica... || Add Azure
‘Summary for the replica hosted by NODET\S@L2014
Replica mode: Synchronous commt
‘This repica wil use synchronous commit avallabaty mode and support only manual falover.
Readable secondary: No
Inthe secondary role. this availablity repica wil not alow any connections, File Action Media
© [G NODENsaL2014 (
3 Gy Databases
# Gi Security
Ld Server Objects
# Ga Replication
(a AlwaysOn Hig)
B Avaitabit
# GB Management
4 Gi Integration Ser
GB SOL Server Ag
Clipboard View Help
UD \is 5%
5 New Availability Group =| 5] x
B Specify Replicas
Introduction
@ Help
Specify Name
Re cece Microsoft SQL Server 2014
Select Data Synchronizatiq
Validation
L
NODEN\SQL2016
Summary '$012014\S012014
Cancel File Action Media Clipboard View Help
SCOCCO IP BOS
=
i Validation
@ He)
‘Specify Name Results of availability group validation.
Select Databases 4 =
Specify Rephicas © checking whether the endpoint is encrypted using # compatible algorithm [success
Dae i | Checking shared network location Success
|| checking frre ek space onthe server instance that hots secondry epics NODEASOLZ014DR_ | Success
veka | =
‘Summary | Success
Results © Checking for the existence of the database files on the server instance that hosts secondary replica NODEA\SQL20140R Success
\@ Checking the listener configuration Success
(© Checking the availability mode compatibility between the primary and secondary replicas [Success
‘Checking for compatbility of the database fe locations on the server instance that hosts secondary
replica NODE2\SQ.20140R.. Vaidated successfuly. R
aire] File Action Media
e000
Results
‘Verify the choices made in this wizard.
Click Finish to perform the following actions:
|= Availability Group: SalesDBs
Primary replice: NODEN\SQL2014
Availability Group Listener: ProdSQL2014
‘Automated backup preference: Secondary Only
= Databases
GeneralLedger (4.0 MB)
Sales (40 MB)
Initial data synchronization: Full
Backup location: \\techbrothersde\AGshare
= Replicas,
& Server instance name: NODET\SQL2014
Role: Primary
Replica mode: Synchronous commit
Readable secondary: No
= Endpoint: Hadr_endpoint
URL: TCP://Node1 Techbrothers.locak5022
Encrypted: Yes
Service account: TECHBROTHERS\clusteradmin
‘Automated backup priority: 50
& Server instance name: NODEZ\SQL20140R
Role Secondary
Replica mode: Synchronous commit
Readable secondary: No
& Endpoint: Hadr_endpoint
N01. 720. //Rtncda? Tachhenthare tneah8A0?
< Previous File Action Media Clipboard View Help
SCOOP BOR
=
ay ve
Introduction
Select Data Synchronization © More details
Activate Windows
Go to System in Control Panel to
activate Windows.
| [[itancal ‘Starting the ‘AlwaysOn_health’ XEvent session on NODET\SQL2014',
‘Starting the ‘AlwaysOn_health’ XEvent session on NODEZ\SQL20140R’.
HER [2 cresting avaisbity group SstesD8s
Waiting for availability group ‘SatesDBs' to come online.
Create Availabilty Group Listener ProdSQl2014.
Joining secondary replicas to availability group ‘SalesDBs'.
\Velidating WSFC quorum vete configuration.
Creating » full backup for ‘Generalledger’.
Restoring 'GeneralLedger on 'NODE2\SQL20140.
Backing up log for ‘GeneralLedger.
Restoring ‘Generalledger log on ‘NODEZ\SQL20140R'.
Joining GeneralLedger’ to availabilty group SalesDBs' on NODEZ\SQL20140R'.
Creating a full backup for ‘Sales’,
Restoring ‘Sales’ on ‘NODE2\SQL20140R'.
Backing up log for ‘Seles.
Restoring ‘Sales’ log on "NODEZ\SQL20140R.
Joining ‘Sales to availabilty group ‘SalesDBs' on NODE2\SQL20140R.
FRCPEREEEECEER PEER File Action Media Clipboard View Help
SGGO@O0 I D>\bo*
File Edit View Project Debug Tools Window Help
PGMs "id Bb) NewQuey Ly wt | &
Object Explorer vax
Connect 32 = FS
& [ NODEN\SQL2014 (SQL Server 12.0.2000 - TECHBROTHERS\c!
(a Databases
# Ga Security
# (Bd Server Objects
& (Ga Replication
= if SolesDBs
# (Gy Availability Replicas
(a Availabilty Databases
(iy Availability Group Listeners
# (yj Management
3 Ll Integration Services Catalogs
SQL Server Agent (Agent XPs dizabled) File Action Media Clipboard View Help
SeGCeGO I Db *
File Edit View Project Debug Tools Window Help
Pale 3° Gj dd B| QD NewQuey Uy each | #
JObyect Explorer vax
Connect 37328 F ab
© [i NODEN\SQL2014 (SQL Server 12.0.2000 - TECHBROTHERS\
® (i Databases
Ga Security
# (i Server Objects
Ga Replication
= Gi AlwaysOn High Availability
= Gi Availability Groups
= SalesDBs (Primary)
= Gk Availability Replicas
i NODENSQL2014 (Primary)
© Ga Av
EB GeneralLedger
(B Sates
© (i Availability Group Listeners
G Proasoygors
# (iy Management
& (Gd Integration Services Catalogs
BB SOL Server Agent (Agent XPs disabled) File Action Media Clipboard View Help
SGGOGO I D>\bD*
File Edit View Project Debug Tools Window Help
Bale J 9 td P| NewQuey Ly cht Ga] & “a
Object Explorer vax
Connect= 37 mF FS
& [ NODEN\SQL2014 (SQL Server 12.0.2000 - TECHBROTHERS\c!
3 (By Databases
# Ga Security
# (i Server Objects
3 Ga Replication
3 [a AlwaysOn High Availability
# Gj Management
3 [Integration Services Catalogs
SQL Server Agent (Agent XPs disabled)
26
= Ge Databases
# (iy System Databases
3 (Gj Database Snapshots
# (J GeneraiLedger (Synchronized)
& [y Sales (Synchronized)
o ca Secul
# Gia Server Objects
& [i Replication
# [ Always0n High Availabilty
# (i Management
Gi Integration Services Catal
BB SOL Server Agent (Agent XPs disabled) File Action Media Clipboard View Help
SCCGO ID BOK
File Action View Help
#9)| aie) 8
1 Failover Cluster Manager
4 & TBCluster.Techbrothers.loc’
eke)
» 7G sleeps
‘Status:
Priority:
‘Owner Node:
IP Addresses:
Running
Medium
Nedet
Gent Access Name: ProdSQL2014
182.168.1.42
Summary [Resources|
oS
BOxXOSG&EHe HOS
ladles
Configure Role...
Virtual Machines... ’
Create Empty Role
View ’
Refresh
Help
Start Role
Stop Role
Move ’
Change Startup Priority
Information Details
Show Critical Events
Add Storage
Add Resource ’
More Actions ,
Remove
Properties
Help