Syslogs is full MSSQL 6.5 
Author Message
 Syslogs is full MSSQL 6.5
Syslogs is full, can't start the SQl Service!!!  What is the command
line thru DOS to truncate the log or extend the segment???  Did this a
while back but can't remember....thx

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 24 Apr 2002 03:00:00 GMT
 Syslogs is full MSSQL 6.5

DUMP TRANSACTION <dbname> WITH NO_LOG - but you need to start SQL first?  Which
database has a full log?

Quote:
> Syslogs is full, can't start the SQl Service!!!  What is the command
> line thru DOS to truncate the log or extend the segment???  Did this a
> while back but can't remember....thx

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (356 entries) see

 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.swynk.com/faq/sql/sqlserverfaq.asp
 or http://www.sql-server.co.uk


Thu, 25 Apr 2002 03:00:00 GMT
 Syslogs is full MSSQL 6.5
Its in the Model DB...


Quote:

> DUMP TRANSACTION <dbname> WITH NO_LOG - but you need to start SQL
first?  Which
> database has a full log?

> > Syslogs is full, can't start the SQl Service!!!  What is the command
> > line thru DOS to truncate the log or extend the segment???  Did
this a
> > while back but can't remember....thx

>  Neil Pike MVP/MCSE.  Protech Computing Ltd
>  (Please reply only to newsgroups)
>  SQL FAQ (356 entries) see

>  or www.ntfaq.com/sql.html (+ ntfaq download)
>  or http://www.swynk.com/faq/sql/sqlserverfaq.asp
>  or http://www.sql-server.co.uk

Sent via Deja.com http://www.deja.com/
Before you buy.


Fri, 26 Apr 2002 03:00:00 GMT
 Syslogs is full MSSQL 6.5

Quote:
> Its in the Model DB...

Q.     I have filled the model database's log and now SQL won't start with a
1105 error - what can I do?
(v1.0  1999.09.06)

A.  This is because tempdb gets created with model's attributes at SQL startup.
 To overcome this :-

1.  Start SQL Server with the -T3607 trace flag.  See the books online for how
to do this.

2.  Login to SQL Server as sa with ISQL or ISQLW.

3.  Do a DUMP TRANSACTION model WITH NO_LOG

4.  Stop SQL Server

5.  Remove the trace-flag

You should now be able to restart SQL again.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (356 entries) see

 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.swynk.com/faq/sql/sqlserverfaq.asp
 or http://www.sql-server.co.uk



Sat, 27 Apr 2002 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Syslogs is full MSSQL 6.5

2. Syslogs under MSSQL SERVER 6.5

3. MS SQLSERVER 6.5: Syslogs full?

4. SQL Server 6.5 shuts down due to error 1105, syslogs full

5. Drop table error in MSSQL 6.5 and MSSQL 2000

6. set mssql 7.0 compatible to mssql 6.5?

7. systypes in mssql compatibility mode for mssql 6.5?

8. Administering MSSQL 6.5 using EM from MSSQL 7.0

9. compare mssql 6.5 database and mssql 7.0 database

10. import/export MSSQL 6.5 and MSSQL 7.0

11. Backup in MSSQL 6.5 and restore to MSSQL 7.0

12. upgrade of MSSQL 6.5 to MSSQL 2000


 
Powered by phpBB® Forum Software