July 26, 2012 at 9:40 am
We are using Litespeed(version 6.5.2.1042) for our backups. Just recently we started getting the following error message:
Quest.LiteSpeed.UI.Wrappers.UIHistoryItemMessage:
Executed as user: XXXXXXX\XXXXX. ...on 9.00.5000.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:35:00 AM Progress: 2012-07-25 00:35:02.83 Source: {C7E375BC-DBF2-4E65-A08A-256169B6AB20} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp_ma".: 100% complete End Progress Error: 2012-07-25 00:35:04.56 Code: 0xC002F210 Source: Back Up Database 1 Execute SQL Task Description: Executing the query "execute master..xp_slssqlmaint N'-D "ALL SYSTEM DATABASES" -BkUpMedia DISK -DelBkUps 4DAYS -BkUpDB "\\XXXXXXX\r$\XXXXXXX\FULL\Litespeed_Backups" -CrBkSubDir -BkExt "bak" -Exclude Offline LogShippng -NOOPTOLR -CompressionLevel 3 -Logging 0 -Default "%D_%T_%Y-%m-%d-%H%M%S.%EXT%" -LogEngine 0 -RunId "7A59A9C9-E0D5-40A8-AED9-CD09700971BA" "Back Up Database 1 (XXXXXXX\XXXXXXXXX)" -NO_OUTPUT '" failed with the following error: "Unable to create backup sub directory "\\XXXXXXX\r$\XXXXXXX... The package execution fa... The step failed.
Does anyone know how to resolve this issue?
July 26, 2012 at 10:03 am
msjust (7/26/2012)
We are using Litespeed(version 6.5.2.1042) for our backups. Just recently we started getting the following error message:Quest.LiteSpeed.UI.Wrappers.UIHistoryItemMessage:
Executed as user: XXXXXXX\XXXXX. ...on 9.00.5000.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:35:00 AM Progress: 2012-07-25 00:35:02.83 Source: {C7E375BC-DBF2-4E65-A08A-256169B6AB20} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp_ma".: 100% complete End Progress Error: 2012-07-25 00:35:04.56 Code: 0xC002F210 Source: Back Up Database 1 Execute SQL Task Description: Executing the query "execute master..xp_slssqlmaint N'-D "ALL SYSTEM DATABASES" -BkUpMedia DISK -DelBkUps 4DAYS -BkUpDB "\\XXXXXXX\r$\XXXXXXX\FULL\Litespeed_Backups" -CrBkSubDir -BkExt "bak" -Exclude Offline LogShippng -NOOPTOLR -CompressionLevel 3 -Logging 0 -Default "%D_%T_%Y-%m-%d-%H%M%S.%EXT%" -LogEngine 0 -RunId "7A59A9C9-E0D5-40A8-AED9-CD09700971BA" "Back Up Database 1 (XXXXXXX\XXXXXXXXX)" -NO_OUTPUT '" failed with the following error: "Unable to create backup sub directory "\\XXXXXXX\r$\XXXXXXX... The package execution fa... The step failed.
Does anyone know how to resolve this issue?
Find out why this error occurred:
Back Up Database 1 (XXXXXXX\XXXXXXXXX)" -NO_OUTPUT '" failed with the following error: "Unable to create backup sub directory "\\XXXXXXX\r$\XXXXXXX...
Could be permissions, lack of space, something else. Check the the other system logs to see what you can learn.
July 26, 2012 at 10:17 am
I don't see anything in the event log besides database failed. It doesn't give me any details and we have 2 TB of free space on that drive.
July 26, 2012 at 10:23 am
The error message says it couldn't create the backup subdirectory. That leads me to a space issue or a permissions issue. Not much else I can suggest.
July 26, 2012 at 10:32 am
Ok, thanks for your response.
July 26, 2012 at 4:13 pm
msjust (7/26/2012)
"Unable to create backup sub directory "\\XXXXXXX\r$\XXXXXXX...
You're using a windows administrative share and unless the SQL server agent account is a local admin on server \\xxxxxxxxxxx the r$ share will be unavailable.
Create a new share and be sure to give the agent account the appropriate share and ntfs permissions as when the 2 combine the most restrictive applies 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 26, 2012 at 4:51 pm
Agreed with Perry.
Moreover, if you have cluster situation and you are using drives or MPs of different node then both servers should be on the same cluster node.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply