January 3, 2014 at 7:20 pm
Regarding the setup of a SQL Server "Central Mgmt Server" (CMS) -- I'm now deploying Ola Hallengren solution (Index Optimization, Full/Diff/Log backups, Integrity checks) to our servers.. 1 at a time.
If I setup the CMS mentioned above, do I still need to deploy the script / procs, 1 at a time, to each of my 100+ SQL Servers? or is there a way to deploy the procs / jobs once on a CMS instanced database and execute them dynamically against each server.. ? hope this ques makes sense...
I'm just concerned that each time the Ola H scripts / proc's change, I will need to redeploy them 100 times.
again - thanks in advance..
January 4, 2014 at 11:11 am
when you setup the central management server you can create a group and register instances. You may then execute a t-sql script against the group affecting all the registered instances
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2014 at 8:32 am
I've used an MSX server for the same function. Specifically for mass deployment of like code.
.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply