Multi threads

I have an app that is critical to our business. It handles and syncronises several SQL Servers, checks integrety etc. I need to make the app so it can run a few things at once. Does anyone have any experience with this? Currently we use Delphi and ADO. I have been fiddling with DMO to get more performance - I am not sure ADO is very quick for some I tasks I need to do.

I suppose my main question *really* is does ADO/DMO multi-thread and has anyone tried it. If not how do people do it?Yes, ADO emphatically multi-threads. I regularly run one app that for a few moments has 30+ threads running with no problems at all.

Then again, I'm well known for doing extremely perverse things with multi-threading (including a couple of multi-threaded batch files!).

-PatP|||That's interesting, is there anything you would recommend that I do/not do?

Also, do you have to use client cursors? I tend to find using more than one and I ger problems generally.|||Use connection pooling!!!
Use a separate connection object for every active recordset.
Close every connection as soon as you are done using it and free any memory it is/was using.
Keep your recordsets as small as practical (more threads, more network traffic, more contention).
When referencing database objects, do so strategically to avoid the app blocking itself

-PatPsql

Multi Server Administration

Hi,
We are about to implement MSX across our servers, we have some 400 SQL
Servers. What is the recommended number of master servers in sites as big as
this? Is there a maximum (recommended) number of target servers you can have
per master server?
Thanks
Julian
There is no hard recommended number that I know of. But before you
implement that you may want to check out SQL Sentry at
http://www.sqlsentry.net/ first. It can save you a LOT of headaches with
trying to monitor that many servers.
Andrew J. Kelly SQL MVP
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:0927CB87-4430-4860-9BDE-E3555B1168F7@.microsoft.com...
> Hi,
> We are about to implement MSX across our servers, we have some 400 SQL
> Servers. What is the recommended number of master servers in sites as big
as
> this? Is there a maximum (recommended) number of target servers you can
have
> per master server?
> Thanks
> Julian
|||The Quest tools for SQL Server also have multi-server execution capability.
It's similar to Query Analyzer, except that you can select as many servers
as you like to execute against. There's a freeware version too. Check out
http://www.quest.com/quest_central/s...ver/freeware/.
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:0927CB87-4430-4860-9BDE-E3555B1168F7@.microsoft.com...
> Hi,
> We are about to implement MSX across our servers, we have some 400 SQL
> Servers. What is the recommended number of master servers in sites as big
as
> this? Is there a maximum (recommended) number of target servers you can
have
> per master server?
> Thanks
> Julian

Multi Server Administration

Hi,
We are about to implement MSX across our servers, we have some 400 SQL
Servers. What is the recommended number of master servers in sites as big as
this? Is there a maximum (recommended) number of target servers you can have
per master server?
Thanks
JulianThere is no hard recommended number that I know of. But before you
implement that you may want to check out SQL Sentry at
http://www.sqlsentry.net/ first. It can save you a LOT of headaches with
trying to monitor that many servers.
--
Andrew J. Kelly SQL MVP
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:0927CB87-4430-4860-9BDE-E3555B1168F7@.microsoft.com...
> Hi,
> We are about to implement MSX across our servers, we have some 400 SQL
> Servers. What is the recommended number of master servers in sites as big
as
> this? Is there a maximum (recommended) number of target servers you can
have
> per master server?
> Thanks
> Julian|||The Quest tools for SQL Server also have multi-server execution capability.
It's similar to Query Analyzer, except that you can select as many servers
as you like to execute against. There's a freeware version too. Check out
www.quest.com/quest_central/sql_server/freeware/.
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:0927CB87-4430-4860-9BDE-E3555B1168F7@.microsoft.com...
> Hi,
> We are about to implement MSX across our servers, we have some 400 SQL
> Servers. What is the recommended number of master servers in sites as big
as
> this? Is there a maximum (recommended) number of target servers you can
have
> per master server?
> Thanks
> Julian

Multi Instance or Mutliple Virtual Servers

Can anybody tell me the differences, advantages or disadvantages in
installing an active/active cluster as
VIRTUAL/INSTANCE1
and
VIRTUAL/INSTANCE2
against
VIRTUAL1
and
VIRTUAL2
We did not seem to get the option to install a second instance on the first
virtual server and so opted for 2 virtual servers with names instance on
each so
VIRTUAL1 / INSTANCE1
and
VIRTUAL2 / INSTANCE2
Many Thanks
Steve
In a cluster, each instance is installed in its own virtual server.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Steve" <spam@.notformeplease.net> wrote in message
news:HLednboIr5j-OrnfRVnytg@.brightview.com...
> Can anybody tell me the differences, advantages or disadvantages in
> installing an active/active cluster as
> VIRTUAL/INSTANCE1
> and
> VIRTUAL/INSTANCE2
> against
> VIRTUAL1
> and
> VIRTUAL2
> We did not seem to get the option to install a second instance on the
first
> virtual server and so opted for 2 virtual servers with names instance on
> each so
> VIRTUAL1 / INSTANCE1
> and
> VIRTUAL2 / INSTANCE2
> Many Thanks
> Steve
>
|||Thanks Geoff
So I think that means we got it right first time.
Regards
Steve
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%2339SkcoHFHA.236@.TK2MSFTNGP14.phx.gbl...
> In a cluster, each instance is installed in its own virtual server.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Steve" <spam@.notformeplease.net> wrote in message
> news:HLednboIr5j-OrnfRVnytg@.brightview.com...
> first
>

Mulitiple DBs

Folk
I have multiple SQL SERVERs over 15 Servers. I have couple of test machines. I don't want to go to every machine and add evry single registration of every servers in mmc. that just way too much work. can i import an mmc console from one machine to another
if yes , how can i do it
Thank
GirishI exported registry keys under
HKEY_CURRENT_USER\Software\Microsoft\MSSQLServer\SQLEW\Registered
Servers X
when I did it last time on MSSQL7
Bart Simpson
Last time
On Tue, 2 Mar 2004 08:36:07 -0800, Girish
<anonymous@.discussions.microsoft.com> wrote:
>Folks
>I have multiple SQL SERVERs over 15 Servers. I have couple of test machines. I don't want to go to every machine and add evry single registration of every servers in mmc. that just way too much work. can i import an mmc console from one machine to another ?
>if yes , how can i do it ?
>Thanks
>Girish

Mulitiple DBs

Folks
I have multiple SQL SERVERs over 15 Servers. I have couple of test machines.
I don't want to go to every machine and add evry single registration of eve
ry servers in mmc. that just way too much work. can i import an mmc console
from one machine to another
?
if yes , how can i do it ?
Thanks
GirishI exported registry keys under
HKEY_CURRENT_USER\Software\Microsoft\MSS
QLServer\SQLEW\Registered
Servers X
when I did it last time on MSSQL7
Bart Simpson
Last time
On Tue, 2 Mar 2004 08:36:07 -0800, Girish
<anonymous@.discussions.microsoft.com> wrote:

>Folks
>I have multiple SQL SERVERs over 15 Servers. I have couple of test machines. I don'
t want to go to every machine and add evry single registration of every servers in m
mc. that just way too much work. can i import an mmc console from one machine to ano
the
r ?
>if yes , how can i do it ?
>Thanks
>Girish

MSX server in SQL 2005

I currently have a master server in SQL2000 and I have now have a couple of
new SQL2005 installs on different servers. I wish to make these new servers
target servers. So my question is - can a Master SQL2000 sever, target a
SQL2005 server?
Thanks
WendyWendy
Did you discover anything on this?
I'm in a similar situation where we'll probably have a mixture of SQL 2005
and SQL 2000 server due to vendors not upgrading to SQL 2005.
Would dearly love to know if there is any compatibility between versions for
the MSX/TSX setup.
Thanks
Phill
"Woo" wrote:

> I currently have a master server in SQL2000 and I have now have a couple o
f
> new SQL2005 installs on different servers. I wish to make these new serve
rs
> target servers. So my question is - can a Master SQL2000 sever, target a
> SQL2005 server?
> Thanks
> Wendy|||Hi Phill,
I did not get any reponses but I found this article, so it looks like you
cannot setup a SQL2000 as a master server to connect to SQL2005 target
servers. Something we are considering is installing a named instance of
SQL2005 on our SQL2000 master server, to create a MSX 2005 server. Havent
tried it yet though!
http://msdn2.microsoft.com/en-us/ms188926.aspx
Cheers
Wendy
"Phill" wrote:
[vbcol=seagreen]
> Wendy
> Did you discover anything on this?
> I'm in a similar situation where we'll probably have a mixture of SQL 2005
> and SQL 2000 server due to vendors not upgrading to SQL 2005.
> Would dearly love to know if there is any compatibility between versions f
or
> the MSX/TSX setup.
> --
> Thanks
> Phill
>
> "Woo" wrote:
>|||Please let me know how you get on with that solution.
I've tried setting up a SQL 2005 MSX but get version errors when I try and
enlist SQL 2000 TSX's
Thanks
Phill
"Woo" wrote:
[vbcol=seagreen]
> Hi Phill,
> I did not get any reponses but I found this article, so it looks like you
> cannot setup a SQL2000 as a master server to connect to SQL2005 target
> servers. Something we are considering is installing a named instance of
> SQL2005 on our SQL2000 master server, to create a MSX 2005 server. Havent
> tried it yet though!
> http://msdn2.microsoft.com/en-us/ms188926.aspx
> Cheers
> Wendy
>
>
> "Phill" wrote:
>

MSX server in SQL 2005

I currently have a master server in SQL2000 and I have now have a couple of
new SQL2005 installs on different servers. I wish to make these new servers
target servers. So my question is - can a Master SQL2000 sever, target a
SQL2005 server?
Thanks
WendyWendy
Did you discover anything on this?
I'm in a similar situation where we'll probably have a mixture of SQL 2005
and SQL 2000 server due to vendors not upgrading to SQL 2005.
Would dearly love to know if there is any compatibility between versions for
the MSX/TSX setup.
--
Thanks
Phill
"Woo" wrote:
> I currently have a master server in SQL2000 and I have now have a couple of
> new SQL2005 installs on different servers. I wish to make these new servers
> target servers. So my question is - can a Master SQL2000 sever, target a
> SQL2005 server?
> Thanks
> Wendy|||Hi Phill,
I did not get any reponses but I found this article, so it looks like you
cannot setup a SQL2000 as a master server to connect to SQL2005 target
servers. Something we are considering is installing a named instance of
SQL2005 on our SQL2000 master server, to create a MSX 2005 server. Havent
tried it yet though!
http://msdn2.microsoft.com/en-us/ms188926.aspx
Cheers
Wendy
"Phill" wrote:
> Wendy
> Did you discover anything on this?
> I'm in a similar situation where we'll probably have a mixture of SQL 2005
> and SQL 2000 server due to vendors not upgrading to SQL 2005.
> Would dearly love to know if there is any compatibility between versions for
> the MSX/TSX setup.
> --
> Thanks
> Phill
>
> "Woo" wrote:
> > I currently have a master server in SQL2000 and I have now have a couple of
> > new SQL2005 installs on different servers. I wish to make these new servers
> > target servers. So my question is - can a Master SQL2000 sever, target a
> > SQL2005 server?
> >
> > Thanks
> > Wendy|||Please let me know how you get on with that solution.
I've tried setting up a SQL 2005 MSX but get version errors when I try and
enlist SQL 2000 TSX's
Thanks
Phill
"Woo" wrote:
> Hi Phill,
> I did not get any reponses but I found this article, so it looks like you
> cannot setup a SQL2000 as a master server to connect to SQL2005 target
> servers. Something we are considering is installing a named instance of
> SQL2005 on our SQL2000 master server, to create a MSX 2005 server. Havent
> tried it yet though!
> http://msdn2.microsoft.com/en-us/ms188926.aspx
> Cheers
> Wendy
>
>
> "Phill" wrote:
> > Wendy
> >
> > Did you discover anything on this?
> >
> > I'm in a similar situation where we'll probably have a mixture of SQL 2005
> > and SQL 2000 server due to vendors not upgrading to SQL 2005.
> >
> > Would dearly love to know if there is any compatibility between versions for
> > the MSX/TSX setup.
> >
> > --
> >
> > Thanks
> > Phill
> >
> >
> > "Woo" wrote:
> >
> > > I currently have a master server in SQL2000 and I have now have a couple of
> > > new SQL2005 installs on different servers. I wish to make these new servers
> > > target servers. So my question is - can a Master SQL2000 sever, target a
> > > SQL2005 server?
> > >
> > > Thanks
> > > Wendy

MSSQLSERVER eventId 17055

Hello ...

I have 3 servers running MSSQLSERVER.
Last night I found out that the MSSQLSERVER service restarted itself ( on all MSSQLSERVER servers ).

This is what the logs said :

eventId = 17055
8-1-03 , 2:45:12 AM
17310 :
SqlDumpExceptionHandler: Process 796 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

eventId = 17055
8-1-03 , 2:45:24 AM
17311 :
SQL Server is aborting. Fatal exception c0000005 caught.

eventId = 17052
8-1-03 , 2:45:30 AM
The MSSQLSERVER service terminated unexpectedly.

All the servers had the same logs ( expect of the time and differect process ).

Does anybody have a clue what it could be ?RE:

I have 3 servers running MSSQLSERVER. Last night I found out that the MSSQLSERVER service restarted itself ( on all MSSQLSERVER servers ). All the servers had the same logs ( expect of the time and differect process ).

Q1 Does anybody have a clue what it could be ?

A1 No.

However, from the co-incidence described, a wild guess would be that some SQL in a reused code snippet or a common user stored procedure is causing the issue to manifest itself. {For example: such issues have been observed to exist in certain circumstances when SELECT statements apply the DISTINCT logical operator, and SELECT statements have been known to cause such AVs when:
1 A CHECK constraint exists on one of the columns in a queried table object, and
2 The column with the Check constraint is a specified part of the SELECT statement, and
3 The SELECT statement utilizes several LIKE predicates (in the WHERE clause of the SELECT statement).}

One possible strategy to consider would be to attempt to identify the offending SQL, and reproduce the error. Once certain of the SQL the issue occurs with, one would then re-write the sql statement(s) and / or proc such that the error does not occur.

Another would be to open a case with MS, and let PSS think about it (if it is indeed confirmed to be a bug, you may ask and have the support call fee refunded).

MSSQL Version

I have currently Standard Edition of MSSQL installed on my various servers. These servers are interacting with my one central server which also has Standard Edition of MSSQL.
Please let me know if I change my central server Standard Edition of MSSQL to Enterprise Edition and keep the other server with the Standard Edition, will this effect the working ?
Also please confirm, what are the changes in terms of query syntax or database setting that I will have to change for this change of version.i would not imagine there'd be any change required in your sql code as it remains fairly standard.

if you change the central server to enterprise edition you will obviously have to do some reconfigurations, but that's a given when installing something new, but i wouldn't imagine anything too drastic.

should connect and run well, good luck|||You can run a mix of Developer, Personal, Standard, and Enterprise versions of SQL Server with no problem. The Transact-SQL syntax is exactly the same on all of them, although there may be some SQL features that only exist on certain versions. As an example, clustering is only available to the Enterprise version, so you can't use clustering features in the Standard version, although the syntax would be the same if you could.

-PatP|||Thanks a lot !

mssql server started and then stopped

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...
>
|||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...
>
|||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...
>
|||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...
>
|||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...
>

mssql server started and then stopped

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?
>>>
>>
>>
>>
>>
>

mssql server started and then stopped

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] Lo
ck
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...
>|||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...
>|||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...
>|||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...
>|||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...
>|||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...
>