Top 10 SQL Server Replication Interview Questions

Posted on December 12, 2016 by uday arumilli

Top 10 SQL Server Replication Interview Questions

SQL THE ONE

Top 10 SQL Server Replication Interview Questions

There are total 67 questions are answered under SQL Server Replication category in the book “SQL THE ONE”. In this chapter we can see questions and answers on SQL Server Replication and scenarios. Below are the Top 10 SQL Server Replication Interview Questions:

1. How to monitor latency in replication?

2. Your customer given a business requirement and asked you to configure the replication topology. How do you suggest the correct replication topology?

3. Have you ever configured both log shipping / Database Mirroring and replication on same database? If yes can you tell me the things that we need to consider?

4. Which is the best way to monitor replication? Have you ever implemented automation in replication monitoring?

5. Scenario: Transnational replication configured on a database. A transaction failed on Publication. Does the failed transaction replicated to subscriber?

Continue reading →

Posted in High Availability, Interview Q&A, SQL Server DBA | Tagged , , , , , , , , , , , | 3 Comments

Top 10 SQL Server Database Mirroring Interview Questions

Posted on December 12, 2016 by uday arumilli

Top 10 SQL Server Database Mirroring Interview Questions

SQL THE ONE

Top 10 SQL Server Database Mirroring Interview Questions

There are total 43 questions are answered under SQL Server Database Mirroring category in the book “SQL THE ONE”. In this chapter we can see questions and answers on Database Mirroring and scenarios. Below are the Top 10 SQL Server Database Mirroring Interview Questions:

1. What are the added improvements for database mirroring in SQL Server 2016?

2. What is transaction safety in database mirroring?

3. In database mirroring what are the events happens when an automatic failover occurred?

4. In your production environment mirroring is configured for one of the premium database and you are asked to cross check the configuration. Can you elaborate what are all the options you would check for?

5. Can we be able to automate the Database Mirroring monitor process? If yes can you explain in simple steps?

Continue reading →

Posted in High Availability, Interview Q&A, SQL Server DBA | Tagged , , , , , , , , , , , | 1 Comment

Top 10 SQL Server Log Shipping Interview Questions

Posted on December 12, 2016 by uday arumilli

Top 10 SQL Server Log Shipping Interview Questions

SQL THE ONE

Top 10 SQL Server Log Shipping Interview Questions

There are total 34 questions are answered under SQL Server Log Shipping category in the book “SQL THE ONE”. In this chapter we can see questions and answers on Log Shipping and scenarios. Below are the Top 10 SQL Server Log Shipping Interview Questions:

1. Can you be able to technically explain the log shipping process?

2. Have you ever observed the location of log shipping related SQL Agent jobs?

3. From your experience what are the most common reasons that causes log shipping failures?

4. What is WRK file in log shipping?

5. I have installed SQL Server 2012 Express edition. Is it possible to configure log shipping?

Continue reading →

Posted in High Availability, Interview Q&A, SQL Server DBA | Tagged , , , , , , , , , , | 3 Comments