March 11, 2013 at 5:14 pm
Hello,
Does 2012 offer any feature which allows for the collection of Instance data across all my production installs? In other words, what is a good technique to centralize (for documentation)
All SSIS package (document only)
All Jobs and scheduales
All logins and database mappings
Instance configuration parameters
I can write SQL queries and run them on each server and centralize them manually...or I can deploy procedures an maintain those across all instances. But I'd like to do this with as little footprint as possible. Preferable none.
What I'd like, is a feature where one of my instances is a repository and collects this information from the servers I choose. Does this make sense? How are people doing this and is there something in 2012 to help.
SQL 2012 Standard VPS Windows 2012 Server Standard
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy