Error when running sql server backup routine job

• Jeco

  SSC Enthusiast

  Points: 112

  More actions

  February 7, 2025 at 12:45 pm

  #4532127

  Guys, I am facing problems when running a backup routine JOB in SQL Server, when trying to run the JOB, it returns an error. When checking the JOB history, this message appears:

  Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 15.0.2000.5 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved. Started: 8:24:23 AM Could not load package "Maintenance Plans\BackupDiario" because of error 0x80040154. Description: Class not registered Source: Started: 8:24:23 AM Finished: 8:24:23 AM Elapsed: 0.407 seconds. The package could not be loaded. The step failed.

  From the searches I did, I understood that it could be something related to SSIS, however, checking that the service is installed and running without any problems. Has anyone faced this problem and could help me? Any help is welcome, I'm still new to SQL LMAOO

• Site Owners

  SSC Guru

  Points: 80332

  More actions

  February 8, 2025 at 1:10 pm

  #4532963

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Ken McKelvey

  SSCoach

  Points: 18882

  More actions

  February 10, 2025 at 8:14 am

  #4534030

  While better than nothing, I doubt many people use maintenance plans. I use the following:

  https://ola.hallengren.com/

  and

  https://www.brentozar.com/archive/2017/03/databaserestore-open-source-database-restore-stored-procedure/

  • This reply was modified 1 month ago by  Ken McKelvey.