on 02-06-2015 9:01 AM
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.