Questions tagged [multi-server-admin]

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

Filter by
Sorted by
Tagged with
-1
votes
0answers
4 views

How to combine two SSD for creating large volume?it's should be shows only one disk [closed]

I am working with SSD i need to create 16TB , I want to use four no. Of 4TB SSD . Please help me how to combine all SSD.
1
vote
1answer
45 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
316 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
104 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
233 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
330 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 - ...