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?
Event Type:Error
Event Source:MSSQLServer
Event Category:(2)
Event ID:17060
Date:8/4/2006
Time:7:51:20 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.tommy2 (tommy2@.ptd.net) writes:
Quote:
Originally Posted by
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?
Quote:
Originally Posted by
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.
Quote:
Originally Posted by
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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||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:
Quote:
Originally Posted by
tommy2 (tommy2@.ptd.net) writes:
Quote:
Originally Posted by
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?
>
Quote:
Originally Posted by
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.
>
Quote:
Originally Posted by
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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||tommy2 (tommy2@.ptd.net) writes:
Quote:
Originally Posted by
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.
Wonder if that was just pure luck? I happened to look at
http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx today. It does
not talk about 6.5 on Win2003...
Anyway, if their transaction log grows in size, there is some activity
going on, but what I cannot say from a distance. Did you try running
any of:
Quote:
Originally Posted by
Quote:
Originally Posted by
>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.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
没有评论:
发表评论