Skip to main content

High Availability and Data Distribution

1.       What does meant of HA and Load balancing ?
2.       What are the features available in SQL Server for HA and LB ?
a.       HA- Log Shipping, Mirroring, Clustering, Database snapshot, Backup-Restore.
b.      Load Balancing-  Replication and Clustering
3.       What is RAID ? explain in brief .
4.       Explain with example where should we use Which Features of HA and Load Balancing ?
Log Shipping
5.       What is Log shipping ?
6.       Explain the Architecture and Functionality of Log shipping ?
7.       What are Primary, Target and Monitor Server ?
8.       What are the Jobs running in Log shipping ? Backup, Copy, Restore and Alert.
9.       Which jobs are running on which server in log shipping ?
10.   What are the Advantages of Log shipping in respect of other features of HA-LB.
11.   How to recover Database in case of failover of Primary Server goes down in log shipping scenario ?
12.   Does log shipping works in Bulk-Logged recovery ?
13.   Does Log shipping works in different version of SQL Server ?
Mirroring
14.   What is Mirroring?
15.   What the Architecture and Functions of Mirroring Scenario ?
16.   Explain the Architecture of Principal, Mirror and witness Server ?
17.   What are the modes and types of Mirroring ?
18.   What are the Advantage of Mirroring ?
19.   What is Synchronous and Asynchronous Mirroring ?
20.   What are differences between High Safety and High performance Mode ?
21.   How to configure mirroring Session ?
22.   What is Transaction Log Buffer ?
23.   What is Log Hardening ?
24.   What happened when witness goes down ? What to do in .
25.   What happened when mirror server goes down ? What to do in .
26.   What happened when principal goes down ? What to do in .
27.   What are differences between Log shipping and Mirroring ?
28.   How do you monitor Mirroring ?
29.   What is Endpoint ? What are the Endpoint and TCP Port used in Session ?
30.   What is Quorum ?
31.   Does Bulk Recovery support Mirroring ?
32.   Can we do mirroring on different version of SQL Server ?
33.   How to do manual failover in mirroring ?
Replication
34.   What is Replication ?
35.   What are the benefits and Features of Replication ?
36.   How do you plan replication ?
37.   What are the Architecture of Replication ?
a.       Publisher
b.      Distributor
c.       Subscriber
d.      Subscription Mode-Push and Pull
e.      Articles
f.        Replication Type- Transaction, Snapshot, Merged
38.   What is Publisher, Distributor and Subscriber ? Explain.
39.   What are subscription Models in Replication ?
40.   What are differences between Push and Pull Subscription ?
41.   What is Articles ?
42.   What are the Types of Replication in SQL Server ?
43.   What is Snapshot Replication ?
44.   What is Transactional Replication ?
45.   What is Merge Replication ?
46.   How does Snapshot Replication Works ?
47.   How does Transactional Replication Works ?
48.   What are Agents working in Replication ?
49.   Which jobs runs in Transactional Replication ?
50.   Which jobs are running in Snapshot Replication ?
51.   What are Replication Topology ?
52.   How to Add Article in Publisher ?
53.   How to check and manage sync from publisher & subscriber articles ?
54.   Where does changes store in Replication ?
55.   What is Peer-to-peer Replication ?
56.   Where does distributors run in push subscription and pull subscriptions ?
57.   How to monitor replication ?
Clustering
58.   What is clustering
59.   What is Windows cluster ?
60.   What is NLB ?
61.   What is Failover Cluster ?
62.   What is Server Node ?
63.   What is Private storage ?
64.   What is Shared Disk Array ?
65.   What is Quorum Disk ?
66.   What is Heart Beat ?
67.   What is Looks Alive Check ?
68.   What is Failover ?
69.   What is Virtual Server ?
70.   What is MSDTC ?
71.   What is Possible and Preferred owner ?
72.   How many IP address required if you need to install sql on 4 node of cluster ?
73.   Do we need to configure MSDTC in 2008 Clustering . Explain ?
74.   How does the failover happens ?
75.   What checks are performed to ensure that another node is up ?
76.   What is AAG & Always On Group in Denali ?
77.   How to Perform Drain in Cluster ?
78.    

Labels:

Popular posts from this blog

How to encrypt and decrypt Table data in postgres

For encrypting and decrypting , we must use the bytea data type on the column which we implement. Bcoz bytea will use the pgcrypto method by default. However, you will need to create the pgcrypto extension to enable these functions as they are not pre-defined in PostgreSQL/PPAS. Example CREATE EXTENSION pgcrypto; CREATE TABLE userinfo (username varchar(20), password bytea); >>    Inserting the data in an encrypted format INSERT INTO userinfo VALUES(' suman ',encrypt('111222','password','aes')); select * from userinfo ; >>    Retrieving the data as decrypted format SELECT decrypt(password,decode('password','escape'::text),'aes'::text) FROM userinfo; Thanks for reading Plz dont forget to like Facebook Page.. https://www.facebook.com/pages/Sql-DBAcoin/523110684456757
1 comment
Read more

How to recover msdb database from suspect mode

 It was Monday 9 th Jun 47 degr. temperature of Delhi-NCR. Temperature was like boiling me and database. When I reached my office( @ 8.45 am) got an alert from one of Server. “MSDB is in suspected mode” At the same time comes in my mind, this issue will boil me today.. I just tried to cool my self through cold drink then connected server from my local system using windows authentication mode..
5 comments
Read more

History of MySQL from AB Corp to Cloud Database

MySQL was created by a Swedish company, MySQL AB, founded by David Axmark, Allan Larsson and Michael "Monty" Widenius. Original development of MySQL by Widenius and Axmark began in 1994. The first version of MySQL appeared on 23 May 1995. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter,and "SQL", the abbreviation for Structured Query Language. ·          23 May 1995 - First internal release ·          Year 1996 - Version 3 o     Simple CRUD operations o     January 1997 Windows version was released on 8 January 1998 for Windows 95 and NT o     production release 1998, from www.mysql.com ·          Year 2002 - Version 4 o     MyISAM o     unions o     Tracking o     B-trees o     s...
34 comments
Read more