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.
SQL has been on this server for 6 months. The problem just started.
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=3D 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 =BD......
0008: 00 00 00 00 07 00 00 00 ......
0010: 6d 61 73 74 65 72 00 master.This seems to be a duplicate post to the one in "Clients".
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"tommy2" <tommy2@.ptd.net> wrote in message
news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
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.
SQL has been on this server for 6 months. The problem just started.
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.|||Hi,
To truncate the log file in 6.5 do the below steps:-
use dbname
go
dbcc checktable(syslogs)
go
Dump tran dbname with no_log
After running that execute below command to get the log size.
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
SQL Server MVP
"tommy2" <tommy2@.ptd.net> wrote in message
news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
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.
SQL has been on this server for 6 months. The problem just started.
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.|||Thanks for your help!!
I have a cpl questions if you would not mind.
do users have to be off to run this procedure?
will running this procedure endanger any of the data?
any special things I need to know or do because this is version 6.5?
what do I need to back up before running this procedure?
I really thank you for your help!!
Tom
Hari Prasad wrote:
> Hi,
> To truncate the log file in 6.5 do the below steps:-
> use dbname
> go
> dbcc checktable(syslogs)
> go
> Dump tran dbname with no_log
>
> After running that execute below command to get the log size.
> DBCC SQLPERF(LOGSPACE)
> Thanks
> Hari
> SQL Server MVP
> "tommy2" <tommy2@.ptd.net> wrote in message
> news:1154722787.468850.206630@.s13g2000cwa.googlegroups.com...
> 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.
> SQL has been on this server for 6 months. The problem just started.
> 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=3D 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 =BD......
> 0008: 00 00 00 00 07 00 00 00 ......
> 0010: 6d 61 73 74 65 72 00 master.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment