Be aware however, that using allocation unit sizes greater than 4 KB results in the inability to use NTFS compression on the volume. When formatting the partition that will be used for SQL Server data files, it is recommended that you use a 64-KB allocation unit size for data, logs, and tempdb. STEP 3 – CONFIGURING WINDOWS SERVER 2016 (for our SQL Server 2017 Lab) DISKS CONFIGURATIONġ- You will have to repeat it for every single Disk here (Except C:\ OBVIOUSLY!!)Ģ- Right click over a Disk and then Formatģ- Specify exactly like below, including Name and Allocation Unit Size The final Result will be like the image below.ġ3- When the installation ends you will be asked to define the Administrator Account Password. (ATTENTION: This will be the only drive formatted at this part)ġ0- For the others, just create a New Partition WITHOUT FORMAT after (we will do this Later)!ġ1- Click on Drive 0 Partition 2 and then Next.
iso that you’ve downloaded beforeġ3- Network TAB > Adapter 2 as a Host-only Adapter:ġ- Language to Install is ALWAYS ENGLISH! Time and currency format should be defined on your Country and Keyboard obviously as your keyboard layout.ģ- Select Standard Evaluation WITH DESKTOP EXPERIENCE (GUI)ĥ- Click on “Custom: Install Windows only (advanced)”ħ- Click on Apply with the maximum value defined by default.ĩ – Select Drive 0 Partition 2 and then FORMAT. THEN Click on Create.Ĥ- After the basic creation, click on Setings then General>Advanced and select Bidirectional for both optionsĦ- Storage > Controller: SATA > Add Disk Symbolħ- Create the data Disk with the following specifications:Ĩ- On Hard Disk Selector click on the Create Symbol to add the other disks:ĩ- At the end the Disks must be like this and you will have to select one by one on this order:ġ0- In the end you will see the Storage tab exactly like this:ġ1- Click on the CD Drive and on the CD symbol at the right:ġ2- Choose a Disk File > and the Windows 2016. Name, Version and Total RAM (Memory)ģ- Define the Virtual Disk Directory and Name, File Size (at least 70GB), HD File Type (VDI) and Dynamically allocated. 1- Machine>New…Ģ- Specify Name, Version (Windows 2016) and Total RAM (ideally 4GB)2. STEP 1 – CREATING THE VIRTUAL MACHINEġ- Click on Machine > New. So after you’ve installed Virtual Box and downloaded all the necessaries ISOs (Windows Server 2016 and SQL Server 2019), we will create our first VM. You may want to check the Part 1 of this series before you proceed.
This is the part 2 of a 3 posts series on how to create your first SQL Server 2019 Lab correctly
0 kommentar(er)
