Home > Archive > SQL Anywhere database replication > January 2006 > backup (or synchronise) a database on a backup server









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author backup (or synchronise) a database on a backup server
sebastien chedal bornu

2006-01-27, 1:23 pm

hi, i have a customer who have a soft wich works on a sql anywhere 8
database.
I want to put a backup server so when the main server is down he can still
work.
so what i want is that the database on the backup server is the same as the
main server allways automaticaly... is there a way to do this ???
i know how to macke a full backup image file of the database with sybase
central but i want that allways....
i want that every write on the base make a write on the backup base.

thanks

sebastien chedal bornu


Reg Domaratzki \(iAnywhere Solutions\)

2006-01-30, 11:24 am

Database mirroring is a new feature planned for the next major release of
SQL Anywhere, and sounds like exactly what you're looking for. Although SQL
Remote and/or MobiLink can be used to implement a backup copy of the backup,
there will always be some latency in the system, and there will be a few
manual steps to bring the "backup" server up should something go wrong with
the "main" server.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"


"sebastien chedal bornu" <sebastien. chedalbornu@freesbee
.fr> wrote in
message news:43da67f6$1@foru
ms-1-dub...
> hi, i have a customer who have a soft wich works on a sql anywhere 8
> database.
> I want to put a backup server so when the main server is down he can

still

> work.
> so what i want is that the database on the backup server is the same as

the
> main server allways automaticaly... is there a way to do this ???
> i know how to macke a full backup image file of the database with sybase
> central but i want that allways....
> i want that every write on the base make a write on the backup base.
>
> thanks
>
> sebastien chedal bornu
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com