April 26, 2018 at 1:28 am
Hello guys,
I have a strange issue this morning when try to start backup job i receive this error.I try to change the user owner which execute job with sa it doesn't work also i cheked the security policy of the folder it's okay . What is this error.
Thank you
Message
Executed as user: NT SERVICE\SQLSERVERAGENT. Common language runtime (CLR) execution is not supported under lightweight pooling. Disable one of two options: "clr enabled" or "lightweight pooling". [SQLSTATE 42000] (Error 5846). The step failed.
April 26, 2018 at 2:15 am
iseedeadpeople - Thursday, April 26, 2018 1:28 AMHello guys,
I have a strange issue this morning when try to start backup job i receive this error.I try to change the user owner which execute job with sa it doesn't work also i cheked the security policy of the folder it's okay . What is this error.
Thank youMessage
Executed as user: NT SERVICE\SQLSERVERAGENT. Common language runtime (CLR) execution is not supported under lightweight pooling. Disable one of two options: "clr enabled" or "lightweight pooling". [SQLSTATE 42000] (Error 5846). The step failed.
Are there any more details in the SQL Server Error Log or the SQL Server Agent Log?
😎
How are you running the backup?
April 26, 2018 at 2:26 am
Nothing in error log specifically. I have job with t-sql script to run every moring to backup db, Check script
DECLARE @path VARCHAR(500)
DECLARE @name VARCHAR(500)
DECLARE @pathwithname VARCHAR(500)
DECLARE @time DATETIME
DECLARE @year VARCHAR(4)
DECLARE @month VARCHAR(2)
DECLARE @day VARCHAR(2)
SET @path = 'D:\Backup\UltraPlay\'
SELECT @time = GETDATE()
SELECT @year = (SELECT CONVERT(VARCHAR(4), DATEPART(yy, @time)))
SELECT @month = (SELECT CONVERT(VARCHAR(2), FORMAT(DATEPART(mm,@time),'00')))
SELECT @day = (SELECT CONVERT(VARCHAR(2), FORMAT(DATEPART(dd,@time),'00')))
SELECT @name ='UltraPlay' + '_' + @year + @month + @day
SET @pathwithname = @path + @namE + '.bak'
BACKUP DATABASE [UltraPlay]
TO DISK = @pathwithname WITH COMPRESSION, NOINIT,SKIP, STATS = 10
April 26, 2018 at 2:41 am
Can you post the output of SELECT @@VERSION please?
😎
Has anything changed since you last ran the backup job, i.e. CU applied etc?
April 26, 2018 at 4:08 am
Yes server was shutdown not expected
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
April 26, 2018 at 4:09 am
I think sys.configuration is mess up something with this shutdown on the sever is it possible ?
April 26, 2018 at 4:35 am
iseedeadpeople - Thursday, April 26, 2018 4:09 AMI think sys.configuration is mess up something with this shutdown on the sever is it possible ?
Suggest you run DBCC CheckDB ('MYDB') WITH NO_INFOMSGS, ALL_ERRORMSGS on both system and user databases.
😎
Further, review the server configuration, i.e. select * from sys.configuration
April 26, 2018 at 8:05 am
iseedeadpeople - Thursday, April 26, 2018 1:28 AMHello guys,
I have a strange issue this morning when try to start backup job i receive this error.I try to change the user owner which execute job with sa it doesn't work also i cheked the security policy of the folder it's okay . What is this error.
Thank youMessage
Executed as user: NT SERVICE\SQLSERVERAGENT. Common language runtime (CLR) execution is not supported under lightweight pooling. Disable one of two options: "clr enabled" or "lightweight pooling". [SQLSTATE 42000] (Error 5846). The step failed.
Why do you have lightweight pooling enabled? There are plenty of reasons it is recommended to leave it disabled.
Sue
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply