September 18, 2009 at 7:55 am
Hi Team
I am using Litespeed to configure the Backup for databases. Sometimes it throws such error as below while running thru SQL Agent jobs for unknown reasons. Can you please tell me what could be the error ?
" Quest slssqlmaint Utility. Logging on to SQL Server ''Servername'' with Windows Authentication Logged on to SQL Server 'Servername' select plan_id, plan_name, max_history_rows, remote_history_server, max_remote_history_rows from msdb.dbo.sysdbmaintplans where plan_id = '4899F231-0454-4EF3-936D-9C5951B5092F' Starting maintenance plan 'LiteSpeed Backup CVBankEvalArchiveDb' on 9/18/2009 8:44:56 AM select top 1 database_name from msdb.dbo.sysdbmaintplan_databases where plan_id = '4899F231-0454-4 slssqlmaint failed [SQLSTATE HY000] (Error 50000). The step failed.
"
September 18, 2009 at 11:18 am
Quest, the LiteSpeed creater, resolved this issue:
http://support.quest.com/Portal/Logon.asp?redir=/SUPPORT/index?page=solution&id=SOL40753
September 22, 2009 at 3:07 am
It has been told that issue had been fixed in 5.0.0.1068 but we are using 5.0.0.3, Still the issue Persists.? But while we do manually ,it is running fine.
--------------------------------------------------
LiteSpeed Backups fail because the subdirectory cannot be created if a Maintenance Plan uses a UNC pathor remote location.
ResolutionFixed in 5.0.0.10068 version of LiteSpeed
WORKAROUND: Create the folder manually and direct the LiteSpeed backups to that folder
--------------------------------------------------
September 22, 2009 at 4:29 am
So what are you doing at the moment then, are you creating the sub folders manually then?
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
November 11, 2010 at 12:44 am
i am getting the same error, did creating subdirectory resolved the issue?
please reply. need your help.
April 20, 2011 at 8:40 pm
Hi Guys..
Good day to you..
I am having Litespeed 5.1.1.1203. My backup jobs are failing with below error. I can able to take manually backup. Can somebody help me on this issue.
"Microsoft (R) SQL Server Execute Package Utility Version 10.0.4000.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 04:28:44 Progress: 2011-04-21 04:28:46.75 Source: {FBA87534-6DB5-4AC9-8B3E-81D728AD7B7C} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2011-04-21 04:28:50.35 Code: 0xC002F210 Source: Back Up Database 1 Execute SQL Task Description: Executing the query "execute master..xp_slssqlmaint '-D "SP_MyLink_Dev_..." failed with the following error: "slssqlmaint failed". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 04:28:44 Finished: 04:28:50 Elapsed: 6.162 seconds. The package execution failed. The step failed."
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply