SQL Server creation and maintenance plan failure (SQL Server: 14234 error) solution, sql14234

SQL Server creation and maintenance plan failure (SQL Server: 14234 error) solution, sql14234

Start with a server, specifically a cloud host, where the environment is pre-configured. However, when configuring scheduled tasks, it is found that the scheduled backup of mssql2005 cannot be performed and an error is reported:
Copy codeThe Code is as follows:
Sqlserver failed to create Maintenance Plan (SQL Server: 14234 error) automatic backup of database plan

Error message:
Copy codeThe Code is as follows: creation of JobStep 'testbak' fails. (Microsoft. SqlServer. MaintenancePlanTasks)
An exception occurred when executing a Transact-SQL statement or batch processing. (Microsoft. SqlServer. ConnectionInfo)
The specified '@ subsystem' is invalid (the valid value is returned by sp_enum_sqlagent_subsystems ). (Microsoft SQL Server, error 14234)

I tried to compress the file directly, so that we can append the file to restore it. However, the database needs to be disabled each time it is compressed, so it is passed.

Do you want to use other software? With navicat for ms SQL, the results are not very good, back up is SQL, not very friendly FOR transfer.

Let's fix it. If you want to solve this problem, you 'd better use the built-in functions.

Solution:
1. Run the SQLServer2005 Installation Wizard.
2. After scanning, click Next on the System Configuration check page.
3. In the Name box and company box, enter the appropriate information and click Next.
4. Click to select the IntegrationServices check box, and then click Next. (This is the most important thing. Others can be ignored ..)
5. Click next and then click Install.
6. After the installation is complete, click next and then click Finish.
It took a little time for the download, but it was finally completed and the scheduled task was completed. Do you want to tell the cloud host provider? Now let me think about it .... Haha ....

SQL SERVER 2008 failed to execute the maintenance plan

Yes ?!
What do you mean? No matter whether the Agent is enabled or not, why ?!
 
SQL2005 database creation and maintenance plan failed

For the Sql2005 database, the stability is not very good .!

An error message is displayed when saving the job plan attributes,
For the application server, JOB "xx is the Plan Name xx" failed

This is caused by server instability .!

Restart. And it will be okay ..