Some of database on my Maintenance Plan won't backup with an error "Operating System Error Code 3(The system cannot find the specified path)"

Question

I have this job on maintenance plan of SQL Server 2014 SP3 which backup "All databases" to a shared file of another server, but one database failed due to an error shown on my screenshot below. Note that the rest are successful and they are just using the same path, all databases are simple except for model which is full.

Error Logs

Screenshot of Maintenance Plan

Is it the last database? If so, might be worth checking that the disk doesn't get full. — DeanOC, Sep 03 '19 at 03:11

score 0 · Accepted Answer · answered Sep 03 '19 at 05:21

0

I think file path is the issue. As per the screenshot attached there is a space between your file path, which is causing error in creating as proper file path not found

Fix this and then try again, one more possibility is path not found please make sure that file path is correct. I did the same at my end and found same error code 3 as mentioned in your screenshot.

answered Sep 03 '19 at 05:21

DarkRob

3,843
1
10
27

DarkRob you are a damn good bro, my database has a white space. After removing it need to re-create the maintenenance job and now it's okay. Thank you bro. – WhitePenny Sep 03 '19 at 05:57
update the question header with error code 3, so that other people will get the help for same. – DarkRob Sep 03 '19 at 05:59

Some of database on my Maintenance Plan won't backup with an error "Operating System Error Code 3(The system cannot find the specified path)"

1 Answers1