Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
tallen
Starting Member
3 Posts |
Posted - 2006-08-07 : 10:42:53
|
Ok...forgive me I am kinda new to the sql thing.I am having a issue with a customers server. the specs are: 2003 server (the database used to be on a NT 4.o box but was moved 6 months ago to 2003.sql 6.5 log file size is 1998MB (customer increased this 2 times this past week) Log space avail: 600mb The database has been running fine since being moved to new server.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.Also in event log on the server I get the following errors:Event Type: ErrorEvent Source: MSSQLServerEvent Category: (2)Event ID: 17060Date: 8/4/2006Time: 8:03:10 AMUser: N/AComputer: AUX-SERVERDescription: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. |
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-07 : 11:09:49
|
Maint plan v6.5? What's that?Is the server set to truncate log on checkpoint?If not then you need to take log backups.If it is and you still aren't seeing free space check for transactions that are being held (dbcc opentran or look in master..sysprocesses for the login time).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-07 : 11:11:17
|
SQL 6.5 is not supported on win2k3 at all. Are you sure this is SQL 6.5? if so, you need to immediately upgrade the db. You are only 3 major releases behind.-ec |
|
|
tallen
Starting Member
3 Posts |
Posted - 2006-08-07 : 11:52:59
|
It is set to trucate log.....customes cannot upgrade sql at this time due to the app that is using it...some Mac app. I understand.... |
|
|
|
|
|