• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 94
  • Last Modified:

a log shipping log backup job was just failed with ,net run time error

hi ,

a sql server log shipping job just failed and I start it again, it is OK HOWEVER, when I check application log, it shows an error just before that:

.NET Runtime version : 4.0.40305.0 - .NET Framework Initialization ErrorUnable to find a version of the runtime to run this application.

What is that mean ?

We restart the SQL server 1 day ago already.

any experience on this ?
0
marrowyung
Asked:
marrowyung
  • 11
  • 10
1 Solution
 
Daniel JonesData Research AnalystCommented:
You must use “Turn Windows features on or off” in the Control Panel to install or configure Microsoft .Net Framework 3.5 SP1″
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
We restart the SQL server 1 day ago already.
Why did you do that?

What's the SQL Server and Windows Server versions?
0
 
marrowyungAuthor Commented:
Daniel,

no. this error only happen recently , we run that SQL server for a long time.

Victor,

no hearing from you for a while, how have you been ?

"Why did you do that?
"

basically the SQL server stopped without any reason and we start it again.

we now also keep receiving:

DESCRIPTION:	A user request from the session with SPID 250 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.

Open in new window


any reason for that ?

we just rans the checkdb for all user database but there are 0 error ,any idea of this ?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I'm good ty. I've been on vacation and slowly back into EE :)

"What's the SQL Server and Windows Server versions?"
How long the SQL Server instance were running until this error appear?
What else is installed in the server?
0
 
marrowyungAuthor Commented:
"I'm good ty. I've been on vacation and slowly back into EE :)"

 me too, that;s why I start picking up ticket only since last week.

"How long the SQL Server instance were running until this error appear?"

since 2-3 weeks ago, I only 2 weeks after this kind of message keep coming out the SQL server stopped without any reason.
"What else is installed in the server?"

not much, security endpoint agent is one of that but very little sth else.


FTP client.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You still didn't answer my main question, so for the 3rd time:
What's the SQL Server and Windows Server versions?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Better. What the following command returns?
SELECT  
SERVERPROPERTY('ProductVersion') AS ProductVersion,  
SERVERPROPERTY('ProductLevel') AS ProductLevel,  
SERVERPROPERTY('Edition') AS Edition,  
SERVERPROPERTY('EngineEdition') AS EngineEdition
SERVERPROPERTY('BuildClrVersion')  AS BuildClrVersion

Open in new window

0
 
marrowyungAuthor Commented:
I just answer another ticket but I don't think it is related.

SQL 2008 with SP4 and Windwos server 2008 R2.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Not all people follow all your questions and we can't also guess if they are related or not.

What the following query returns?
SELECT  SERVERPROPERTY('BuildClrVersion')  AS BuildClrVersion

Open in new window

0
 
marrowyungAuthor Commented:
"Not all people follow all your questions and we can't also guess if they are related or not."

 you are right... I just guess you in the loop....

but it really not related  I think.


v2.0.50727
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You have SQL Server 2008 SP4 that uses .NET Framework 2.0 SP2 (v2.0.50727).
The error message is complaining about .NET Runtime version : 4.0.40305.0. That's what SQL Server 2012 needs.

So the question is:
- Are you using any SQL Server 2012 to connect to this SQL Server 2008 instance?
0
 
marrowyungAuthor Commented:
no...
0
 
marrowyungAuthor Commented:
we run that SQL server for a long time and it only happen these few weeks.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Well, there's always changes.
By the error message:
"DESCRIPTION:      A user request from the session with SPID 250 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory."
I would say there's some request that's trying to execute code that needs .NET Framework 4.0

Btw, where are you sending the log shipping to?
0
 
marrowyungAuthor Commented:
"Btw, where are you sending the log shipping to?"

another DR server.

"I would say there's some request that's trying to execute code that needs .NET Framework 4.0"

yes, but why suddently ?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
another DR server.
With the same SQL Server version, I guess.

yes, but why suddently ?
That's your job to find what changed (any new application feature? New process in the house? ...). I think you should start asking development teams what they released during these period.
0
 
marrowyungAuthor Commented:
Victor,

"With the same SQL Server version, I guess."

yes.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
So only thing that stays to be analyzed is with development area. Try to have a conversation with them to verify what they've changed during these last days.
0
 
marrowyungAuthor Commented:
"I would say there's some request that's trying to execute code that needs .NET Framework 4.0"

so it is about sth connect that SQL server 2008 box and try to run code relies on .net 4.0 ?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I can't confirm nothing as you know I don't have access to your environment.
That was only a guess but without you investigate further only thing we can do here is guessing.
0
 
marrowyungAuthor Commented:
victor,

I knew, but just want to know the overall concept of that.
0
 
marrowyungAuthor Commented:
tks anyway.
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 11
  • 10
Tackle projects and never again get stuck behind a technical roadblock.
Join Now