SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 sql 6.5 help
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

tallen
Starting Member

3 Posts

Posted - 08/07/2006 :  10:42:53  Show Profile
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: Error
Event Source: MSSQLServer
Event Category: (2)
Event ID: 17060
Date: 8/4/2006
Time: 8:03:10 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.

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 08/07/2006 :  11:09:49  Show Profile  Visit nr's Homepage
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.
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 08/07/2006 :  11:11:17  Show Profile
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
Go to Top of Page

tallen
Starting Member

3 Posts

Posted - 08/07/2006 :  11:52:59  Show Profile
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....
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000