|
Home > Archive > microsoft.public.sqlserver.server > June 2002 > SQL 6.5 server won't start
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL 6.5 server won't start
|
|
|
| Error message:
Can't allocate space for object 'syslogs' in
database "Model" because the logsegment is ull.
Instruction is to dump the transaction log.
Since SQL server can't start, where can I issue
the DUMP statement ?
Thanks.
| |
| Adi Cohn 2002-06-22, 8:31 pm |
| Try starting the server with the -f parameter. This will cause the server
to start with the minimal configiration. I don't know if this will work
(never had this problem), but it might.
Adi
"Lina" <lliu@istrafinancial.com> wrote in message
news:bc1501c210a9$41c08a50$36e
f2ecf@tkmsftngxa12...
> Error message:
> Can't allocate space for object 'syslogs' in
> database "Model" because the logsegment is ull.
>
> Instruction is to dump the transaction log.
> Since SQL server can't start, where can I issue
> the DUMP statement ?
>
> Thanks.
>
| |
| Tibor Karaszi 2002-06-22, 8:31 pm |
| .... also search KB for 3607, 3608 or 3609 (I never remember which is which). This way, you might
be able to start SQL Server without doing recovery for model. That might enable you to do DUMP
DATABASE model WITH NO_LOG.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Adi Cohn" <adicohn@hotmail.com> wrote in message news:#G7IGGLECHA.1360@tkmsftngp05...
> Try starting the server with the -f parameter. This will cause the server
> to start with the minimal configiration. I don't know if this will work
> (never had this problem), but it might.
>
> Adi
> "Lina" <lliu@istrafinancial.com> wrote in message
> news:bc1501c210a9$41c08a50$36e
f2ecf@tkmsftngxa12...
> > Error message:
> > Can't allocate space for object 'syslogs' in
> > database "Model" because the logsegment is ull.
> >
> > Instruction is to dump the transaction log.
> > Since SQL server can't start, where can I issue
> > the DUMP statement ?
> >
> > Thanks.
> >
>
>
| |
| Vikrant V Dalwale [MS] 2002-06-22, 8:31 pm |
| Please follow these steps,
Start the DOS Command prompt andrun the following Cmd,
C:> Sqlserver -c -f -m -3608 - REcover master Db only. ( once the server
is started leave this aside )
now connect to sqlserver using the isqlw (query analyzer )
select master database.
run following cmd,
UPDATE sysdatabases SET status = -32768 where name ='model'
then run
DUMP DATABASE model WITH NO_LOG.
this will free up the tran log for model.
-- Now set the Model Db back to normal..
UPDATE sysdatabases SET status = 0 where name ='model'
close the Query Analyser , close the Dos cmd prompt (cntrl+c) and restart
the server in normal mode.
Thanks,
Vikrant Dalwale
Microsoft SQL Server Support Professional
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.© 2002 Microsoft Corporation. All rights
reserved.
Additional support can be obtained at http://support.microsoft.com
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------
>Content-Class: urn:content-classes:message
>From: "Lina" <lliu@istrafinancial.com>
>Sender: "Lina" <lliu@istrafinancial.com>
>Subject: SQL 6.5 server won't start
>Date: Mon, 10 Jun 2002 11:04:25 -0700
>Lines: 10
>Message-ID: < bc1501c210a9$41c08a50$36ef2ecf
@tkmsftngxa12>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Thread-Index: AcIQqUHAZpAp7FXnQO+uvxlrDJiItw
==
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: TKMSFTNGXA12 10.201.226.40
>Path: cpmsftngxa07!cpmsftngxa06!cpms
ftngxa08
>Xref: cpmsftngxa07 microsoft.public.sqlserver.server:215445
>X-Tomcat-NG: microsoft.public.sqlserver.server
>
>Error message:
>Can't allocate space for object 'syslogs' in
>database "Model" because the logsegment is ull.
>
>Instruction is to dump the transaction log.
>Since SQL server can't start, where can I issue
>the DUMP statement ?
>
>Thanks.
>
>
|
|
|
|
|