Menu
My new development pc is arriving tomorrow and I am assembling the software suite I will be installing on it.
Sadly SQL server is still a requirement, and I am installing the Sql 2012 Standard, as the Developer Version is a special version of the Sql Server Enterprise, which can be uncompatible in some cases.
So the question is: How do I install SQL Server on a development pc in a whay that leaves minimal footprint on the computer, while still giving a fully usable environment for development?
211
Microsoft SQL Server 2005 (the release version and service packs) and earlier versions of SQL Server are not supported on Windows 10, Windows Server 2016, Windows Server 2012 R2, Windows Server 2012, Windows 8.1, or Windows 8.
Launch the SQL Server Setup program (setup.exe) from SQL Server installation media. After prerequisites and system verification, the Setup program will display the SQL Server Installation Center page. Click Maintenance in the left-hand navigation area, and then click Repair to start the repair operation.
The very minimum is to select Database Engine only during setup. If you use a the command line, select only SQLEngine feature. If you use the GUI setup, select only the Database Engine from the feature selection page. By installing Database Engine feature only you get the sqlservr.exe service,sqlcmd and bcp tools, network and service configuration applets... and not much else.
If you need other features, like SQL Server Management Studio, make sure you select those as well. Ditto for Replication, Fulltext, tools (eg. Profiler) etc etc.
60
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
