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?