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
2 answers
48 views

How to Update and Manage Millions of Databases

We are looking to shard our application, so that each customer has their own database. The data contents of all databases are different, but the structure is the same for all customers. Imagine there ...
1 vote
1 answer
193 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 ...
  • 11
0 votes
1 answer
80 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 ...
  • 25
1 vote
1 answer
145 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 ...
  • 25
3 votes
3 answers
593 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 ...
  • 1,490
0 votes
1 answer
134 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
2 answers
365 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
1 answer
418 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
1 answer
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 - ...