Multi server maintenance plan

Question

Hello!

After configuring my SQL1 server as master server and SQL2 as the target I've created the maintenance plan (Backup system databases) to be executed on both servers:

Here it is:

The plan is working without a single issue...

...but it does nothing on the target server - SQL2!

Furthemore, should I uncheck the "local" in the Servers window (meaning the MP would run only on the target SQL2 server)...

...the new .bak files are created only on SQL1 - not on SQL2!!!

???

Thank you in advance,
Michael

Answer 1

...tried to test it once again: set a new Master server, created a new maintenance plan (in strictly complience with the MS's official "Administering Database Infrastructure" guide) for the two servers - SQL1 and SQL2:

Again, according to the guide:

"In Object Explorer, right-click SQL Server Agent, point to Multi Server Administration, and then

click Manage Target Servers.

17. In the Target Server list, click MIA-SQL\SQL2, and then click Force Poll."

My result:

Nevertheless, the poll has already ended successfully - in spite of the error above! :

This time executing the plan does not even produce the error for the remote execution because the maintenance plan turns out to have only one target - Local server:

...no comments...

Is it a bug or am I missing anything???

Regards,
Michael