Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: SQL Server Stopped Running

3 Weeks Ago   #1
guyinpasadena

Windows 7 Professional 64 bit
 
 
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 System SpecsSystem Spec
.
3 Weeks Ago   #2
townsbg

Windows 7 pro 64-bit sp 1
 
 

I would post in the sql server forum. Msdn forums - SQL Server
My System SpecsSystem Spec
3 Weeks Ago   #3
guyinpasadena

Windows 7 Professional 64 bit
 
 

Will do, thank you.
My System SpecsSystem Spec
.

Reply

 SQL Server Stopped Running




Thread Tools




Similar help and support threads
Thread Forum
My network has stopped running?
My network has stopped running yeah, what should i do restart the home group system or create a new home group.
Network & Sharing
Rundll32.exe has stopped running
This persistant pop-up window has been appearing telling me my rundll32.exe has stopped working. Details are as follow: Problem signature: Problem Event Name: BEX Application Name: rundll32.exe Application Version: 6.1.7600.16385 Application Timestamp: 4a5bc637 Fault...
BSOD Help and Support
Programs have stopped running
Before I start, my handle says it all. I am a retired computer programmer/engineer/network engineer/maintenance instructor/etc. I've been using Windows since it was a pimple on DOS. So, the obvious questions should be eliminated. What I need is some serious help to avoid a total wipe-out of my...
General Discussion
RDP to VM running under Virtual Server Not possible
Hi mods Mea culpa -- made an error -- you of course CAN connect via RDP if you need to - you have to allow it (as like any other machine) in the settings to allow remote users to connect. Cheers jimbo
Virtualization


Our Sites

Site Links

About Us

Find 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 17:02.
Twitter Facebook