Using PowerShell to clone production SQL Server databases in non-production

We all know how to restore SQL Server databases from a backup but being the automation fanatic that I am, I wanted a method in PowerShell to quickly build a "clone" instance with all the databases as backed up from production. I wanted to do this with minimal number of parameters possible. The criteria that …

Advertisement

Use PowerShell to work with files at folder level

I can think of so many scenarios where people need to work with files at the folder level. The get-childitem cmdlet is indeed very powerful but it does not work at the folder level without any additional work. Here is what I mean: Let us say that you have a folder structure like this to …