I am lucky to be an admin of a server, but I have no idea how many versions of sql server on this server. When I opened the file Microsoft SQL Server, there are files called 80, 90, 100, 110. And I have only found SQL Server 2012 setup, so what's the relationship between the files names like 80, 90, 100, 110 with sql server versions like 2008, 2012?
Open Microsoft SQL Server Management Studio. Connect to the server wherein the DB you want to rename is located. Go to the location that MDF and LDF files are located and rename them exactly as you specified in first two alter commands. If you changed the folder path, then you need to move them there.
To begin the removal process, navigate to the Control Panel and then select Programs and Features. Right-click Microsoft SQL Server (Version) (Bit) and select Uninstall.
Change the logical file for the SQL Server Database Suppose we want to change the logical filename for the newly created database. We want to rename the logical file name as SQLShack_Demo and SQLShack_log_Demo. To change the logical file name, view the database properties by right click on the database -> properties.
The mapping is (along with links to build lists):
Major Version / Compatibility Level | Version Label | File Version |
---|---|---|
80 | SQL Server 2000 | 8.00.xxxx |
90 | SQL Server 2005 | 9.00.xxxx |
100 | SQL Server 2008 | 10.00.xxxx |
105 | SQL Server 2008 R2 | 10.50.xxxx |
110 | SQL Server 2012 | 11.00.xxxx |
120 | SQL Server 2014 | 12.00.xxxx |
130 | SQL Server 2016 | 13.00.xxxx |
140 | SQL Server 2017 | 14.00.xxxx |
150 | SQL Server 2019 | 15.00.xxxx |
160 | SQL Server 2022 | 16.00.xxxx |
However, just because you have a folder with one of these identifiers, does not mean you have a SQL Server instance of that version installed; some folders are laid down by newer versions for backward compatibility reasons, added by Visual Studio and other tools, or are left behind after an instance has been removed or upgraded.
To see what you actually have installed:
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