cancel
Showing results for 
Search instead for 
Did you mean: 

Disaster recovery and Backup Procedure of Afaria (incl. Database)

former_member686053
Active Participant
0 Kudos

Hi,

Is there anybody that have recent Afaria Disaster recovery and backup  of Afaria and SqlAnywhere database procedure except

It  is little bit old and not covered database part i think.

Accepted Solutions (1)

Accepted Solutions (1)

former_member686053
Active Participant
0 Kudos

Hi Tracy and Mark

Ok. I know that I can replicate SQL DB yo another Server.

But, My question is,

MY Afaria DB locates on Master afaria server machine. If location of master afaria server goes down and not reachable, and if I have a copy of Afaria DB, A backup of afaria server and its registry files, what should I do

Let me know it is correct:

1.Restore Afaria Backuo on new Server with New IP

2. Show DB Server IP address

3. Change Tranmitter ID on DB or Registry

Then?

tracy_barkley
Employee
Employee
0 Kudos

Tevfik,

Yes, if you have a full backup of the whole server you can just restore it.  If you are basically going to rebuild the server, you would install SQL anywhere, and restore the db.  Then you would follow the steps in the document to restore the registry and files, and then install Afaria to the machine.  This would pick up the transmitter id, etc.  Frankly the IP would not matter except for client connectivity.  (IE the IP or DNS would need to be the same for the client to reach).  Since you use relay server, this shouldn't be a problem as you would restore the RSOE and start them as normal.  Just change the backend server IP if it happened to change.

Tracy.


former_member686053
Active Participant
0 Kudos

Hi,

dbbackup utilty solves problem about SQLAnywhere:


dbbackup -c "Host=sample_host;DBN=demo;UID=DBA;PWD=sql" SQLAnybackup

and here is my batch file according to your directives:


NET STOP "Afaria Server" /y

net stop "AfariaIPhoneServer" /y

net stop "Afaria Backend Portal Package Server" /y

net stop "Afaria API" /y

net stop "Afaria Client Service" /y

taskkill /F /IM rsoe*

REGEDIT /e C:\Backup_YourAfariaServer\Patch.reg HKEY_LOCAL_MACHINE\SOFTWARE\AFARIA\AFARIA\PATCH\

REGEDIT /e C:\Backup_YourAfariaServer\Wow64.reg HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432node\Afaria

c:\"program files (x86)\Afaria\bin\"xaexport.exe \ C:\Backup_YourAfariaServer\channelbackup.cmx /r

xcopy /H /S "C:\Program Files (x86)\Afaria" c:\Backup_YourAfariaServer\FOLDERS\Afaria\ /Y

xcopy /H /S "C:\Program Files (x86)\AfariaApiService" C:\Backup_YourAfariaServer\FOLDERS\AfariaApiService\ /Y

xcopy /H /S "C:\Program Files (x86)\Common Files\AfariaCommon" C:\Backup_YourAfariaServer\FOLDERS\AfariaCommon\ /Y

xcopy /H /S "C:\Program Files (x86)\AfariaSelfServicePortal" C:\Backup_YourAfariaServer\FOLDERS\AfariaSelfServicePortal\ /Y

xcopy /H /S "C:\Program Files (x86)\AfariaAdminUI" C:\Backup_YourAfariaServer\FOLDERS\AfariaAdminUI\ /Y

xcopy /H /S "C:\Program Files (x86)\AClient" C:\Backup_YourAfariaServer\FOLDERS\AClient\ /Y

net start "Afaria Server" /y

net start "AfariaIPhoneServer" /y

net start "Afaria Backend Portal Package Server" /y

net start "Afaria API" /y

net start "Afaria Client Service" /y

c:\"Program Files\7-Zip\"7z.exe  a c:\backup\YourAfariaServerBackup.7z C:\Backup_YourAfariaServer\

cd c:\"program files (x86)\Afaria\bin\RSOutboundEnabler"

startrsoe.cmd

and startrsoe.cmd is:


@echo off

start rsoe.exe @rsoe1.config

start rsoe.exe @rsoe2.config

start rsoe.exe @rsoe3.config

Seems It works.

Answers (1)

Answers (1)

Former Member
0 Kudos

Tevfik, that disaster recovery links directs users to the SQL Anywhere documentation for database recovery which I've included below.

SQL Anywhere Backup and data recovery

The backup and recovery processes of a SQL Anywhere database are the same regardless of what application it is embedded with. The documentation covers the types of backup, recovery plan design and recovery processes.

If you have SQL Anywhere specific questions, you can also ask questions in their community space at

Thanks

Mark

tracy_barkley
Employee
Employee
0 Kudos

Tevfik,

The document is quite up to date.  It was reviewed and tested against SP5 and the latest hot fix at the time before I posted it.  As Mark said the backup procedure for each DB type is covered by the vendor of the DB and is not specific to Afaria.  Since Afaria supports more than one backend DB is it beyond the scope of the document.  If you have any questions on the Disaster recovery itself please let me know.

Tracy