Re: Automating a backup job?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 11/03/04 

Date: Wed, 3 Nov 2004 10:28:22 -0500

Have you thought about replication and/or log shipping? 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"Rob Meade" <robb.meade@NO-SPAM.kingswoodweb.net> wrote in message
news:AM6id.5743$up1.3083@text.news.blueyonder.co.uk...
> 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

  • Re: Error running site remotely
    ... server admins to check it? ... I can't see a machine.config on the remote server using the ftp client. ... Regards ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: apostrophes in SQL statement
    ... you dont need to double them up ... "Rob Meade" wrote in message ... > I cant replicate the problem on my test server where I have just tested it ... > me testing - sat on server which is running IIS and SQL Server ...
    (microsoft.public.inetserver.asp.general)
  • Re: Validation - substitution of null with "0"
    ... Rob Meade ha scritto: ... Thank you Rob, I have to do that server side, but I can't do like your ... example as I use a formview control bounded to an objectdatasource. ... So when I have some textboxes with no values, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Can this actually be done?
    ... Rob Meade wrote: ... > one server to get data from a table in the other server... ... First, you need to define a linked server, then you can do something like: ... I recommend you put as much of the query as you can in the OPENQUERY ...
    (microsoft.public.sqlserver.programming)
  • Re: array/recordset?
    ... "Rob Meade" wrote ... ... testRS.Fields.Append "WebsiteMetaKeywords", adLongVarChar, nnn ... with regards to the nnn - does it matter what size i use here? ...
    (microsoft.public.inetserver.asp.general)