오늘 재부팅 후 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