TempDB creation

Aug 14, 2015 at 10:41 PM
I logged an issue about the tempdb creation portion of the scripts. I found that is was missing a CASE ELSE in order for it create addition tempdb files as per best practice.

My question here is why does it create a final tempdb file called tempdev_spill after all the rest of the files have been created? I can't think of any reason for this to happen.

For reference this is on line 2464 in the file FineBuild5ConfigureSQL.vbs

Thanks
Coordinator
Sep 1, 2015 at 2:16 PM
The Case Else is indeed missing - apologies. The reason for tempdev_spill is covered in the response to Issue 10973, and the good news is that it is not used in the next version of FineBuild that will be released.