Posted by Erland Sommarskog on 08/04/06 22:10

tommy2 (tommy2@ptd.net) writes:
> I am having a issue with a customers server. the specs are:
> 2003 server
> sql 6.5

SQL 6.5 on SQL 2003? I didn't even think that was possible. Has the
OS been upgraded from Win 2000?

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

Try running this from a query window:

sp_spaceused syslogs, true

I would be interested in seeing the output, at least if the problem
persists. It could also be interested in seeing the output from sp_helpdb.

> The past day or so these errors are showing up:
>
> Any help?
>...
> There is insufficient system memory to run this query..

That could be about anything. Have you checked the SQL Server Errorlog?

Don't know what experience you have of SQL 6.5, but in case you don't
know: this is a very different architecture from later releases.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]