Issue with my SQL Server 2005...

I am currently having issues with my SQL Server 2005. I am runnning a Moss 2007 single web server with the databases stored on a seperate server running SQL Server 2005 with SP2.  Attached to this question will be the error log files on my server. At first I was recieving this error message 3 days ago and I updated the server with SP2 and the error logs fixed and I had no problems for almost 3 days and then they started coming back. Last time I recieved this error the server crashed ubruptly as time passed. I maybe have 2 days top before the SQL server crashes again, please help!
Who is Participating?
Jim P.Commented:
>> where on the SQL server I would have to go in order to  
>> apply the codes to enable the blackbox trace feature

Go into the SQL Server Management Studio and connect to the server. From there do a New Query -- paste the code into the window and then hit <F5> to execute it.

Looking at the errors, go into the Services console and make sure that the SQL Server Service, SQL Server Agent and the SQL Browser Services are up. Also make sure none of the SQL services are set to disabled.

Future reference: The paper icon on the event viewer will copy the info to the clipboard. Then you can just paste it into the code snippet window or into document and have the info searchable.

Copy Event Info
Does the Windows application log have any errors during this time period?
michaelvegamvAuthor Commented:
Yes sir, the windows application log has the error every second the same error log I attached to this question. This has been occuring for the past day and a half. I can not attach all the logs because it si equivalent to about 15 gb of the same log repeatedly every second.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Jim P.Commented:
All this is really saying is "Dump is associated with file C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump10000.txt"

Can you pull a chunk of that and post it?

And can you post just one of the error messages in the Event viewer?

Also you may want to add the Blackbox Trace to your SQL as well.
USE master 
/** ref: **/
DECLARE @TraceId int
DECLARE @maxfilesize bigint 
SET @maxfilesize = 25 
EXEC sp_trace_create
@TraceId OUTPUT, 
@options = 8, 
@tracefile = NULL,
@maxfilesize = @maxfilesize 
EXEC sp_trace_setstatus @TraceId, 1
EXEC sp_procoption
'StartBlackBoxTrace', 'STARTUP', 'ON'

Open in new window

Can you monitor the memory usage of the SQL Server? It is normal for it to climb over time but its not normal for it to crash. You may need to set the max memory configuration of the SQL Server to stop it using loads of memory, especially if your SQL Server has 2G or less RAM (on a 32 bit box)
michaelvegamvAuthor Commented:
SIr, I have here attached to logs from my Moss 2007 Server and the SQL 2005 Server. Each document has them labeled by server so there is no confusion. I was looking over that website that was reffered to me  2 posts uo from this one and I understand the conecpt of a ackbox trace howver I was curious where on the SQL server I would have to go in order to  apply the codes to enable the blackbox trace feature, that would be very helpful if possible,k thank you very much for all your help and guidance.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.