* This is the modus mailing list *
Lapo,
Try issuing the following command to see if you have any open
transactions. If so we need to investigate what is causing this as it
will mean that all subsequent commands get logged and hence the log gets
full quickly.
---
DBCC OPENTRAN
---
---
Analysing humour is like analysing a frog: you can do it, but the frog
tends to die in the process.
(--------------------------------) {((((((
( Suneel Jhangiani ) /_ _ )
( Technical Director ) ( . . )
( Inter-Computer Technology Ltd. ) ( / )
(----------------------------------oOOo------------oOOo----)
( 40 James Street Tel: +44 (0) 20 7486 9601 )
( London W1U 1EU Fax: +44 (0) 7050 678 978 )
( United Kingdom Email: [EMAIL PROTECTED] )
( Website: http://www.inctech.com )
(----------------------------------------------------------)
-----Original Message-----
From: Lapo Nustrini [mailto:[EMAIL PROTECTED]
Sent: 16 January 2004 22:25
To: [EMAIL PROTECTED]
Subject: [Modus] MS SQL problem
* This is the modus mailing list *
Unfortunately, we already did this. It seemed to resolve the problem
(yesterday) but started failing again after a few hours.
Also, even after shrinking the tempdb (as suggested by a previous
poster), the problem continues to reoccur with
"The log file for database 'tempdb' is full. Back up the transaction
log for the database to free up some log space.."
errors showing up in the SQL log every 10 - 15 minutes.
Thanks,
Lapo
**
To unsubscribe, send an Email to: [EMAIL PROTECTED]
with the word "UNSUBSCRIBE" in the body or subject line.
