Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why does SQL Server use "Binn" directory instead of "Bin"

Tags:

sql-server

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?

like image 710
rwb Avatar asked Aug 20 '12 14:08

rwb


People also ask

What is Binn folder?

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”.

How do I change the root directory in SQL Server?

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 .

How do I change the location of SQL Server installation?

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.


1 Answers

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”.

like image 145
Heinzi Avatar answered Sep 19 '22 18:09

Heinzi