Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The package execution returned DTSER_FAILURE (1) Expand / Collapse
Author
Message
Posted Monday, September 2, 2013 2:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 3:52 AM
Points: 2, Visits: 66
Hi

I am having a problem when running a maintenance plan(full database backup) in my environment as i get the error bellow.
I have recreated the backup plan but still get that error.

Message
Executed as user: Nombert\SQLCCL01. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 09:49:13 AM Progress: 2013-09-02 09:49:14.78 Source: {B4178225-76AA-4D5D-9F6D-3EEEE53B656D} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2013-09-02 09:49:14.84 Source: Maintenance Cleanup Task Executing query "EXECUTE master.dbo.xp_delete_file 0,N'J:\MSSQL10_5...".: 100% complete End Progress Progress: 2013-09-02 09:49:15.17 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'J:\MSSQL10_5...".: 25% complete End Progress Progress: 2013-09-02 09:49:15.17 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'J:\MSSQL10_5...".: 50% complete End Progress Progress: 2013-09-02 09:49:15.17 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'J:\MSSQL10_5...".: 75% complete End Progress Progress: 2013-09-02 09:49:15.17 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'J:\MSSQL10_5...".: 100% complete End Progress Progress: 2013-09-02 09:49:15.78 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [master] TO DISK = N'J:\MSSQL10_5...".: 100% complete End Progress Progress: 2013-09-02 09:49:16.18 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [model] TO DISK = N'J:\MSSQL10_50...".: 100% complete End Progress Progress: 2013-09-02 09:49:17.42 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [msdb] TO DISK = N'J:\MSSQL10_50....".: 100% complete End Progress Error: 2013-09-02 09:49:17.56 Code: 0xC002F210 Source: Back Up Database (Full) Execute SQL Task Description: Executing the query "BACKUP DATABASE [RiskAnalytics_Prod_Archive ] TO ..." failed with the following error: "Cannot open backup device 'J:\MSSQL10_50.SLQnombert\MSSQL\Backup\Full_Backup\Nombertprod ombertprod_backup_2013_09_02_094915_1589136.bak'. Operating system error 3(failed to retrieve text for this error. Reason: 15105). BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 09:49:13 AM Finished: 09:49:17 AM Elapsed: 3.681 seconds. The package execution failed. The step failed.
Post #1490551
Posted Monday, September 2, 2013 3:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:06 AM
Points: 13,274, Visits: 10,151
This is the source of the error:

Cannot open backup device 'J:\MSSQL10_50.SLQnombert\MSSQL\Backup\Full_Backup\Nombertprod ombertprod_backup_2013_09_02_094915_1589136.bak


Does the file exists? Does the user Nombert\SQLCCL01 have access to it?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1490554
Posted Monday, September 2, 2013 3:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 3:52 AM
Points: 2, Visits: 66
Yes the device the exist and the user the access.
Post #1490555
Posted Monday, September 2, 2013 4:04 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:15 AM
Points: 2,232, Visits: 2,672
There is a space in the folder path 'J:\MSSQL10_50.SLQnombert\MSSQL\Backup\Full_Backup\Nombertprod ombertprod_backup_2013_09_02_094915_1589136.bak'
Perhaps you need extra quotes arount the path/filename?


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1490573
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse