Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesI am creating Maintenance Plans in SQL Server 2005 and I was wondering what the difference is between Target Server Connection and Local Server Connection. I know this may be an unnecessary question but I was looking for a explanation of them, more less the target server. Thanks, Brett
Post Follow-up to this messageLocal Server is one type of a Target Server. Connecting to the Local Server performs the maintenance task on the same server that stores and executes the maintenance task. You can select some other server as the Target Server. Then the mainentance task is stored locally and executed on by the local server, but performs the action on the SQL Server specified as the Target. So you can create a maintenance plan on server A, that performs a backup of a database on server B. This is useful when you want one central place for your jobs that perform maintenance on a number of other servers. -- Rick Byham MCDBA, MCSE, MCSA Documentation Manager, Microsoft, SQL Server Books Online This posting is provided "as is" with no warranties, and confers no rights. <bwalke@lbrspec.com> wrote in message news:1142270627.096842.35910@e56g2000cwe.googlegroups.com... >I am creating Maintenance Plans in SQL Server 2005 and I was wondering > what the difference is between Target Server Connection and Local > Server Connection. I know this may be an unnecessary question but I > was looking for a explanation of them, more less the target server. > > Thanks, > > Brett >
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread