Creating multiple test databases in SQL Server 2016

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

Default image
Vignesh A Sathiyanantham
AWS Certified developer with 8 years of extensive experience working for Cloud and Datacenter solutions and leading a small team in a lean startup based on Bangalore, India

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.