Backup remote database

Hi All

I am trying to write a SQL statement to use in an automated process which
will run on a SQL 2005 server and backup a remote database from another SQL
server.
From there I am trying to then restore this remote database backup into the
local "Copy" database.
For some reason everytime I run the Backup part of the SQL query it fails
with a connection refused error.

Could someone provide me with a SQL statement that would backup this remote
database.

Cheers.

Hi,

The answer is quite simple really. You cannot backup a database from a
remote server. You need to be connected to it directly. The client
app, whether it's Management Studio, sqlcmd or a 3rd party app, can be
on a remote machine but it must make a connection directly to the server
conatining the database you want to backup.

If I misunderstood what you are trying to do please let me know.

Jonathan



Jojamie wrote:
> Hi All
>
> I am trying to write a SQL statement to use in an automated process which
> will run on a SQL 2005 server and backup a remote database from another SQL
> server.
> From there I am trying to then restore this remote database backup into the
> local "Copy" database.
> For some reason everytime I run the Backup part of the SQL query it fails
> with a connection refused error.
>
> Could someone provide me with a SQL statement that would backup this remote
> database.
>
> Cheers.