-
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 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…