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
20 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 ...
2
votes
2answers
187 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
80 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
182 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
255 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
1k 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 - ...