SQL Server – Testing backups (part III)

Welcome to the final step of your future automatization 🙂 Quick reminder what we have done previously. This one forced me to learn new stuff – writing SQL queries and grabbing the results. It was fun to do 🙂 So the general idea was to create a script that will connect to the SQL server,…

Read More

SQL Server – Testing backups (part II)

Welcome back to a resolution of  Admins nightmare – Primary site is down and backup files are useless. Today we will go through the short procedure of getting the data from Blob storage to a local drive. The script is very similar to the previous one, with few specifics which are well commented 😉 Don’t…

Read More

SQL Server – Testing backups (part I)

Everyone who has ever installed a SQL Server has also set up a backup procedure (hopefully :)) But, besides backing up your valuable data, how many of you are actually testing what has been backed up? Do you have a disaster recovery procedure? If you do – how often do you do it? How much…

Read More

Hyper-V and Powershell to save the day

If you are managing Virtualized infrastructure by using Hyper-V, this small script may come in handy (and save you from getting a headache). Few clients have a procedure to create VM Snapshot before making some big changes to the VM (I know, that’s not a backup solution but I can’t win all the battles). The problem…

Read More

Auto-confirm deleting files in Powershell

Have you ever tried to remove a bulk of files from Powershell with command Get-ChildItem “Path” -Recurse | Remove-Item, but you received message: Get-ChildItem E:\Test -Recurse | Remove-Item The item at Microsoft.PowerShell.Core\FileSystem::E:\Test\001 has children and the Recurse parameter was not specified If you continue, all children will be removed with the item. Are you sure you want…

Read More