Is there a way to use the transact sql command to backup a database from a
remote server to your local drives?

ie: DBServ1 backup from dbServ2.DBx to localdisk?

Or do I have to run Backup Database on the respective machine?

Thanks

Kevin

Report this post to a moderator

Kevin,

>Is there a way to use the transact sql command to backup a database from a
>remote server to your local drives?
>
>ie: DBServ1 backup from dbServ2.DBx to localdisk?
>
>Or do I have to run Backup Database on the respective machine?

The BACKUP command, like all SQL Server commands, is executed on the
server. The server doesn't have any knowledge of the hardware from
which the SQL command originated; though you submitted the command
from your local machine, it has no contact with that machine other
than the SQL connection, and does not see any drives.

You can backup the database to your local machine IF you can define a
share on that machine, and IF the account under which SQL Server is
executing has rights to that share, something like:

BACKUP DATABASE X
TO DISK = '\\yourlocalmachine\yoursharen
ame\somedir\X.bkp'

Roy

Report this post to a moderator

Kevin,

Depends on what you mean by Remote Server. Well if you can connect to the
server using Query Analyzer and execute the backup command you can point
the backup to go to a share on your local drives .

If by Remote server you mean you are connecting to Server A but wanting to
do a backup of a database on Server B, then the way would be to create a
stored proc or something on Server B, and use a remote procedure call or a
linked server or something on those lines to call execute the backup.


Denzil Ribeiro
Microsoft SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program
and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------
| From: "Kevin Antel" <kevina@cqlcorp.com>
| Subject: Backup across servers
| Date: Tue, 25 Jun 2002 14:50:50 -0400
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
| Message-ID: <ey3tekHHCHA.2652@tkmsftngp11>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 63.88.189.251
| Path: cpmsftngxa07!tkmsftngp01!tkmsf
tngp11
| Xref: cpmsftngxa07 microsoft.public.sqlserver.server:217783
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Is there a way to use the transact sql command to backup a database from a
| remote server to your local drives?
|
| ie: DBServ1 backup from dbServ2.DBx to localdisk?
|
| Or do I have to run Backup Database on the respective machine?
|
| Thanks
|
| Kevin
|
|
|

Report this post to a moderator