RE: is this disaster recovery / 'high availabilty" setup OK?

From: Dave (Dave_at_discussions.microsoft.com)
Date: 10/29/04 

Date: Thu, 28 Oct 2004 19:52:01 -0700

What you want to achieve by using 2 servers ? to me using 2 servers for
accounting is not a good idea.

about backup - that is fine if you put databases in sync.

"Doug Fox" wrote:

> An accounting application uses a SQL server.
>
> I am going to use two SQL servers for this application. These two SQL
> servers are sync between them.
>
> Each night, a copy of the SQL database is copied to a network share, and
> then the backup program, ARCserve, will back up the database on the network
> share nightly.
>
> Is this approach a best practice? Any pointers/comments/suggestions are
> greatly appreciated.
>
> Thanks,
>
>
>

Relevant Pages

  • Re: Image storage - db vs filesystem (again)
    ... the table, and not make the same change to the filesystem, or vice-versa? ... Remember that even if you store the image in the database, ... that's a massive single backup task. ... servers, you have backup of the actual file data via redundancy (and you can ...
    (microsoft.public.sqlserver.programming)
  • Re: Upgrading from SBS 2003 SP1 to R2, Backup Exec 11d or System Center Data Protection Manager 2007
    ... on SBS simply because I couldn't find SBS on the list of OSes it runs on and another ... The reasons for many different flavors of SQL, ... Well, I can get into more detail, I guess I should have been more specific about the role of the many servers. ... act as a temporary backup of the SQL db in case of emergency. ...
    (microsoft.public.windows.server.sbs)
  • Re: Upgrading from SBS 2003 SP1 to R2, Backup Exec 11d or System Center Data Protection Manager 2007
    ... I've been using SBS since 1999 starting with SBS 4.5, the last few years I've been away from SBS and mainly working ... Well, I can get into more detail, I guess I should have been more specific about the role of the many servers. ... We're moving to R2 in order to setup SQL ... act as a temporary backup of the SQL db in case of emergency. ...
    (microsoft.public.windows.server.sbs)
  • Re: Next openSUSE
    ... That will not do because I add the new stuff on the backup drive. ... I take pieces (directory trees) and copy them manually. ... I would have had to use free servers of pay for, ... My guess is that CSS or whatever is causing this bug. ...
    (alt.os.linux.suse)
  • Problematic Backup Rate for Exchange 2007
    ... We are currently only getting about 45 MB/min backup speed to disk ... multi-role servers. ... Can someone relate what speeds they are getting? ... We have three Exchange 2007 servers: ...
    (microsoft.public.exchange.admin)