Tell me more ×
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. It's 100% free, no registration required.
up vote 2 down vote favorite

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 stackoverflow.com Oct 6 '12 at 9:06

2 Answers

up vote 3 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).

UPDATE:

MSDN Documentation here: http://msdn.microsoft.com/en-us/library/ms180992.aspx

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
up vote 1 down vote

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

 
discard

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.