> 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?
>...
> There is insufficient system memory to run this query..

Erland Sommarskog wrote:
> 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