RE: ISA + MSDE Problem
- From: "Jim Harrison" <Jim@xxxxxxxxxxxx>
- To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>,"[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
- Date: Fri, 11 Feb 2005 10:58:54 -0800
Take a look at the size of:
1 - the MSDE "master" database
2 - the total size of all active ISA logs
If either or both exceeds 2GB, you'll have to detach some of the databases.
I have a script that can help you with this...
________________________________
From: Nelson Camacho [mailto:ncamacho@xxxxxxxxxxxxxxx]
Sent: Fri 2/11/2005 9:59 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] ISA + MSDE Problem
http://www.ISAserver.org
Hi,
I have a ISA 2004 that has been working ok for a few months.
Yesterday the firewall service stopped, when i start it, it works for a
few minutes and stops again.
I get the following error message:
Event Type: Error
Event Source: Microsoft Firewall
Event Category: Log
Event ID: 8
Date: 11-02-2005
Time: 16:41:06
User: N/A
Computer: ISACEDAR
Description:
The Microsoft Firewall failed to log information to MSDE Database
ISALOG_20050211_FWS_001 in path E:\ISALogs\Firewall. The MSDE Error
description is: Could not find stored procedure 'sp_batch_insert'.. The
problem may be resolved by restarting the MSSQL$MSFW service. For more
information about this event, see ISA Server Help.
Restarting the MSSQL$MSFW service don't resolve the problem, the
solution was to stop using MSDE for logging and use files.
Anyone has any idea of what the problem/solution might be?
best regards,
Nelson Camacho
------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
jim@xxxxxxxxxxxx
To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx
All mail to and from this domain is GFI-scanned.
Other related posts:
