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?

Continue reading

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

Top 10 SQL Server Backup and Restore Interview Questions

Top 10 SQL Server Backup and Restore Interview Questions

SQL THE ONE

Top 10 SQL Server Backup and Restore Interview Questions

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

1. What are some common reasons why database restores fail?

2. How to rebuild the system databases?

3. What are the new features added for Backup and Restore on SQL Server 2014 / 2016?

4. Is there any performance impact if we enable the backup encryption?

5. Why don’t we just backup SQL Server Database Files (MDF, LDF and NDF) using Windows backup tool instead of SQL Server native backup?

Continue reading

Posted in High Availability, Interview Q&A, SQL Server DBA | Tagged , , , , , , , , , , , | Leave a comment

Top 20 SQL Server Security Interview Questions

Top 20 SQL Server Security Interview Questions

SQL THE ONE

Top 20 SQL Server Security Interview Questions

There are total 79 questions are answered under SQL Server Security category in the book “SQL THE ONE”. In this chapter we can see questions and answers on Password Policy, Server / Database / Application roles, Contained Database, New Security Features, SQL Injection, Audit, Impersonation, Proxy Accounts, TDE, and Password Policy Management. Below are the Top 20 SQL Server Security Interview Questions:

1. If password policy is enforced; can you tell me the new password rules and policies to make sure the password is strong?

2. Have you ever implemented Application Roles in your environment?

3. What are the advantages and disadvantages of a contained database feature?

4. What is the new security features added in SQL Server 2012 / 2014 /2016?

5. What are the most common symbols/operators used for SQL Injection?

Continue reading

Posted in Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , , , | Leave a comment