Tuesday 27 November 2018

SQL Server files names and versions

When we are opening SQL server file in the program, we are getting files with name 80, 90,100,110,120 etc. Do we know what the means of these files?
  
  

Shared Files for All Instances of SQL Server
Common files used by all instances on a single computer are installed in the folder below the folder
C:\Program Files\Microsoft SQL Server

The following table identifies versions for the paths.
Folder name
SQL server Version
140
SQL Server 2017 (14.x)
130
SQL Server 2016 (13.x)
120
SQL Server 2014
110
SQL Server 2012 (11.x)
105
SQL Server 2008 R2(10.50.X)
100
SQL Server 2008 (10.X)
90
SQL server 2005 (9.X)
80
SQL Server 2000 (8.X)


Hope this will be using full to understand the SQL server folder structure.

No comments:

Post a Comment

If you have any doubt, please let me know.

Popular Posts