Just out of pure curiosity, why does SQL Server create a Binn folder
C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn
and not use a Bin folder as is more common? There must be some reason, surely?
Back in the 16-bit days, all binary files were stored under the Bin folder. However, as things moved to 32-bit and Windows NT came to the market, this new folder, Binn, was created to accommodate that. The extra n was taken from NT, which stands for “New Technology”.
The default directory for storing database files of MS SQL is changed in SQL Management Studio > Database Settings > Database default locations to D:\MSSQL\DATA .
Press Win+Q key to open search on your computer and type in cmd, Cick on Run as administrator on the right hand side pane. Use below command to install it to a different folder, In my case I am installing it on D:\test.
Haidong Ji, who authored a few books on SQL Server, claims that this is a historic leftover from the 16-to-32-bit migration:
By the way, do you know why the folder is called Binn? Why two “n”s? There is a bit of history there. Back in the 16-bit days, all binary files were stored under the Bin folder. However, as things moved to 32-bit and Windows NT came to the market, this new folder, Binn, was created to accommodate that. The extra n was taken from NT, which stands for “New Technology”.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With