To do some testing of the on going release of Nimesa which do the application aware ( AppAware ) Backup of Microsoft SQL Server Cluster on SQL 2016 i created a small powershell scripts which create ( actually restores ) the databases from Adventure Works backup file
Change the total and volume drive letter in the below code and run it.
If you want to have Data files (.mdf ) and Log Files (.ldf) in the same volume, set the volume1 and volume2 with same value
If you want to create data and log files on different volume, set different volume for both variables
$ volume1 is for Data file
$ volume2 is for Log file
6+ years of experience in building Data Protection, Copy Data Management and Storage management applications, automation software and plugins for private datacenter and public clouds
This is my personal weblog, opinions expressed here represent my own and not those of my employer.
All content provided on this blog is for informational purposes only and i will not be liable for any errors, losses, or damages from the display or use of this information.