-
March towards SQL Server : Day 19 – SQL DBA Interview Questions Answers – Always ON
After completing successful 18 Day – here comes the most awaiting and demanding series of interview questions and answers on Always On Feature. 1. What is Always on in SQL Server 2012? AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012,…
-
March towards SQL Server : Day 16 – SQL DBA Interview Questions Answers – Database Mirroring – 2
Continuing with my previous post of Interview Questions series on Database Mirroring, this is the second blog on Database Mirroring. 1) What is Database Snapshot? A database snapshot is a view of what the source database looked like at the time at which the snapshot was created. This means that all the objects will…
-
March towards SQL Server : Day 15 – SQL DBA Interview Questions Answers – Database Mirroring – 1
Next topic to High availability Questions Answers series is about Database Mirroring. This is very interesting topic and consists of very wide range of terminologies and scope. I will cover this topic in two blogs so that I can touch base all the possible Questions from Database Mirroring. 1. What is Database Mirroring? Database mirroring was…
-
March towards SQL Server : Day 14 – SQL DBA Interview Questions Answers – Log Shipping
This blog is about one of the High Availability feature supported by Microsoft SQL Server- Log Shipping. What is High Availability in SQL Server? A high availability solution masks the effects of a hardware or software failure and maintains the availability of applications so that the perceived downtime for users is minimized.SQL Server high-availability solutions…
-
March towards SQL Server : Day 13 – SQL DBA Interview Questions Answers – Database Backups and Restore-4
Here I am posting fourth and last series of Backup/Restore interview questions. I am trying to cover most of the known errors and some concepts too. You may take a look at the other posts on Backup/Restore here. Day 10, Day 11 & Day 13 1) What are Partial Backups in SQL Server? Partial backups…
-
March towards SQL Server : Day 12 – SQL DBA Interview Questions Answers – Database Backups and Restore-3
Lets have some more questions on Backup and Restore. You may visit my other backup and restore related blogs here Day 10 and Day 11 1) What is the Backup strategy in your environment? It’s very open ended Question: As per my understanding, normally Organizations follow below standards Prod/QA Environment: For Small size databases (<200…
-
March towards SQL Server : Day 11 – SQL DBA Interview Questions Answers – Database Backups and Restore-2
Continuing my Blog series on the Interview Questions on Database Backup Restores, I am posting another set of 31 questions which will help you to understand the SQL Server Database backups topic in more depth. 1) What are the Best Practices recommendations related to SQL Server Database backups? Backup is an important component of a…
-
March towards SQL Server : Day 10 – SQL DBA Interview Questions Answers – Database Backups and Restore-1
This blog contains series of most commonly asked Interview Questions regarding one of the important DBA tasks- Database Backups and Restore. Since this is very wide topic, I will try to cover all the sub topics in 2-3 blogs. 1) What are database backups? A Database backup is a copy of SQL Server data that can…
-
March towards SQL Server : Day 9 – SQL DBA Interview Questions Answers – All about SQL Server System Databases and Recovery Model
This blog is about the interview Questions on the System databases, Important activities with the system databases and Recovery models. 1) What are system databases? When we install Microsoft SQL Server, five system databases are automatically created for each SQL Server instance. These system databases allow the database engine and administrative applications to properly manage the…
-
March towards SQL Server : Day 8 – SQL DBA Interview Questions Answers – All about SQL Server Tools and Executables
This blog is all about the SQL Server related tools and executables which are used by all level of DBAs for various tasks. 1) What is SSMS? SSMS stands for SQL Server Management Studio. SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.…
-
March towards SQL Server : Day 7 – SQL DBA Interview Questions Answers – All about SQL Server Agent and Its Components
This blog contains Question answers about the most frequently used tool by a Database Administrator i.e. SQL Server Agent. I tried to cover all the questions related to each and every component of SQL Server agent except Database Maintenance plans because this is itself a big topic to discuss about. I will try to combine…
-
March towards SQL Server : Day 6 – SQL DBA Interview Questions Answers – All about SQL Server Services
This blog is all about the SQL Server Services which are required for the functionality of SQL Server components. It also contains Questions answers about the important parameters and SQL Server start process. 1) List out various services which are important for SQL Server and its components functionality? SQL Server Service SQL Server Agent service…