All about Databases
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 be […]
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 […]
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. Database Backup and Restore – 1, Database Backup and Restore – 2 & Database Backup and Restore […]
Lets have some more questions on Backup and Restore. You may visit my other backup and restore related blogs here Database Backup and Restore – 1 and Database Backup and Restore – 2 1) What is the Backup strategy in your environment? It’s very open ended Question: As per my understanding, normally Organizations follow below […]
Continuing my Blog series on the SQL Server DBA 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 […]
This blog contains series of most commonly asked SQL Server DBA 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 […]
System databases are very important part of the Database Management system. It plays a vital role in Database Administration as SQL Server functionality is based on the system database. This blog is about the SQL Server DBA interview Questions on the System databases, Important activities with the system databases and Recovery models. 1) What are system […]
Every DBA uses multiple tools to perform the day to day Database Administration tasks to make his\her life easy. In this blog I am writing 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 […]
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. I will try to combine Database […]
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. SQL Server DBA Interview Questions and Answers 1) List out various services which are important for SQL Server and its components functionality? […]
