Re: Backup remote database

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.
.

Relevant Pages

  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... newsgroups so that they can be resolved in an efficient and timely manner. ...
    (microsoft.public.windows.server.sbs)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Copying a database between servers
    ... In 2000 you can backup to an UNC path ... or a local drive and the same goes for the restore. ... backup the database and then restore it on the new server. ... >>> one SQL Server 7.0 database with 'select' access to another SQL ...
    (microsoft.public.sqlserver.tools)