473,888 Members | 1,564 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Sql Server Backup - Remote -> Local

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?


Jul 23 '05 #1
1 3271
mbailey (ma*********@gm ail.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****@sommarsk og.se

Books Online for SQL Server SP3 at
Jul 23 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Jol | last post by:
This is more of a fyi than a question. After restoring a live db backup to our development server there was an identically named login Melb02 on both the db server and in the restored db backup. However if you log in as Melb02 on the server you cannot access any objects owned by Melb02 on the restored db, without putting Melb02.<object_name> in front. This would break our app so we needed a workarround. The mssql docs say that first...
by: Serdar Yegulalp | last post by:
I'm in the process of migrating a lot of data (millions of rows, 4GB+ of data) from an older SQL Server 7.0 database to a new SQL Server 2000 machine. Time is not of the essence; my main concern during the migration is that when I copy in the new data, the new database isn't paralyzed by the amount of bulk copying being one. For this reason, I'm splitting the data into one-month chunks (the data's all timestamped and goes back about 3...
by: Chris Gatto | last post by:
Hello, My organization is currently considering the purchase of a new intranet application server and we are looking for opinions from those who have been down this road before. In brief the server must support the following: - 600+ users using various ASP.Net based applications, only 2 currently but growing over time as old legacy apps are converted; - Some applications are mission critical, others not so much; - DB back-end is a...
by: shenanwei | last post by:
I have a primary server and backup server located in different physical sites. The primary server is live and ship logs to backup site every 5 minutes. The primary server is being full online backed up every sunday locally. Those logs are being applied to backup server every five minutes. For example, Primary site has power outage on tuesday, the last log was shipped was S0001000.LOG. Backup server was brought to live, the first active...
by: Lyle Fairfield | last post by:
I have a tiny db on a remote sql server. The owner of the sever backs up the db daily, but these backups are not freely available to me. I want my data (only my data) backed up in some form that is accessible to me. I have an adp. It exists only to connect to the remote db. I have an mdb. It has a form. The form opens on the db’s opening. This is the code behind the form. It zaps any tables in the mdb. It examines the tables in the adp....
by: alanknipmeyer | last post by:
Hi, I`m in the process of migrating a Access 2002 (Run in 2000 mode) from Windows 98 to Win2K Server. It is a shared resource via a file share on the 98 Server. Client systems are Win98 with the shared drive mounted and the application run via the shared drive. I have tried once before, but came across some file locking issues. I thought i had addressed these file locking issues, but it came apparent I hadn't when data started to get...
by: TC | last post by:
Hello All, I apology for posting to many groups but I wasn't sure which group would be best targeted with my question. I have inherited an ASP.Net application that requires some maintenance & bug fixes. I have been asked to also download a copy of the remote SQL Server database that it uses on the background for potential maintenance and changes as well.
by: Chuck B | last post by:
I am modifying remote registries for about 150 computers. Is there any easy way in C# to do a remote registry backup?
by: sathish | last post by:
i dont know how to install the remote server in Veritas Backup Exec Server 10d. its symantec's product. if anyone knows pls reply me yaar. Sathish.N.
by: AAaron123 | last post by:
I need to move a database from sql server 2008 to sql express 2008. Will backing up the sql server 2008 database to a file and then using that file to restore to sql express 2008 work? I don't have express on my machine so I can't simply try to see if it works. If I do do it, sql server will be on my machine and sql express will be remote.
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.