Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can someone explain what a 'Target Server' is in this instance. Also, what it means to "Target Multiple Servers"?

share|improve this question

migrated from Oct 6 '12 at 9:06

This question came from our site for professional and enthusiast programmers.

up vote 4 down vote accepted

A Target server allows the job to be run against a different server than the one it is defined on.

Multiple Target Servers allows you to define a job once (say a routine backup job) and have it execute against many servers (thus backing each of them up).


MSDN Documentation here:

share|improve this answer
Isn't this the same thing as going into the 'Steps' section of your job and defining what 'Database' your TSQL is going to run on? – Lloyd Banks Oct 4 '12 at 17:56
No it's managed at a more enterprise level than that. This integrates with SQL's policy based server management. Read the documentation at the link to get a clearer picture. – Ben Finkel Oct 4 '12 at 18:09

A target server is a specific location where data is stored, such as database, or a collection of databases.

A target can also be an application that provides data to be backed up.

Multiple Target Servers permit you to define a job who execute on many servers

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.