469,346 Members | 6,542 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,346 developers. It's quick & easy.

Sql Server Backup - Remote -> Local

Hello-
I have a Sql Server 2000 database offsite that I would like to back up
to a local machine. I am using Enterprise Manager on a local machine to
administer the remote db.

Whats the best way to schedule backups so the remote db is backed up to
the local machine?

Can this be done in Enterprise Manager?
Would you recommend any 3rd party software?

Thanks!
MB

Jul 23 '05 #1
1 3050
mbailey (ma*********@gmail.com) writes:
I have a Sql Server 2000 database offsite that I would like to back up
to a local machine. I am using Enterprise Manager on a local machine to
administer the remote db.

Whats the best way to schedule backups so the remote db is backed up to
the local machine?

Can this be done in Enterprise Manager?
Yes, you would have to schedule the job so that it runs against the
remote server. (But you could have the job run through the local
SQL Server Agent, though.)

But there is one requirement: the remote SQL Server must have write
access to the disk where you want the backup to end up. First of all,
this means that the remote server must run under a domain account; it
cannot run under Local System.

Since your server is offsite, it is not obvious that the remote
server has access to your local box. And in any case, if the network
connection is not the best, it may not be a good idea anyway.

In such case you will have to explore other options, such as backing
up to disk local to the remote server, and then get the files with FTP.
The job could still be initiated from your local server, though.
Would you recommend any 3rd party software?


The two most commonly used 3rd party tools are SQL Litespeed from
Imceda and UltraBac. I believe that they are mainly of interest for
large databases from 100 GB where backup times can be considerable.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Chris Gatto | last post: by
10 posts views Thread by Lyle Fairfield | last post: by
4 posts views Thread by Chuck B | last post: by
2 posts views Thread by sathish | last post: by
6 posts views Thread by AAaron123 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.