fatinnadiah88 (1/13/2013)

---

Anyone have any idea why I receive this error on SQL job?

Step ID 1
Server SRIN_SVRA
Job Name 1 Year Backup Maintain BDSBPM.Subplan_1
Step Name Subplan_1
Duration 00:00:34
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

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! :)