Take the 2-minute tour ×
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.

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

share|improve this question
add comment

migrated from stackoverflow.com Oct 6 '12 at 9:06

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

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
add comment

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
add comment

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.