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.    

Popular posts from this blog

mongoDB error : aborting after fassert() failure

What to do when facing errors on mongoDB “aborting after fassert() failure”

I like errors, in mongoDB this is the first error I faced and luckily many times. This error i faced during restoring name-space on local and restarting db system. I am still searching the exact root cause of this issue but i am able to resolve the current problem through below steps.

Remove all relevant namespace files from data-file route path..Now repair mongo instance using mongod process.mongod --repair ////////// execute command from bin folder path Then start server using mongd process, if started server successfully then ..mongod  ////////// execute command from bin folder path Restore last backups as normal process.Now check database by connecting mongo shell. Thanks for reading, 
Please comment your experience if you faced and also share knowledge if you have better steps to resolve...


https://www.facebook.com/pages/Sql-DBAcoin/523110684456757

SQL71562: external references are not supported when creating a package from this platform

Last week I got this error from one of developer who was trying to deploy his project from Testing server to SQL Azure QA server. He was using “Deploy Database to SQL Azure” option from SSMS Tool-Task option.

After connecting to SQL Azure portal when operation started to deployment below errors occurs.

Validation of the schema model for data package failed. Error SQL71562: Error validating element xx.xxx.xx:function .dbo.xxx has an unresolved refrence to object xx.dbo.xxxx external refrences are not supported when creating a package from this platform.



Reason: The reason of the this error was; some functions of project was dependent on master database and only single database was being deploy to SQL Azure. DACFx must block Export when object definitions (views, procedures, etc.) contain external references, as Azure SQL Database does not allow cross-database external references So, this error was coming.

Solution : I suggested him to create those function to locally on local database what…

How to recover msdb database from suspect mode

It was Monday 9th 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..