|
Home > Archive > MS SQL Server Tools > March 2006 > SQL 2005 Target Server Connection vs. Local Server Connection
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL 2005 Target Server Connection vs. Local Server Connection
|
|
| bwalke@lbrspec.com 2006-03-13, 1:23 pm |
| 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
| |
| Rick Byham [MS] 2006-03-17, 11:23 am |
| 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.
<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
>
|
|
|
|
|