Any help?

Giganews Newsgroups
Subject: Any help?
Posted by:  tommy2 (tomm…@ptd.net)
Date: 4 Aug 2006

I am having a issue with a customers server. the specs are:
2003 server
sql 6.5
log file size is 1998MB (customer increased this 2 times this week) Log
space avail:600mb

In EM i try and truncate the log file... but the free space never
increases. Also there is no maint. plan on this database. When I try
and create one it advises against creating one with databases over
400MB.

The past day or so these errors are showing up:

Any help?

Event Type:    Error
Event Source:    MSSQLServer
Event Category:    (2)
Event ID:    17060
Date:        8/4/2006
Time:        7:51:20 AM
User:        N/A
Computer:    AUX-SERVER
Description:
The description for Event ID ( 17060 ) in Source ( MSSQLServer ) cannot
be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote
computer. You may be able to use the /AUXSOURCE=3D flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: Error : 701, Severity: 17, State: 2,
There is insufficient system memory to run this query..
Data:
0000: bd 02 00 00 11 00 00 00  =BD.......
0008: 00 00 00 00 07 00 00 00  ........
0010: 6d 61 73 74 65 72 00      master.

Replies