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

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

Post by Doug Fo » Sat, 30 Oct 2004 05:47:42


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,
 
 
 

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

Post by RGF2Z » Sat, 30 Oct 2004 11:52:01

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.