Automating a backup job?

From: Rob Meade (robb.meade_at_NO-SPAM.kingswoodweb.net)
Date: 11/03/04


Date: Wed, 03 Nov 2004 15:26:24 GMT

Hi all,

I have SQL Server 2000 locally and remotely - I need to setup a nightly job
to copy the entire database (content at least) from the remote server to the
local server, once here I then need to backup to a couple of seperate
drives.

I can do the second part myself, as I already have this happening - but can
anyone suggest a way forward with regards to the automated nightly "import"
for want of a better phrase...

Any help appreciated.

Regards

Rob



Relevant Pages

  • Antwort: RE: Antwort: FTPing of files between remote servers.
    ... I don't have enough perl practise to tell how to do it in perl. ... If it is a perl script you need perl on the server. ... Thanks & Best Regards, ... Subject: Antwort: FTPing of files between remote servers. ...
    (perl.beginners)
  • Re: How to get TS mode Info from Registry
    ... Arvind ... > Note that this key will let you see what mode the server is in. ... >> Application Server and 2) Remote Admin. ... >> Regards, ...
    (microsoft.public.windows.terminal_services)
  • Re: Remote desktop sharing
    ... The intention was to get desktop to ... but I can even get to the server on my own system. ... Regards ... > to allow TS in Remote Admin mode in SBS2000. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Mail delivery limits problem
    ... I *am* the admin of that remote host. ... The sbs 2003 server is rejecting large mail, with an NDR as shown below. ... Regards, ...
    (microsoft.public.windows.server.sbs)
  • SecurityFocus Microsoft Newsletter #152
    ... MICROSOFT VULNERABILITY SUMMARY ... Real Networks Helix Universal Server Remote Buffer Overflow ... ... NEW PRODUCTS FOR MICROSOFT PLATFORMS ...
    (Focus-Microsoft)