InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 13:35:48 GMT20http://www.sqlservercentral.com/Forums/Topic1406556-1550-1.aspxExecuting 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."Tue, 15 Jan 2013 07:23:06 GMTSean Pearcehttp://www.sqlservercentral.com/Forums/Topic1406556-1550-1.aspx[quote][b]fatinnadiah88 (1/13/2013)[/b][hr]Anyone have any idea why I receive this error on SQL job?Step ID 1Server SRIN_SVRAJob Name 1 Year Backup Maintain BDSBPM.Subplan_1Step Name Subplan_1Duration 00:00:34Sql Severity 0Sql Message ID 0Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted 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! :)[/quote]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.Mon, 14 Jan 2013 01:40:16 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1406556-1550-1.aspxAnyone have any idea why I receive this error on SQL job?Step ID 1Server SRIN_SVRAJob Name 1 Year Backup Maintain BDSBPM.Subplan_1Step Name Subplan_1Duration 00:00:34Sql Severity 0Sql Message ID 0Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted 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! :)Sun, 13 Jan 2013 20:56:24 GMTfatinfzi