서비스가 시작되지 않아 로그파일 내용을 올립니다.
도움 좀 부탁드립니다.
2013-06-19 10:24:15.83 Server Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (Intel X86)
Jun 28 2012 08:42:37
Copyright (c) Microsoft Corporation
Express Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)
2013-06-19 10:24:15.84 Server (c) Microsoft Corporation.
2013-06-19 10:24:15.84 Server All rights reserved.
2013-06-19 10:24:15.84 Server Server process ID is 5856.
2013-06-19 10:24:15.84 Server System Manufacturer: 'SAMSUNG ELECTRONICS CO.,LTD', System Model: 'Samsung Desktop System'.
2013-06-19 10:24:15.84 Server Authentication mode is MIXED.
2013-06-19 10:24:15.84 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
2013-06-19 10:24:15.84 Server This instance of SQL Server last reported using a process ID of 4968 at 2013-06-19 오전 10:16:46 (local) 2013-06-19 오전 1:16:46 (UTC). This is an informational message only; no user action is required.
2013-06-19 10:24:15.84 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
2013-06-19 10:24:15.85 서버 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2013-06-19 10:24:15.85 서버 Detected 2 CPUs. This is an informational message; no user action is required.
2013-06-19 10:24:15.91 서버 Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2013-06-19 10:24:15.92 서버 Node configuration: node 0: CPU mask: 0x00000003:0 Active CPU mask: 0x00000003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2013-06-19 10:24:15.95 spid7s Starting up database 'master'.
2013-06-19 10:24:16.02 spid7s 오류: 9003, 심각도: 20, 상태: 1.
2013-06-19 10:24:16.02 spid7s The log scan number (5048:112:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
2013-06-19 10:24:16.02 spid7s Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
Comment 1
-
항해자™
2013.06.20 23:23
master 디비에 문제가 생긴 것 같네요,,,
SQL을 새로 설치하고 만들었던 디비를 어테치하는게 빠를 듯 하네요,,,