First step to create any structure starts by creating a safe sandbox area.
There are several ways, some of them are just to create dummy databases in a development machine and do the tests there what it is Ok in most of the cases.
Anyway, for the safest testing environment, we recommend to install a Virtual Machine, for example by using Oracle VM Virtual Box.
The environment where we will run most of the tests is a Virtual Machine with Windows Server 2016 Datacenter Evaluation with SQL Server 2016 and Microsoft SQL Server Enterprise Manager 17.9.1.
Here is where start the first trick, if you haven’t allocated initially enough disk to the virtual machine, you can enlarge it by following two steps (obviously the VM needs to be closed):
- First Step is to run the MS-Dos command to enlarge the disk to 35 Gb
“C:\Program Files\Oracle\VirtualBox\VBoxManage.exe” modifyhd “C:\Users\LEN\VirtualBox VMs\Windows Server-2018-11\Windows Server-2018-11.vdi” –resize 35000
- Second step, when opening again the Virtual Machine, you need to use the Disk Admin to assign the disk to the OS, choose the option by default to assign all available space.
And… that’s all, we have now enough space for our tests.