SQL Server backup to a remote location 
Author Message
 SQL Server backup to a remote location
Hi,
Is there any way to create a SQL Server backup to a location other than the
machine that SQL Server is running on without using a UNC path or a mapped
drive?  I was hoping the the DMO object would do this but it seems to
function in the same way as the backup command.
    Thanks,
        Wayne


Tue, 27 Sep 2005 14:38:45 GMT
 SQL Server backup to a remote location

Wayne,

You need some way to connect to the other device.  If your not using a UNC
or a mapped drive then your pretty much out of luck.  What is wrong with
using a UNC?

--

Andrew J. Kelly
SQL Server MVP


Quote:
> Hi,
> Is there any way to create a SQL Server backup to a location other than
the
> machine that SQL Server is running on without using a UNC path or a mapped
> drive?  I was hoping the the DMO object would do this but it seems to
> function in the same way as the backup command.
>     Thanks,
>         Wayne



Tue, 27 Sep 2005 15:02:41 GMT
 SQL Server backup to a remote location
The only way to access a remote data file is via Mapped drive or UNC name.
This is a Windows limitation, not a SQL limitation.  Mapped drives are not
recommended for SQL backup since SQL doesn't always see them.  The only
other way is to use a third-party backup tool such as Veritas Backup Exec to
'pull' the backup to a remote server.

--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com


Quote:
> Hi,
> Is there any way to create a SQL Server backup to a location other than
the
> machine that SQL Server is running on without using a UNC path or a mapped
> drive?  I was hoping the the DMO object would do this but it seems to
> function in the same way as the backup command.
>     Thanks,
>         Wayne



Tue, 27 Sep 2005 15:05:57 GMT
 SQL Server backup to a remote location
Andrew & Geoff,
Thanks for the reply.  That is what I thought but confirmation is always
good.  If this was a single SQL Server in an environment that I had control
over then I could just make it a UNC path but unforturnately this is a for
sale software package where I cannot depend on the customer having things in
place for two machines being able to see each other.
   Thanks again,
       Wayne


Quote:
> Hi,
> Is there any way to create a SQL Server backup to a location other than
the
> machine that SQL Server is running on without using a UNC path or a mapped
> drive?  I was hoping the the DMO object would do this but it seems to
> function in the same way as the backup command.
>     Thanks,
>         Wayne



Tue, 27 Sep 2005 15:37:22 GMT
 SQL Server backup to a remote location
In that case, you may want to put some information in the registry that
indicate the backup location.  You can then have the install app can
configure it.

--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com


Quote:
> Andrew & Geoff,
> Thanks for the reply.  That is what I thought but confirmation is always
> good.  If this was a single SQL Server in an environment that I had
control
> over then I could just make it a UNC path but unforturnately this is a for
> sale software package where I cannot depend on the customer having things
in
> place for two machines being able to see each other.
>    Thanks again,
>        Wayne



> > Hi,
> > Is there any way to create a SQL Server backup to a location other than
> the
> > machine that SQL Server is running on without using a UNC path or a
mapped
> > drive?  I was hoping the the DMO object would do this but it seems to
> > function in the same way as the backup command.
> >     Thanks,
> >         Wayne



Tue, 27 Sep 2005 19:55:59 GMT
 SQL Server backup to a remote location
If you absolutely need to get this file to another drive, you could
set up a DTS package and send it via ftp (assuming ftp services are
available on the receiving end), however you may be constrained by
your server and network security configuration.

Matt Kleczewski


Quote:
> The only way to access a remote data file is via Mapped drive or UNC name.
> This is a Windows limitation, not a SQL limitation.  Mapped drives are not
> recommended for SQL backup since SQL doesn't always see them.  The only
> other way is to use a third-party backup tool such as Veritas Backup Exec to
> 'pull' the backup to a remote server.

> --
> Geoff N. Hiten
> Senior Database Administrator
> Careerbuilder.com



> > Hi,
> > Is there any way to create a SQL Server backup to a location other than
>  the
> > machine that SQL Server is running on without using a UNC path or a mapped
> > drive?  I was hoping the the DMO object would do this but it seems to
> > function in the same way as the backup command.
> >     Thanks,
> >         Wayne



Tue, 27 Sep 2005 20:22:44 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. Sql Server backup from remote server

2. SQL Backup to remote server

3. DFS security & SQL Server remote backup

4. Local backup on remote SQL server

5. Local Backup of Remote SQL server

6. CANNOT BACKUP A LOCAL DATABASE TO A REMOTE SERVER ON SQL 7

7. Backup/Restore to Remote SQL Server

8. Creating a remote backup device under SQL Server

9. Help with Remote Backups on NT Sybase SQL Server 11.0.3

10. Suggestions on supporting SQL Database from Remote location

11. Specifying dump location for Backup Server

12. how to backup a sql server 65 server from a sql server 2000 server


 
Powered by phpBB® Forum Software