Category Archives: SQL on Server Core

Managing Windows Server Core from the command line

Commands for managing a Server core instance form the command line… Disk Space: wmic logicaldisk C: get caption,size,freespace (all values in bytes) PageFile: wmic pagefile list /format:list wmic pagefileset set InitialSize=4096,MaximimSize=8192 (all sizes in MB) Install Windows Features: https://technet.microsoft.com/en-us/library/jj205467(v=wps.630).aspx Change … Continue reading

Posted in SQL on Server Core | Comments Off on Managing Windows Server Core from the command line

Moving from Server Core to Minimal Server Interface

To install Server Graphical Management Tools & Infrastructure on Server Core: Run PowerShell, then run the following command: Install-WindowsFeature Server-Gui-Mgmt-Infra  -Restart A restart is required and this command will restart the computer at the end of the update. If you omit the -Restart, … Continue reading

Posted in SQL on Server Core | Comments Off on Moving from Server Core to Minimal Server Interface

Granting permissions for SQL Server

To operate correctly, SQL Server requires permissions on the file system. In the past, running under local administrator it wasn’t necessary but nowadays we always run the SQL Server services under minimal privileges. This means that SQL needs permissions on … Continue reading

Posted in SQL on Server Core | Comments Off on Granting permissions for SQL Server

Managing SQL Services from command Line

Under Windows Server core, if you can’t control the services remotely, the commands to change the services are as follows: sc config <service_name> start= <mode> auto = automatically started at boot time (automatic) demand = manually start the service (manual) … Continue reading

Posted in SQL on Server Core | Comments Off on Managing SQL Services from command Line

SQL Server on Windows Server Core

Yesterday was day 1 of the SQL PASS conference in Charlotte, North Carolina, USA. I attended a full day session on Always On Availability Groups and here are some findings from that session. As you might already know, from SQL … Continue reading

Posted in SQL on Server Core | Comments Off on SQL Server on Windows Server Core