Multi-Server Maintenance Plans in SQL Server 2019

  • Hello all!  I hope you're all staying safe and well!  So I've set up Multi-Server Administration in my environment so that I can just quickly add new target servers to my already created Maintenance Plans.  I've created a Multi-Server Maintenance Backup plan to backup user databases nightly.  However, it doesn't seem to be intelligent enough to identify and use the target server databases when running the plan on the target server.  Does that make sense?  It basically sends out the the job to all of the target servers, but they try to backup the Master server databases.  What am I missing?

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

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

  • For the main job you've set up, did you check all databases or all user databases?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply