SQL Server Stopped Running


  1. Posts : 57
    Windows 7 Professional 64 bit
       #1

    SQL Server Stopped Running


    Have Win 7 Pro SP1 64-bit SQL Server 2005.
    Was running fine up until about one week ago.
    Here is the error log:

    2019-05-24 12:46:24.58 Server Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86)
    Dec 10 2010 10:56:29
    Copyright (c) 1988-2005 Microsoft Corporation
    Express Edition on Windows NT 6.1 (Build 7601: Service Pack 1)

    2019-05-24 12:46:24.58 Server (c) 2005 Microsoft Corporation.
    2019-05-24 12:46:24.58 Server All rights reserved.
    2019-05-24 12:46:24.58 Server Server process ID is 6268.
    2019-05-24 12:46:24.58 Server Authentication mode is MIXED.
    2019-05-24 12:46:24.58 Server Logging SQL Server messages in file 'C:\Program Files (x86)\Microsoft SQL Server\EMMSDE\MSSQL.1\MSSQL\LOG\ERRORLOG'.
    2019-05-24 12:46:24.58 Server This instance of SQL Server last reported using a process ID of 2712 at 5/24/2019 12:41:51 PM (local) 5/24/2019 7:41:51 PM (UTC). This is an informational message only; no user action is required.
    2019-05-24 12:46:24.58 Server Registry startup parameters:
    2019-05-24 12:46:24.58 Server -d C:\Program Files (x86)\Microsoft SQL Server\EMMSDE\MSSQL.1\MSSQL\DATA\master.mdf
    2019-05-24 12:46:24.58 Server -e C:\Program Files (x86)\Microsoft SQL Server\EMMSDE\MSSQL.1\MSSQL\LOG\ERRORLOG
    2019-05-24 12:46:24.58 Server -l C:\Program Files (x86)\Microsoft SQL Server\EMMSDE\MSSQL.1\MSSQL\DATA\mastlog.ldf
    2019-05-24 12:46:24.59 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2019-05-24 12:46:24.59 Server Detected 8 CPUs. This is an informational message; no user action is required.
    2019-05-24 12:46:24.90 Server 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.
    2019-05-24 12:46:24.96 Server Database mirroring has been enabled on this instance of SQL Server.
    2019-05-24 12:46:24.96 spid4s Starting up database 'master'.
    2019-05-24 12:46:25.02 spid4s Error: 9003, Severity: 20, State: 1.
    2019-05-24 12:46:25.02 spid4s The log scan number (879:408: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.
    2019-05-24 12:46:25.02 spid4s 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.

    Any help much appreciated as this is critical service for us.
    Thanks in advance for your help!
      My Computer


  2. Posts : 1,851
    Windows 7 pro
       #2

    I would post in the sql server forum. Msdn forums - SQL Server
      My Computer


  3. Posts : 57
    Windows 7 Professional 64 bit
    Thread Starter
       #3

    Will do, thank you.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 12:18.
Find Us