SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
SQL Maintenance full back failed notification
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 72%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jinal Contractor
121
Reputation points
Hello, I've setup maintenance plan in SSMS and I've created via SSIS package. All the maintenance job is running fine but Full backup is getting failed but I can see .bak file has created in destination folder. Can someone guide me how can i rid off this error? I went to reporting folder as well and I can't see anything about this full back file. Message Executed as user: P\SQLAdmin. Started: 2:00:00 AM Finished: 2:41:23 AM Elapsed: 2482.83 seconds. The package execution failed. The step failed.
SQL Server | Other
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 71%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERV%3C/text%3E%3C/svg%3E)
Robbie Varn 351 Reputation points2023-04-26T17:48:32.26+00:00 We need a little more information from the Maint plan log on the exact step that failed. Can you paste that in? From what you have said, the FULL backup is getting created but you are having issues reading the properties of it?
-
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator2023-04-26T20:46:33.94+00:00 Have you verified the backup by restoring it? If the job fails half-way through, the .bak file may be useless.
Anyway, in the LOG folder, you should find log files for the maintenance job where you should be able to find the full error message which explains why the log failed.
-
LiHongMSFT-4306 31,621 Reputation points2023-04-27T06:32:05.9066667+00:00 Please troubleshoot SQL Server backup and restore operations follow by this doc.
Sign in to comment
Sign in to answer