SQL Server Maintenance plan job failed

0

I have created a maintenance plan to backup database, recently after a server reboot, the maintenance plan started to failed. I have recreated back the job but it's still failing with same error below. I know I can use other way to backup database but I want to know why it's failing with maintenance plan.

Message Executed as user: MTRADE\svc_eforex. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 5:09:30 PM Error: 2020-05-05 17:09:45.76 Code: 0xC00291EC Source: {EDE87A0E-6D01-4C6C-BE30-10DCFB40ED52} Execute SQL Task Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Error: 2020-05-05 17:10:00.31 Code: 0xC0024104 Source: Back Up Database (Full) Description: The Execute method on the task returned error code 0x80131904 (A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Error: 2020-05-05 17:10:14.85 Code: 0xC0024104 Source: {CA2864D8-321C-4C00-9E9A-3DE24396F7C2} Description: The Execute method on the task returned error code 0x80131904 (A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)). The Execute method must succeed, and indicate the result using an "out" parameter. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:09:30 PM Finished: 5:10:14 PM Elapsed: 44.062 seconds. The package execution failed. The step failed.

Maintenance Plan

sql-server
maintenance-plan
asked on Stack Overflow May 5, 2020 by dharma seelan • edited May 5, 2020 by Dale K

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0