오늘 재부팅 후 SQL Server를 시작하려다 예상치 못한 문제에 부딪혔습니다. 재부팅 전에는 서버가 정상 작동했기 때문에 이 문제가 까다로울 수 있다는 좋지 않은 예감이 들었습니다. 가장 먼저 한 일은 무슨 일이 일어났는지 확인하기 위해 SQL Server 로그를 확인하는 것이었습니다.

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 4199
2014-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