Tag: Powershell

Retrieving Disk Number and SCSI ID for volumes using the Windows Powershell storage module

March 16, 2014

I was recently looking at obtaining volume information to include the volume name, capacity, free space, disk number and SCSI ID and to include information for both volumes that contained a drive letter or a folder path. For instances running Windows 8 or Windows Server 2012 I was able to do this using a combination … More Retrieving Disk Number and SCSI ID for volumes using the Windows Powershell storage module

Perform Analysis Services database backups using Powershell

March 1, 2014

I was recently looking into performing SQL Server Analysis Services database backups using Powershell within an automated task, with the following requirements:  Perform a backup of all databases for running instances of Analysis Services. If the target location does not exist, create the directory. Firstly we need to load the Microsoft SQL Server Analysis Services … More Perform Analysis Services database backups using Powershell

Powershell script to delete SQL server databases matching a filter

February 1, 2014

I previously shared a SQL server script to bulk delete all SQL server databases which matched a search filter (http://tinyurl.com/oucvxfs), I have recently written a powershell script to perform the same process and to remove the database backup history. Firstly, we will need to specify the parameters required to run the script. Param ([Parameter(Mandatory=$true)][string] $ServerInstance, … More Powershell script to delete SQL server databases matching a filter