I am having a issue with a customers server. the specs are:
2003 server (the database used to be on a NT 4.o box but was moved 6 months ago to 2003. sql 6.5 log file size is 1998MB (customer increased this 2 times this past week) Log space avail: 600mb The database has been running fine since being moved to new server.
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.
Also in event log on the server I get the following errors: Event Type: Error Event Source: MSSQLServer Event Category: (2) Event ID: 17060 Date: 8/4/2006 Time: 8:03:10 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= 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 ½....... 0008: 00 00 00 00 07 00 00 00 ........ 0010: 6d 61 73 74 65 72 00 master.
Maint plan v6.5? What's that? Is the server set to truncate log on checkpoint? If not then you need to take log backups. If it is and you still aren't seeing free space check for transactions that are being held (dbcc opentran or look in master..sysprocesses for the login time).
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.