Sno.
|
AlwaysOn FCI for HA and DR
|
AlwaysOn AG for HA and DR
|
1
|
Shared Storage solution
|
Non-Shared Storage solution
|
2
|
Instance level HA
|
Database level HA (can be one or more databases)
|
3
|
Logins, SQL Agent jobs, certificates and other SQL Server instance level objects are in-tact after failover
|
Manual adding logins, SQL Agent jobs, certificates and other SQL Server instance level objects to all secondary's
|
4
|
Instance-level protection without data redundancy
|
Each group of secondary AG database(s) are redundant copy of primary
|
5
|
Have Active\Passive nodes. No concept of a secondary database.
|
DR replica can be Active Secondary for backup, read-only workload.
|
6
|
Application connects via virtual server name
|
Application connects via AG listener name
|
7
|
Does not maintain a redundant copy of the data hence does not protect against an I/O subsystem failure
|
Protection against an I/O subsystem failure i.e Automatic Page Repair
|
8
|
No special requirements with respect to database recovery models
|
Database(s) in AG must be in FULL recovery model
|
Labels
- MSSQL DBA Scripts (97)
- MSSQL (70)
- MSSQL Error (51)
- Slides (42)
- ERP (34)
- MSSQL Demo (31)
- Difference between (30)
- MSSQL Security (30)
- Analytics (28)
- MSSQL Architecture (28)
- MSSQL Backup Restore (26)
- MSSQL Internals (25)
- MSSQL Issues (25)
- MSSQL Replication (22)
- Installation (19)
- Windows (19)
- MSSQL Install (17)
- Statistics (17)
- Indexes (15)
- Interview Questions (15)
- Management (14)
- Spark (12)
- MSSQL Tuning (11)
- DBMS (10)
- Python (10)
- HADOOP (9)
- MSSQL T-Log (9)
- Business Process Re-engineering (8)
- MSSQL Protocols (8)
- Marketing (8)
- Ubuntu (8)
- Automation (7)
- Business Intelligence (7)
- Demo (7)
- MSSQL Maintenance (7)
- Analytics Lab (6)
- Big Data (6)
- Dead Lock (6)
- MSSQL Cluster (6)
- MSSQL Configuration (6)
- MSSQL Stats (6)
- MongoDB (6)
- NoSQL (6)
- PDW (6)
- SQL (6)
- Connection (5)
- EXCEL (5)
- Error (5)
- MSSQL Ports (5)
- Machine learning (5)
- Marketing Analytics (4)
- Memory (4)
- Power Shell (4)
- R (4)
- SSRS (4)
- Tableau (4)
- pyspark (4)
- CSM (3)
- HR Analytics (3)
- Hcatalog (3)
- High Availability (3)
- Hive (3)
- MSSQL Locks (3)
- Must Read (3)
- Performance Issues (3)
- Pig (3)
- Azure (2)
- CentOS (2)
- Dumps (2)
- Elastic-search (2)
- Firewall (2)
- Hyper-V (2)
- ITIL (2)
- Kubernetes (2)
- MYSQL (2)
- Robocopy (2)
- SPN (2)
- SSAS (2)
- SSIS (2)
- Sqoop (2)
- Storm (2)
- Online Tutorial (1)
- Organ donation (1)

Difference between AlwaysOn FCI and AlwaysOn AG
Subscribe to:
Post Comments (Atom)
No comments:
Write commentsPlease do not enter spam links