Hoy me encontré con una sorpresa al intentar iniciar un SQL Server después de un reinicio. El servidor estaba funcionando antes del reinicio, así que tuve el presentimiento de que este problema podría ser difícil. Lo primero que hice fue revisar el log de SQL Server para ver qué había pasado.
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 Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG’. 2014-08-23 02:09:44.63 Server The service account is ‘DOMAIN\databaseservice’. This is an informational message; no user action is required. 2014-08-23 02:09:44.63 Server Registry startup parameters: -d E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf -e E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG -l E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.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