I have a problem with all mssql servers in the domain that is unable to
start
The error is
the mssql server started and then stopped. All mssql service is started
with the local system account
any idea?ERROR.LOG contains something? Event Viewer?
"nobody" <nobody@.nobody.com> wrote in message
news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>I have a problem with all mssql servers in the domain that is unable to
>start
> The error is
> the mssql server started and then stopped. All mssql service is started
> with the local system account
>
> any idea?
>|||didnt see anything in event viewer but error.log in mssql\log shows this
2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-11-13 06:40:43.76 server All rights reserved.
2007-11-13 06:40:43.76 server Server Process ID is 2448.
2007-11-13 06:40:43.76 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
2007-11-13 06:40:43.77 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2007-11-13 06:40:43.81 server SQL Server configured for thread mode
processing.
2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
I am not doing any restores
please help
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
> ERROR.LOG contains something? Event Viewer?
>
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is started
>> with the local system account
>>
>> any idea?
>|||Hi
Peraphs it got corrupted.Do you have a backup?
/*
Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
*/
"nobody" <nobody@.nobody.com> wrote in message
news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
> didnt see anything in event viewer but error.log in mssql\log shows this
>
> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-11-13 06:40:43.76 server All rights reserved.
> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
> 2007-11-13 06:40:43.77 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
> processing.
> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lock
> Blocks, [1000] Lock Owner Blocks.
> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in the middle of a restore.
>
> I am not doing any restores
> please help
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is started
>> with the local system account
>>
>> any idea?
>>
>|||the thing is several mssql on the same domain is failing to start. I think
it might have to do with backup exec backups failed last night.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
> Hi
> Peraphs it got corrupted.Do you have a backup?
> /*
> Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in
> the middle of a restore.
> */
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority class
>> 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
>> in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is
>> started with the local system account
>>
>> any idea?
>>
>>
>|||Also, there is a KB about this problem, you may want to read it.
http://support.microsoft.com/kb/822852
--
Ekrem Önsoy
"nobody" <nobody@.nobody.com> wrote in message
news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
> the thing is several mssql on the same domain is failing to start. I think
> it might have to do with backup exec backups failed last night.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> Peraphs it got corrupted.Do you have a backup?
>> /*
>> Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
>> in
>> the middle of a restore.
>> */
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority
>> class 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1:
>> 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is
>> started with the local system account
>>
>> any idea?
>>
>>
>>
>|||The problem is I did not do any restores. In backup exec I backed up the
databases but selected the option (continue backup if consistency check
fails)
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
> Also, there is a KB about this problem, you may want to read it.
> http://support.microsoft.com/kb/822852
> --
> Ekrem Önsoy
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
>> the thing is several mssql on the same domain is failing to start. I
>> think it might have to do with backup exec backups failed last night.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> Peraphs it got corrupted.Do you have a backup?
>> /*
>> Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in
>> the middle of a restore.
>> */
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows
>> this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority
>> class 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version
>> '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1:
>> 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database
>> 'model' because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable
>>to start
>> The error is
>> the mssql server started and then stopped. All mssql service is
>> started with the local system account
>>
>> any idea?
>>
>>
>>
>>
>|||how do I run dbcc from query analyzer? I have another machine failed to
start sql. I believe this had to do with backup exec
"nobody" <nobody@.nobody.com> wrote in message
news:uFm1nphJIHA.5208@.TK2MSFTNGP04.phx.gbl...
> The problem is I did not do any restores. In backup exec I backed up the
> databases but selected the option (continue backup if consistency check
> fails)
>
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
>> Also, there is a KB about this problem, you may want to read it.
>> http://support.microsoft.com/kb/822852
>> --
>> Ekrem Önsoy
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
>> the thing is several mssql on the same domain is failing to start. I
>> think it might have to do with backup exec backups failed last night.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> Peraphs it got corrupted.Do you have a backup?
>> /*
>> Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in
>> the middle of a restore.
>> */
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows
>> this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority
>> class 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version
>> '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x:
>> 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1:
>> 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database
>> 'model' because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>>I have a problem with all mssql servers in the domain that is unable
>>>to start
>>>
>>> The error is
>>>
>>> the mssql server started and then stopped. All mssql service is
>>> started with the local system account
>>>
>>>
>>> any idea?
>>>
>>
>>
>>
>>
>