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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy