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 (79)
- MSSQL Error (51)
- Slides (49)
- Analytics (41)
- Interview Questions (39)
- SQL (39)
- Data Science (35)
- ERP (34)
- Difference between (31)
- MSSQL Architecture (28)
- HADOOP (27)
- GCP (25)
- MSSQL Internals (25)
- Statistics (24)
- MSSQL Replication (22)
- Installation (21)
- Management (20)
- AWS (19)
- Windows (19)
- DBMS (17)
- Big Data (16)
- Finance (15)
- Indexes (15)
- NoSQL (15)
- Python (15)
- Spark (15)
- Demo (14)
- Machine learning (13)
- Analytics Lab (12)
- R (12)
- Hive (10)
- Marketing (10)
- MongoDB (10)
- Azure (9)
- GCP-LAB (9)
- MSSQL T-Log (9)
- pyspark (9)
- Business Intelligence (8)
- Business Process Re-engineering (8)
- MSSQL Protocols (8)
- Neo4J (8)
- Ubuntu (8)
- Accounting (7)
- Agile (7)
- Automation (7)
- EVS (7)
- Error (7)
- MSSQL Maintenance (7)
- MSSQL Cluster (6)
- MSSQL Stats (6)
- Macroeconomics (6)
- PDW (6)
- Pig (6)
- EXCEL (5)
- Marketing Analytics (5)
- Tableau (5)
- visualization (5)
- Kubernetes (4)
- Memory (4)
- Power Shell (4)
- SSRS (4)
- CSM (3)
- HR Analytics (3)
- Hcatalog (3)
- High Availability (3)
- Must Read (3)
- Performance Issues (3)
- Dumps (2)
- Elastic-search (2)
- Firewall (2)
- Hyper-V (2)
- ITIL (2)
- MYSQL (2)
- Power BI (2)
- Robocopy (2)
- SPN (2)
- SSAS (2)
- SSIS (2)
- Sqoop (2)
- Storm (2)
- CAM (1)
- Online Tutorial (1)
- Organ donation (1)
- PostgreSQL (1)
Difference between AlwaysOn FCI and AlwaysOn AG
Subscribe to:
Post Comments (Atom)
No comments:
Write commentsPlease do not enter spam links