Questions tagged [multi-server-admin]

Automating administration across multiple instances of SQL Server from one master instance.

Filter by
Sorted by
Tagged with
1
vote
1answer
59 views

Target server is not communicating(polling) with master SQL Server

We set up multi-server administration to create a job on the master which are executed on target servers, and we had this issue because the target server was shut down after a virus attack and we set ...
0
votes
1answer
65 views

Multiserver administration - passing maintenance plans to clustered instances

SQL Server 2019 MSX/TSX environment. TSX servers are clustered instances. MSX is not. There is a SQL integration service on each of the nodes in the cluster. I create a maintenance plan on the MSX and ...
1
vote
1answer
97 views

Multi server administration - Failed to import Maintenance Plan to named instance

I have a multi server administration environment and several maintenance plans deployed already. My MSX server is SQL2014. The problem i'm having is deploying maintenance plans to a 2008R2 named ...
3
votes
3answers
431 views

How do I check my sp_Blitz/sp_WhoIsActive versions across multiple servers/databases?

I have a bunch of SQL Servers registered within my SSMS, lots of different SQL versions, editions and DB compatibilities. I want to check out if any of those servers have any of the sp_Blitz or ...
0
votes
1answer
115 views

Output File Default Location using MultiServer Agent Jobs

I've used Ola's scripts for quite a while at several companies, and just started a new job at a company who has already implemented MultiServer Agent Jobs to execute backups, DBCC CheckDB and ...
1
vote
2answers
284 views

Combine results of Multi-Server Query from Registered Servers

Is there a way to insert result of a query executed in Registered Servers into a view / sp / table? Currently I have locally setup a Registered Server on multiple servers to query the master database ...
2
votes
1answer
382 views

Multi server administration: Job that runs both on master and targets servers?

I'm trying to set up multiserver administration on SQL Server 2016. I have two servers, one master and one target. I created a test job that does a simple select statement and then sends an email. I ...
0
votes
1answer
2k views

Issues Setting Up SQL Server - Multi Server environment

I am trying to Configure the Master target server / Multi server environment in Sql Server 2012. I changed : MSXENCryptChannnelOptions-->Changed from 2 to 0 AllowDownloadedJobsToMatchProxyName - ...