Backup remote database -- sql server mseq

Jojamie
5/15/2007 8:24:01 AM

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.

JPD
7/17/2007 12:00:00 AM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server mseq

sql server mseq : Backup remote database