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


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: http://msdn.microsoft.com/en-us/library/ms180992.aspx

| 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

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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