-
Backup of OLAP Database using Powershell
In this article I would like to explain another method to take the backup of OLAP databases via PowerShell. It will help out to take the backup of multiple OLAP databases with a specified retention period. In Tsql, XMLA function is applied however it is a bit puzzling to initiate the similar process for more than…
-
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…