SQL Server Stopped Running

guyinpasadena

New member
Member
Local time
8:00 AM
Messages
57
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 My Computer

At a glance

Windows 7 Professional 64 bitIntel Core i5-2430M CPU @ 2.40GHz8.00 GBNVIDIA NVS 4200M
Computer type
Laptop
Computer Manufacturer/Model Number
Dell Latitude E6520
OS
Windows 7 Professional 64 bit
CPU
Intel Core i5-2430M CPU @ 2.40GHz
Memory
8.00 GB
Graphics Card(s)
NVIDIA NVS 4200M
Antivirus
Microsoft Security Essentials

My Computers My Computers

  • At a glance

    Windows 7 pro/Windows 10 ProIntel i7 860 Quad core 2.8 ghz8 gbATI Radeon HD 5770 1 gb ram
    Computer type
    PC/Desktop
    Computer Manufacturer/Model Number
    HP Pavillion Elite HPE-250f
    OS
    Windows 7 pro/Windows 10 Pro
    CPU
    Intel i7 860 Quad core 2.8 ghz
    Memory
    8 gb
    Graphics Card(s)
    ATI Radeon HD 5770 1 gb ram
    Monitor(s) Displays
    Alienware 25 AW2521HF & Viewsonic
    Screen Resolution
    1920 x1080 & 1680x1050
    Hard Drives
    WD blue 1 tb & 500 gb.
    Browser
    FF of course.
    Other Info
    https://www.bestbuy.com/site/hp-pavilion-elite-desktop-intel-core-i7-processor-8gb-memory-1tb-hard-drive/9921493.p?skuId=9921493
  • At a glance

    Windows 2012 R2 Data center/Linux Minti3 9100 3.6GHz, 8M cache, 4C/4T8GB 2666MT/s DDR4 ECC UDIMM
    Computer type
    PC/Desktop
    System Manufacturer/Model Number
    Dell Poweredge T140
    OS
    Windows 2012 R2 Data center/Linux Mint
    CPU
    i3 9100 3.6GHz, 8M cache, 4C/4T
    Memory
    8GB 2666MT/s DDR4 ECC UDIMM
    Monitor(s) Displays
    Viewsonic
    Screen Resolution
    1680x1050
    Hard Drives
    1 TB & 750 GB
    Other Info
    https://www.dell.com/en-us/work/shop/productdetailstxn/poweredge-t140?~ck=bt
Will do, thank you.
 

My Computer My Computer

At a glance

Windows 7 Professional 64 bitIntel Core i5-2430M CPU @ 2.40GHz8.00 GBNVIDIA NVS 4200M
Computer type
Laptop
Computer Manufacturer/Model Number
Dell Latitude E6520
OS
Windows 7 Professional 64 bit
CPU
Intel Core i5-2430M CPU @ 2.40GHz
Memory
8.00 GB
Graphics Card(s)
NVIDIA NVS 4200M
Antivirus
Microsoft Security Essentials
Back
Top