SQL 2005 Target Server Connection vs. Local Server Connection

13 Mar 2006 5:23 PM

bwalke

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

17 Mar 2006 5:00 PM

Rick Byham [MS]

Local 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.

<bwa***@lbrspec.com> wrote in message

Show quote

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
>

16 May 2006 6:37 PM

Robin HC

Rick,

You might know the answer to this question.
Can I enlist a SQL Server 2000 Standard server as a target server to a SQL
Server 2005 master server?

Robin HC

Show quote

"Rick Byham [MS]" wrote:

> Local 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.
>
> <bwa***@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
> >
>
>
>

17 May 2006 4:13 PM

Rick Byham [MS]

The system has always been that the targets must be at least the version of
the master. Otherwise the master could try to do something that is
unsupported on lower level targets. The master can be a lower version. When
upgrading, upgrade the targets first, and then the master. Yeah, the system
could probably be improved.

--
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.

Show quote

"Robin HC" <Robi***@discussions.microsoft.com> wrote in message
news:DA555A9F-9E41-4647-9A5A-12F31BE1AD02@microsoft.com...
> Rick,
>
> You might know the answer to this question.
> Can I enlist a SQL Server 2000 Standard server as a target server to a SQL
> Server 2005 master server?
>
> Robin HC
>
> "Rick Byham [MS]" wrote:
>
>> Local 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.
>>
>> <bwa***@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
>> >
>>
>>
>>