SQL job error

Question

SQL job error

fatinfzi

SSChasing Mays

Points: 634
More actions
January 13, 2013 at 8:56 pm

#287722

Anyone have any idea why I receive this error on SQL job?
Step ID1
ServerSRIN_SVRA
Job Name1 Year Backup Maintain BDSBPM.Subplan_1
Step NameSubplan_1
Duration00:00:34
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: SRIN_SVRA\SYSTEM. ...n 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:00:00 AM Progress: 2013-01-01 03:00:31.67 Source: {3F323158-B799-4D93-A0D1-508F879147AE} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Error: 2013-01-01 03:00:32.03 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "EXECUTE master.dbo.xp_create_subdir N'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\BDSBPM' " failed with the following error: "xp_create_subdir() returned error 183, 'Cannot create a file when that file already exists.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Error: 2013-01-01 03:00:32.06 Code: 0xC002F210 Source: Back Up Databas... The package execution fa... The step failed.
Thanks in advance! 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

fatinnadiah88 (1/13/2013)
Anyone have any idea why I receive this error on SQL job?
Step ID1
ServerSRIN_SVRA
Job Name1 Year Backup Maintain BDSBPM.Subplan_1
Step NameSubplan_1
Duration00:00:34
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: SRIN_SVRA\SYSTEM. ...n 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:00:00 AM Progress: 2013-01-01 03:00:31.67 Source: {3F323158-B799-4D93-A0D1-508F879147AE} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Error: 2013-01-01 03:00:32.03 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "EXECUTE master.dbo.xp_create_subdir N'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\BDSBPM' " failed with the following error: "xp_create_subdir() returned error 183, 'Cannot create a file when that file already exists.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Error: 2013-01-01 03:00:32.06 Code: 0xC002F210 Source: Back Up Databas... The package execution fa... The step failed.
Thanks in advance! 🙂

The error is in the error detail

"Cannot create a file when that file already exists"

So it looks like something had already created the file and then tried to create it again.

Sean Pearce SSCoach Points: 15999 More actions · Answer 2

Executing the query "EXECUTE master.dbo.xp_create_subdir N'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\BDSBPM' " failed with the following error: "Cannot create a file when that file already exists."

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]