* This is the modus mailing list *
Go into Enterprise Manager and find your Quarantine Database, right
click on it select properties and ensure that the Truncate Log setting
is checked. This should help remove the burden on the TempDB.
---
Never have I seen a word as accurate as politics. Poly meaning many, and
tic being a blood-sucking thing.
(--------------------------------) {((((((
( 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 16:24
To: [EMAIL PROTECTED]
Subject: [Modus] MS SQL problem
* This is the modus mailing list *
Since a few days ago, the SQL server we use to store the quarantine has
been playing up, and prevented Modusgate from archiving spam at an
acceptable rate.
The Modus Error logs show quite a few "timeout" errors such as:
---- MODUSADM log entry made at 01/16/2004 07:36:23
Mail Store error [0xE00E03E9]:
State:S1T00,Native:0,Origin:[Microsoft][ODBC SQL Server Driver]Timeout
expired
On the SQL side, the major concern is the following entry in the SQL
logs:
"The log file for database 'tempdb' is full. Back up the transaction
log for the database to free up some log space.."
accompanied by:
"Error: 9002, Severity: 17, State: 6"
Reading the SQL documentation, I simply don't understand how this could
be, given that the tempDB is recreated everytime SQL is restarted, and
that there is about 5GB of diskspace for it to grow into.
Has anyone seen this before?
Vircom has been helping out on this one, but I thought I might run it
past the mailing list just in case.
Thanks,
Lapo Nustrini
Seanet Corporation
701 Fifth Ave, Suite 6801
Seattle
98104 WA
(206) 343 7828
http://www.seanet.com
**
To unsubscribe, send an Email to: [EMAIL PROTECTED]
with the word "UNSUBSCRIBE" in the body or subject line.
**
To unsubscribe, send an Email to: [EMAIL PROTECTED]
with the word "UNSUBSCRIBE" in the body or subject line.
