Monday, March 26, 2012

I can't start SQL Server Service

Hi,
when i try to start SQL Server Service I Have a Error.
I Must Reinstall SQL Server 7 or i can repair without
reinstall'
I have this Error:
2004-04-13 15:50:52.26 kernel Microsoft SQL Server
7.00 - 7.00.699 (Intel X86)
May 21 1999 14:08:18
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows NT 4.0 (Build 1381:
Service Pack 6)
2004-04-13 15:50:52.27 kernel Copyright (C) 1988-1997
Microsoft Corporation.
2004-04-13 15:50:52.27 kernel All rights reserved.
2004-04-13 15:50:52.27 kernel Logging SQL Server
messages in file 'd:\MSSQL7\log\ERRORLOG'.
2004-04-13 15:50:52.29 kernel initconfig: Number of
user connections limited to 32767.
2004-04-13 15:50:52.29 kernel SQL Server is starting at
priority class 'normal'(1 CPU detected).
2004-04-13 15:50:52.44 kernel User Mode Scheduler
configured for thread processing
2004-04-13 15:50:53.53 server Directory Size: 5387
2004-04-13 15:50:53.54 spid1 Using dynamic lock
allocation. [500] Lock Blocks, [1000] Lock Owner Blocks
2004-04-13 15:50:53.54 spid1 Starting up
database 'master'.
2004-04-13 15:50:53.54 spid1 Opening file d:\MSSQL7
\data\master.mdf.
2004-04-13 15:50:53.63 spid1 Opening file d:\MSSQL7
\data\mastlog.ldf.
2004-04-13 15:50:53.71 spid1 Loading SQL Server's
Unicode collation.
2004-04-13 15:50:53.72 spid1 Loading SQL Server's non-
Unicode sort order and character set.
2004-04-13 15:50:53.88 spid1 Using 'sqlimage.dll'
version '4.0.5'
Dump thread - spid = 1, PSS = 0x11dba084, EC = 0x11dba234
Stack Dump being sent to d:\MSSQL7\log\SQL00071.dmp
****************************************
******************
*********************
*
* BEGIN STACK DUMP:
* 04/13/04 15:51:04 spid 1
*
*
****************************************
******************
*********************
----
--
Short Stack Dump
0x77f67a6b Module(ntdll+7a6b) (ZwGetContextThread+b)
0x0077fc6b Module(sqlservr+37fc6b) (utassert_fail+1a0)
0x005a7c22 Module(sqlservr+1a7c22)
(RecoveryMgr::RedoPageOperation+1be)
0x004d2847 Module(sqlservr+d2847)
(RecoveryMgr::RedoPass+3a6)
0x004d1210 Module(sqlservr+d1210)
(RecoveryMgr::RecoverDb+2e0)
0x004ce9f7 Module(sqlservr+ce9f7) (DBTABLE::Startup+630)
0x004cdfd4 Module(sqlservr+cdfd4) (DBMgr::StartupDB+2c4)
0x00503482 Module(sqlservr+103482) (DBMgr::StartMaster+9)
0x00500b4d Module(sqlservr+100b4d) (initmaster+346)
0x004fec0d Module(sqlservr+fec0d) (init_routine+ba)
0x4109285a Module(ums+285a) (ProcessWorkRequests+ed)
0x41092d28 Module(ums+2d28) (ThreadStartRoutine+139)
0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce)
0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be)
2004-04-13 15:51:04.44 spid1 CImageHelper::GetSym
Error - Impossibile trovare il modulo specificato.
0x00000000 Module(sqlservr+ffc00000)
2004-04-13 15:51:04.51 kernel SQL Server Assertion:
File: <pageref.cpp>, line=3882
Failed Assertion = 'pPage->GetLsn () == lp-
>GetPrevPageLsn ()'.
2004-04-13 15:51:04.55 spid1 Location:
pageref.cpp:3882
Expression: pPage->GetLsn () == lp->GetPrevPageLsn ()
SPID: 1
Process ID: 326
2004-04-13 15:51:04.58 spid1 Error: 3624, Severity:
20, State: 1.
2004-04-13 15:51:04.63 spid1 Error: 3313, Severity:
21, State: 2.
2004-04-13 15:51:04.80 spid1 Cannot recover the master
database. Exiting.
Thank for All
PippoThere's not much to go on in the errorlog. Assuming you have searched KB for
details, I suggest you open a
case with MS Support for this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message news:1766f01c4216b$36294c70$
a001280a@.phx.gbl...
> Hi,
> when i try to start SQL Server Service I Have a Error.
> I Must Reinstall SQL Server 7 or i can repair without
> reinstall'
> I have this Error:
>
> 2004-04-13 15:50:52.26 kernel Microsoft SQL Server
> 7.00 - 7.00.699 (Intel X86)
> May 21 1999 14:08:18
> Copyright (c) 1988-1998 Microsoft Corporation
> Desktop Edition on Windows NT 4.0 (Build 1381:
> Service Pack 6)
> 2004-04-13 15:50:52.27 kernel Copyright (C) 1988-1997
> Microsoft Corporation.
> 2004-04-13 15:50:52.27 kernel All rights reserved.
> 2004-04-13 15:50:52.27 kernel Logging SQL Server
> messages in file 'd:\MSSQL7\log\ERRORLOG'.
> 2004-04-13 15:50:52.29 kernel initconfig: Number of
> user connections limited to 32767.
> 2004-04-13 15:50:52.29 kernel SQL Server is starting at
> priority class 'normal'(1 CPU detected).
> 2004-04-13 15:50:52.44 kernel User Mode Scheduler
> configured for thread processing
> 2004-04-13 15:50:53.53 server Directory Size: 5387
> 2004-04-13 15:50:53.54 spid1 Using dynamic lock
> allocation. [500] Lock Blocks, [1000] Lock Owner Blocks
> 2004-04-13 15:50:53.54 spid1 Starting up
> database 'master'.
> 2004-04-13 15:50:53.54 spid1 Opening file d:\MSSQL7
> \data\master.mdf.
> 2004-04-13 15:50:53.63 spid1 Opening file d:\MSSQL7
> \data\mastlog.ldf.
> 2004-04-13 15:50:53.71 spid1 Loading SQL Server's
> Unicode collation.
> 2004-04-13 15:50:53.72 spid1 Loading SQL Server's non-
> Unicode sort order and character set.
> 2004-04-13 15:50:53.88 spid1 Using 'sqlimage.dll'
> version '4.0.5'
> Dump thread - spid = 1, PSS = 0x11dba084, EC = 0x11dba234
> Stack Dump being sent to d:\MSSQL7\log\SQL00071.dmp
> ****************************************
******************
> *********************
> *
> * BEGIN STACK DUMP:
> * 04/13/04 15:51:04 spid 1
> *
> *
> ****************************************
******************
> *********************
> ----
> --
> Short Stack Dump
> 0x77f67a6b Module(ntdll+7a6b) (ZwGetContextThread+b)
> 0x0077fc6b Module(sqlservr+37fc6b) (utassert_fail+1a0)
> 0x005a7c22 Module(sqlservr+1a7c22)
> (RecoveryMgr::RedoPageOperation+1be)
> 0x004d2847 Module(sqlservr+d2847)
> (RecoveryMgr::RedoPass+3a6)
> 0x004d1210 Module(sqlservr+d1210)
> (RecoveryMgr::RecoverDb+2e0)
> 0x004ce9f7 Module(sqlservr+ce9f7) (DBTABLE::Startup+630)
> 0x004cdfd4 Module(sqlservr+cdfd4) (DBMgr::StartupDB+2c4)
> 0x00503482 Module(sqlservr+103482) (DBMgr::StartMaster+9)
> 0x00500b4d Module(sqlservr+100b4d) (initmaster+346)
> 0x004fec0d Module(sqlservr+fec0d) (init_routine+ba)
> 0x4109285a Module(ums+285a) (ProcessWorkRequests+ed)
> 0x41092d28 Module(ums+2d28) (ThreadStartRoutine+139)
> 0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce)
> 0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be)
> 2004-04-13 15:51:04.44 spid1 CImageHelper::GetSym
> Error - Impossibile trovare il modulo specificato.
> 0x00000000 Module(sqlservr+ffc00000)
> 2004-04-13 15:51:04.51 kernel SQL Server Assertion:
> File: <pageref.cpp>, line=3882
> Failed Assertion = 'pPage->GetLsn () == lp-
> 2004-04-13 15:51:04.55 spid1 Location:
> pageref.cpp:3882
> Expression: pPage->GetLsn () == lp->GetPrevPageLsn ()
> SPID: 1
> Process ID: 326
> 2004-04-13 15:51:04.58 spid1 Error: 3624, Severity:
> 20, State: 1.
> 2004-04-13 15:51:04.63 spid1 Error: 3313, Severity:
> 21, State: 2.
> 2004-04-13 15:51:04.80 spid1 Cannot recover the master
> database. Exiting.
>
>
> Thank for All
> Pippo
>|||Check if your server name change recently.
-Divya
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message
news:1766f01c4216b$36294c70$a001280a@.phx
.gbl...
> Hi,
> when i try to start SQL Server Service I Have a Error.
> I Must Reinstall SQL Server 7 or i can repair without
> reinstall'
> I have this Error:
>
> 2004-04-13 15:50:52.26 kernel Microsoft SQL Server
> 7.00 - 7.00.699 (Intel X86)
> May 21 1999 14:08:18
> Copyright (c) 1988-1998 Microsoft Corporation
> Desktop Edition on Windows NT 4.0 (Build 1381:
> Service Pack 6)
> 2004-04-13 15:50:52.27 kernel Copyright (C) 1988-1997
> Microsoft Corporation.
> 2004-04-13 15:50:52.27 kernel All rights reserved.
> 2004-04-13 15:50:52.27 kernel Logging SQL Server
> messages in file 'd:\MSSQL7\log\ERRORLOG'.
> 2004-04-13 15:50:52.29 kernel initconfig: Number of
> user connections limited to 32767.
> 2004-04-13 15:50:52.29 kernel SQL Server is starting at
> priority class 'normal'(1 CPU detected).
> 2004-04-13 15:50:52.44 kernel User Mode Scheduler
> configured for thread processing
> 2004-04-13 15:50:53.53 server Directory Size: 5387
> 2004-04-13 15:50:53.54 spid1 Using dynamic lock
> allocation. [500] Lock Blocks, [1000] Lock Owner Blocks
> 2004-04-13 15:50:53.54 spid1 Starting up
> database 'master'.
> 2004-04-13 15:50:53.54 spid1 Opening file d:\MSSQL7
> \data\master.mdf.
> 2004-04-13 15:50:53.63 spid1 Opening file d:\MSSQL7
> \data\mastlog.ldf.
> 2004-04-13 15:50:53.71 spid1 Loading SQL Server's
> Unicode collation.
> 2004-04-13 15:50:53.72 spid1 Loading SQL Server's non-
> Unicode sort order and character set.
> 2004-04-13 15:50:53.88 spid1 Using 'sqlimage.dll'
> version '4.0.5'
> Dump thread - spid = 1, PSS = 0x11dba084, EC = 0x11dba234
> Stack Dump being sent to d:\MSSQL7\log\SQL00071.dmp
> ****************************************
******************
> *********************
> *
> * BEGIN STACK DUMP:
> * 04/13/04 15:51:04 spid 1
> *
> *
> ****************************************
******************
> *********************
> ----
> --
> Short Stack Dump
> 0x77f67a6b Module(ntdll+7a6b) (ZwGetContextThread+b)
> 0x0077fc6b Module(sqlservr+37fc6b) (utassert_fail+1a0)
> 0x005a7c22 Module(sqlservr+1a7c22)
> (RecoveryMgr::RedoPageOperation+1be)
> 0x004d2847 Module(sqlservr+d2847)
> (RecoveryMgr::RedoPass+3a6)
> 0x004d1210 Module(sqlservr+d1210)
> (RecoveryMgr::RecoverDb+2e0)
> 0x004ce9f7 Module(sqlservr+ce9f7) (DBTABLE::Startup+630)
> 0x004cdfd4 Module(sqlservr+cdfd4) (DBMgr::StartupDB+2c4)
> 0x00503482 Module(sqlservr+103482) (DBMgr::StartMaster+9)
> 0x00500b4d Module(sqlservr+100b4d) (initmaster+346)
> 0x004fec0d Module(sqlservr+fec0d) (init_routine+ba)
> 0x4109285a Module(ums+285a) (ProcessWorkRequests+ed)
> 0x41092d28 Module(ums+2d28) (ThreadStartRoutine+139)
> 0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce)
> 0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be)
> 2004-04-13 15:51:04.44 spid1 CImageHelper::GetSym
> Error - Impossibile trovare il modulo specificato.
> 0x00000000 Module(sqlservr+ffc00000)
> 2004-04-13 15:51:04.51 kernel SQL Server Assertion:
> File: <pageref.cpp>, line=3882
> Failed Assertion = 'pPage->GetLsn () == lp-
> 2004-04-13 15:51:04.55 spid1 Location:
> pageref.cpp:3882
> Expression: pPage->GetLsn () == lp->GetPrevPageLsn ()
> SPID: 1
> Process ID: 326
> 2004-04-13 15:51:04.58 spid1 Error: 3624, Severity:
> 20, State: 1.
> 2004-04-13 15:51:04.63 spid1 Error: 3313, Severity:
> 21, State: 2.
> 2004-04-13 15:51:04.80 spid1 Cannot recover the master
> database. Exiting.
>
>
> Thank for All
> Pippo
>

No comments:

Post a Comment