I have a maintenance plan which consist db full backup and log backup ( in two subplans), I execute both on SQL agent, and both failed.
The DB Log Backup :

DB FULL BACKUP LOG:

any ideas ?and I couldn't find any output to SQL log folder.~~~~~

1)%Program-Files%\Microsoft SQL Server\MSSQL.1MSSQL\LOG\ERRORLOG 

MSSQL.1MSSQL instance name 

2) EXEC sp_readerrorlog 1, 1, 'error'

This procedure takes four parameters:

1. Value of error log file you want to read: 0 = current, 1 = Archive #1, 2 = Archive #2, etc...
2. Log file type: 1 or NULL = error log, 2 = SQL Agent log
3. Search string 1: String one you want to search for
4. Search string 2: String two you want to search for to further refine the results

If you do not pass any parameters this will return the contents of the current error log.

check disk size is sufficient .

• Proposed as answer by Dinesh Vishe 18 hours 59 minutes ago

1)%Program-Files%\Microsoft SQL Server\MSSQL.1MSSQL\LOG\ERRORLOG 

MSSQL.1MSSQL instance name 

2) EXEC sp_readerrorlog 1, 1, 'error'

This procedure takes four parameters:

1. Value of error log file you want to read: 0 = current, 1 = Archive #1, 2 = Archive #2, etc...
2. Log file type: 1 or NULL = error log, 2 = SQL Agent log
3. Search string 1: String one you want to search for
4. Search string 2: String two you want to search for to further refine the results

If you do not pass any parameters this will return the contents of the current error log.

check disk size is sufficient .

• Proposed as answer by Dinesh Vishe Monday, April 20, 2015 12:06 PM

1)%Program-Files%\Microsoft SQL Server\MSSQL.1MSSQL\LOG\ERRORLOG 

MSSQL.1MSSQL instance name 

2) EXEC sp_readerrorlog 1, 1, 'error'

This procedure takes four parameters:

1. Value of error log file you want to read: 0 = current, 1 = Archive #1, 2 = Archive #2, etc...
2. Log file type: 1 or NULL = error log, 2 = SQL Agent log
3. Search string 1: String one you want to search for
4. Search string 2: String two you want to search for to further refine the results

If you do not pass any parameters this will return the contents of the current error log.

check disk size is sufficient .

• Proposed as answer by Dinesh Vishe Monday, April 20, 2015 12:06 PM

1)%Program-Files%\Microsoft SQL Server\MSSQL.1MSSQL\LOG\ERRORLOG 

MSSQL.1MSSQL instance name 

2) EXEC sp_readerrorlog 1, 1, 'error'

This procedure takes four parameters:

1. Value of error log file you want to read: 0 = current, 1 = Archive #1, 2 = Archive #2, etc...
2. Log file type: 1 or NULL = error log, 2 = SQL Agent log
3. Search string 1: String one you want to search for
4. Search string 2: String two you want to search for to further refine the results

If you do not pass any parameters this will return the contents of the current error log.

check disk size is sufficient .

• Proposed as answer by Dinesh Vishe Monday, April 20, 2015 12:06 PM

 I need to change the SID of the plan after save:

when using  B8C1F1D1-5048-48C2-91E9-40A96AF890D6, it works again.

However when I change any thing on the mainplan/or just open and save in MSSMS, the sid of the plan change again, and the job failed:

i have try many method~~ regen the SID, re import~~ at last only change back the SID of the plan to

B8C1F1D1-5048-48C2-91E9-40A96AF890D6

worksS~~~~~~~

• Marked as answer by Katherine XiongMicrosoft contingent staff, Moderator 37 minutes ago

i have try many method~~ regen the SID, re import~~ at last only change back the SID of the plan to

B8C1F1D1-5048-48C2-91E9-40A96AF890D6

worksS~~~~~~~

• Marked as answer by Katherine XiongMicrosoft contingent staff, Moderator Tuesday, April 21, 2015 6:28 AM

i have try many method~~ regen the SID, re import~~ at last only change back the SID of the plan to

B8C1F1D1-5048-48C2-91E9-40A96AF890D6

worksS~~~~~~~

• Marked as answer by Katherine XiongMicrosoft contingent staff, Moderator Tuesday, April 21, 2015 6:28 AM

i have try many method~~ regen the SID, re import~~ at last only change back the SID of the plan to

B8C1F1D1-5048-48C2-91E9-40A96AF890D6

worksS~~~~~~~

• Marked as answer by Katherine XiongMicrosoft contingent staff, Moderator Tuesday, April 21, 2015 6:28 AM

Hi sakurai_db,

Have you tried the suggestion in the thread below:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/69a74236-32dd-479f-bdc7-e449851015d9/maintenance-plan-subplan-failed?forum=sqlintegrationservices#d581cd58-86f2-4a5d-9294-c20dff42d419

Thanks,
Katherine Xiong

this is not quite related~~

now the main problem is ~ I have created a main plan on one SQL 2008, using managment studio. now I would like to migrate to another server so that I won't repeat the complex step .

The is the steps of what I did:

1. Open Visual Studio 2008

2. Create integration project.

3. Import the SSIS package ( the maint plan)

4. Change the connection in the connection manager, to point to target server

5. save it as the .dtsx

6. Put this file to another server

7. Connect to Integrated Service using SSMS, import the .dtsx.

8. Maint plan imported, once imported I need to connect to the database engine using SSMS, to set the schedule of each subplan again.

9. When running the job.. it fails.....

For error, can refer to the top of the post. Anything wrong with my steps?

Hi sakurai_db,

It is my pleasure to help you to reflect your recommendation to the proper department for their consideration.
Please feel free to submit your situation on our product to the following link https://connect.microsoft.com/SQLServer/. Your feedback is valuable for us to improve our products and increase the level of service provided.

Thanks,
Katherine Xiong