|
|
Posted by tommy2 on 08/07/06 12:37
This database used to run on NT 4.0 6 months ago. They moved it to a
win2003 server. It ran fine since being moved up till last week.
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
Navigation:
[Reply to this message]
|