Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reoaran
Starting Member
20 Posts |
 Posted - 2010-08-08 : 12:45:19
|
| Hi,When i start the mssql server service, it stops immediately after a min. When i checked the windows event log, it shows an error as below, Error: 3313, Severity: 21, State: 2 Error while redoing logged operation in database 'model'. Error at log record ID (6:354:2)..Tried starting the sql server with minimal configuration and single user mode through the command prompt, the result was same... checked the errorlog and found the below... seems corruption of sys db?010-08-08 05:42:30.47 spid5 ex_raise2: Exception raised, major=34, minor=56, severity=21, attempting to create symptom dump2010-08-08 05:42:30.50 spid8 Bypassing recovery for database 'msdb' because it is marked SUSPECT.2010-08-08 05:42:30.62 spid5 Using 'dbghelp.dll' version '4.0.5'*Dump thread - spid = 5, PSS = 0x42d820c0, EC = 0x42d823f0* * User initiated stack dump. This is not a server exception dump.* *Stack Dump being sent to D:\MicrosoftSQLServer\Data\MSSQL\log\SQLDump0045.txt* ********************************************************************************* BEGIN STACK DUMP:* 08/08/10 05:42:30 spid 5** ex_raise2: Exception raised, major=34, minor=56, severity=21** ** MODULE BASE END SIZE* sqlservr 00400000 00CBAFFF 008bb000* ntdll 7C800000 7C8BFFFF 000c0000* kernel32 77E40000 77F41FFF 00102000* ADVAPI32 77F50000 77FEBFFF 0009c000* RPCRT4 77C50000 77CEEFFF 0009f000* MSVCP71 7C3C0000 7C43BFFF 0007c000* MSVCR71 7C360000 7C3B5FFF 00056000* opends60 41060000 41065FFF 00006000* SHELL32 7C8D0000 7D0D2FFF 00803000* msvcrt 77BA0000 77BF9FFF 0005a000* GDI32 77C00000 77C47FFF 00048000* USER32 77380000 77411FFF 00092000* SHLWAPI 77DA0000 77DF1FFF 00052000* sqlsort 42AE0000 42B6FFFF 00090000* ums 41070000 4107DFFF 0000e000* comctl32 77420000 77522FFF 00103000* sqlevn70 41080000 4108AFFF 0000b000* NETAPI32 02C90000 02CE7FFF 00058000* AUTHZ 02CF0000 02D03FFF 00014000* COMRES 030A0000 03165FFF 000c6000* ole32 031F0000 03323FFF 00134000* XOLEHLP 03330000 03335FFF 00006000* MSDTCPRX 03340000 033B7FFF 00078000* Invalid Address 033C0000 03420FFF 00061000* Invalid Address 03430000 03448FFF 00019000* VERSION 03450000 03457FFF 00008000* WSOCK32 03460000 03468FFF 00009000* WS2_32 03470000 03486FFF 00017000* WS2HELP 03490000 03497FFF 00008000* OLEAUT32 034A0000 0352BFFF 0008c000* CLUSAPI 03570000 03581FFF 00012000* RESUTILS 03590000 035A2FFF 00013000* USERENV 035B0000 03673FFF 000c40007C36B22B Module(MSVCR71+0000B22B) (endthread+000000AA)* 77E66063 Module(kernel32+00026063) (GetModuleFileNameA+000000EB)* -------------------------------------------------------------------------------2010-08-08 05:42:44.42 spid5 Stack Signature for the dump is 0x289401472010-08-08 05:42:44.43 spid5 Error: 3456, Severity: 21, State: 12010-08-08 05:42:44.43 spid5 Could not redo log record (6:354:2), for transaction ID (0:0), on page (1:9), database 'model' (3). Page: LSN = (6:349:2), type = 13. Log: OpCode = 4, context 23, PrevPageLSN: (6:352:2)..2010-08-08 05:42:44.50 spid5 ex_raise2: Exception raised, major=34, minor=56, severity=25, attempting to create symptom dump2010-08-08 05:42:44.50 spid5 Using 'dbghelp.dll' version '4.0.5'*Dump thread - spid = 5, PSS = 0x42d820c0, EC = 0x42d823f0* * User initiated stack dump. This is not a server exception dump.Thought of restoring the system databases... but we needed the service to be running for that tooo.. Any body can help on this ... ? * |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-08 : 17:02:59
|
| Seems you're going to need to rebuild master. Do you have a backup of msdb? |
 |
|
|
reoaran
Starting Member
20 Posts |
Posted - 2010-08-09 : 03:59:48
|
| yes.. have the backup... but this is SQL2000. how do we rebuild the master here ? Also we need the sql service to be in running state for the same... but it stops whenever we start them... |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-09 : 13:03:39
|
| http://msdn.microsoft.com/en-us/library/aa197950(SQL.80).aspx |
|
|
|
|
|
|
|
|
MSSQL Services stops after starting