Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author

SQL 2005 Target Server Connection vs. Local Server Connection
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


Report this thread to moderator Post Follow-up to this message
Old Post
bwalke@lbrspec.com
03-13-06 06:23 PM


Re: SQL 2005 Target Server Connection vs. Local Server Connection
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
>



Report this thread to moderator Post Follow-up to this message
Old Post
Rick Byham [MS]
03-17-06 04:23 PM


Sponsored Links





Last Thread Next Thread
Post New Thread

MS SQL Server Tools archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 10:46 AM.

 
Mobile devices forum | Database support forum archive




Copyrights DropTable.com Database Support Forum 2004 - 2006