|Posted by:||tommy2 (tomm…@ptd.net)|
|Date:||4 Aug 2006|
I am having a issue with a customers server. the specs are:
log file size is 1998MB (customer increased this 2 times this week) Log
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
The past day or so these errors are showing up:
Event Type: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Time: 7:51:20 AM
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..
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.