July 28, 2012 at 11:55 pm
xecuting query "DECLARE @GUID UNIQUEIDENTIFIER
EXECUTE msdb..sp".: 100% complete End Progress Error: 2012-07-29 15:00:32.68
Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task
Description: Executing the query "EXECUTE master.dbo.xp_create_subdir N'\\aunsgdcsql30\sqlbackup\inst_14_Java_Apps_PRD\TRN\ims' "
failed with the following error: "xp_create_subdir() returned error 123, '
The filename, directory name, or volume label syntax is incorrect.'".
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly
, parameters not set correctly, or connection not established correctly.
End Error Error: 2012-07-29 15:00:32.71 Code: 0xC002F210
Source: Back Up Dat... The package execution fa... The step failed.
my transanction log are failing due to these error need help ...
suggest for these what may be the reason.
July 29, 2012 at 9:25 pm
shrishasqldba (7/28/2012)
xecuting query "DECLARE @GUID UNIQUEIDENTIFIEREXECUTE msdb..sp".: 100% complete End Progress Error: 2012-07-29 15:00:32.68
Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task
Description: Executing the query "EXECUTE master.dbo.xp_create_subdir N'\\aunsgdcsql30\sqlbackup\inst_14_Java_Apps_PRD\TRN\ims' "
failed with the following error: "xp_create_subdir() returned error 123, '
The filename, directory name, or volume label syntax is incorrect.'".
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly
, parameters not set correctly, or connection not established correctly.
End Error Error: 2012-07-29 15:00:32.71 Code: 0xC002F210
Source: Back Up Dat... The package execution fa... The step failed.
my transanction log are failing due to these error need help ...
suggest for these what may be the reason.
The error message is misleading, it has nothing to do with syntax. Check to make sure the account running the job (who owns the job? Are you using a proxy for the job step?) has permissions to the directory referenced in the command.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply