September 2, 2013 at 2:59 am
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.
September 2, 2013 at 3:07 am
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?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 2, 2013 at 3:18 am
Yes the device the exist and the user the access.
September 2, 2013 at 4:04 am
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?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply