Top 10 SQL Server Log Shipping Interview Questions

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?

6. I have configured log shipping for my database in standby mode as our business required the secondary should be available for reporting users. Now can you tell me what the major challenge that we need to face?

7. What is TUF file in log shipping?

8. How to perform tail log backup on primary server in case of failover?

9. Can I shrink log shipped database log file?

10. Truncate is a non-logged operation right? If I issues TRUNCATE TABLE on primary server does it effects on secondary database? If yes how?

Summary:

These Top 10 SQL Server Log Shipping Interview Questions are the sample questions randomly collected from the book “SQL THE ONE”.

Please share your feedback and comments on below comments section or reach me on sqltheone@gmail.com. We wish you all the best for the next interview.

Here you can find more Details about the book “SQL THE ONE”.

Posted in High Availability, Interview Q&A, SQL Server DBA | Tagged , , , , , , , , , , | 3 Comments
Subscribe
Notify of
guest
3 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
kiran
7 years ago

hi, uday please give the issues and solutions regarding logshipping and replication and mirroring.
thank you ur’s
kiran

trackback

[…] Top 10 SQL Server Log Shipping Interview Questions … […]