Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 sql 6.5 help

Author  Topic 

Starting Member

3 Posts

Posted - 2006-08-07 : 10:42:53
Ok...forgive me I am kinda new to the sql thing.

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

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
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..
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.


12543 Posts

Posted - 2006-08-07 : 11:09:49
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.
Go to Top of Page

Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-07 : 11:11:17
SQL 6.5 is not supported on win2k3 at all. Are you sure this is SQL 6.5? if so, you need to immediately upgrade the db. You are only 3 major releases behind.

Go to Top of Page

Starting Member

3 Posts

Posted - 2006-08-07 : 11:52:59
It is set to trucate log.....customes cannot upgrade sql at this time due to the app that is using it...some Mac app. I understand....
Go to Top of Page

- Advertisement -