Today I ran into a bit of a surprise trying to start a SQL server up from a reboot. The server was working before the reboot so I had a bad feeling that this issue might be difficult. The first thing I did is check the SQL server log to see what happened.2014-08-23 02:09:44.63 Server Microsoft SQL Server 2012 (SP1) – 11.0.3128.0 (X64) Dec 28 2012 20:23:12 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.2 (Build 9200: ) (Hypervisor)2014-08-23 02:09:44.63 Server (c) Microsoft Corporation.2014-08-23 02:09:44.63 Server All rights reserved.2014-08-23 02:09:44.63 Server Server process ID is 3704.2014-08-23 02:09:44.63 Server System Manufacturer: ‘VMware, Inc.’, System Model: ‘VMware Virtual Platform’.2014-08-23 02:09:44.63 Server Authentication mode is WINDOWS-ONLY.2014-08-23 02:09:44.63 Server Logging SQL Server messages in file ‘E:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLLogERRORLOG’.2014-08-23 02:09:44.63 Server The service account is ‘DOMAINdatabaseservice’. This is an informational message; no user action is required.2014-08-23 02:09:44.63 Server Registry startup parameters: -d E:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATAmaster.mdf -e E:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLLogERRORLOG -l E:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATAmastlog.ldf -T 8295 -T 41992014-08-23 02:09:44.63 Server Command Line Startup Parameters: -s “MSSQLSERVER”2014-08-23 02:09:44.77 Server SQL Server detected 1 sockets with 2 cores per socket and 2 logical processors per socket, 2 total logical processors; using 2 logical
