March 9, 2010 at 9:32 am
Guys
I'm getting the following error when running an optimization job (reindex) on my SQL Server 2005 9.0.4211:
Date3/9/2010 12:30:25 AM
LogJob History (Optimizations Job for DB Maintenance Plan "Primary Optimizations Plan")
Step ID1
Serverxxx\SPS
Job NameOptimizations Job for DB Maintenance Plan "Primary Optimizations Plan"
Step NameStep 1
Duration00:01:48
Sql Severity19
Sql Message ID50000
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: xxx\xxx. slssqlmaint failed [SQLSTATE HY000] (Error 50000). The step failed.
This job is been triggered by Lite speed using the following version and command line:
Lite Speed Version 4.8.4.00086
EXECUTE master.dbo.xp_slssqlmaint N'-PlanID EF4536C4-3B9C-48BE-BAC7-90486F129128 -WriteHistory -RebldIdx 10 '
It was working OK since several months ago but it is failing since few days ago. Any ideas on what I should check to fix it?
March 9, 2010 at 9:46 am
Can you perform the task within SQL Server and not with the 3rd party tool (Lite Speed)?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
March 9, 2010 at 9:58 am
We are not supposed to do it directly on SQL given that we want to centralize the backups/optimizations on Lite Speed. Have you guys seen similar issues by combining SQL2005 + Lite Speed in the past?
March 9, 2010 at 10:02 am
The issue is probably with LiteSpeed. I would query their knowledge base.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
March 9, 2010 at 10:06 am
LiteSpeed probably logs errors in its own log file(s) or the application log file, check those for additional information.
March 11, 2010 at 4:20 pm
Thanks!
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply