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

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,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 networ
k
> share nightly.
> Is this approach a best practice? Any pointers/comments/suggestions are
> greatly appreciated.
> Thanks,
>
>

Is there any book (books?) to help us creating a Sync tool (Bidirectional)

Hi guys,

We have been looking for books which cover the DB synchronisation subject. We have started creating a plugin to our socket server but we quickly realised how much of a challenge it would be (We are creating it "from scratch"). The conflict problems, the order to tables (rows) be synchronised (Child - Parent) and how to delete rows were some of the problems we found. The main goal is to synchronise devices in the field (Compact framework) to the server using less bandwich as possible.
We are trying to be "agnostic" about the DB in both Server and Client side.

We are pretty sure there are books out there which cover this subject, we just couldn't find them!

We know this will be a challenge but we also know it will be a great feature to add to the server.

Does anyone could point me out to any book?

Cheers

Jean Baro
Dynamic Devices Ltd

Instead of reinventing the wheel, maybe you should have a look at ADO.NET Synchronization Services. http://blogs.msdn.com/Synchronizer/

|||Thanks Erik!

Is there any book (books?) to help us creating a Sync tool (Bidirectional)

Hi guys,

We have been looking for books which cover the DB synchronisation subject. We have started creating a plugin to our socket server but we quickly realised how much of a challenge it would be (We are creating it "from scratch"). The conflict problems, the order to tables (rows) be synchronised (Child - Parent) and how to delete rows were some of the problems we found. The main goal is to synchronise devices in the field (Compact framework) to the server using less bandwich as possible.
We are trying to be "agnostic" about the DB in both Server and Client side.

We are pretty sure there are books out there which cover this subject, we just couldn't find them!

We know this will be a challenge but we also know it will be a great feature to add to the server.

Does anyone could point me out to any book?

Cheers

Jean Baro
Dynamic Devices Ltd

Instead of reinventing the wheel, maybe you should have a look at ADO.NET Synchronization Services. http://blogs.msdn.com/Synchronizer/

|||Thanks Erik!