Home

Databoks Offsite Backup Server v4.6 User's Guide

image

Contents

1. amp MSSQLBackupSet 1 amp MSExchangeBackupSet 1 Bi BackupSet T Backup Source i Backup Schedule E Command Line Tool GG Setting Encryption Start running pre commands Finished running pre commands Using Temporary Directory C BackupiMySGQL 1 088760442718 2004 07 22 16 47 01 E Page 106 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS 12 4 How to restore MySQL server Please follow the instructions below to restore MySQL server from an Databoks Offsite Backup Server i Download the database backup files to be restored from the Databoks Offsite Backup Server Please refer to the 5 3 How to restore file section for information on how to download backup files from Databoks Offsite Backup Server ii Restore the database named db name from the database backup file db name soll a Connect to the MySQL server shell gt mysql b Create the database to be restored mysql gt CREATE DATABASE IF NOT EXISTS db_name c Restore the database backup file back into the MySQL server shell mysql db name lt db_name sql iii Repeat the same procedure for each database to be restored to the MySQL Server iv Completed Page 107 Ahsay Offsite Backup Server v4 6 13 Email Reporting Databoks Offsite Backup Server makes use of the email system to keep you informed with the status of your backup activities Please make sure your contact information wi
2. Exit 14 46 Page 87 Ahsay Offsite Backup Server v4 6 User s Guide l pataBoKs ii Create a backup set a b C From the Menu Choose Backup Set gt New gt Lotus Backup Set Backup Source Backup Schedule Command Line Tool LotusBackupSet 1 Lotus Domino Server Backup v Previous Select the Backup Set Type Lotus Domino Server Backup Lotus Notes Client Backup Page 88 Ahsay Offsite Backup Server v4 6 User s Guide d e f l pataBoxs Select the database s file s you want to backup r Backup Source Please selectfiles or and directories to be backed up Lotus Domino eM amp Data Iv C domino Iv C help M CJIBM TECHNICAL SUPPORT amp v CJiNotes a m O logdir3 mM Gmail m modems 7 notes ini CALotusiDominotnotes ini Change Temporary directory for storing backup files CABackupiLotusiDomina Previous Next Cancel Enter a temporary location to store the backup files before they are sent to an Databoks Offsite Backup Server Set the backup schedule for Database Backup Add new Lotus Bac r Backup Schedule Please schedule the backup time Database Backup Schedule Type Datab Transaction Log Backup Schedule Type Transaction log Weekly Weekly Friday 3 Add Remove Properties Previous Next gt Cancel Set the backu
3. Please enter the path to the files folder which contains the backup files that you want to decrypt Cancel Previous Next If you have more than one backup set under the files directory select the Backup Set which contains the backup files that you want to decrypt Page 57 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS zn Decrypt Files Wizard Backup Set Please selete the backup set FileBackupSet 1 C MSSQLBackupSet 1 V Select the snapshot of your backup files that you would like to restore from the removable media by using Show files after Job drop down list Please select the files that you want to decrypt Show files after Job Current C Show all files Current 2005 06 28 22 17 59 T Women ZUU3 T 2 13 13 17 Size 1k O B dell img Last Modified 2005 06 29 12 47 Size 1M die B drvnetimg Last Modified 2004 04 27 16 23 Size 856k Cancel lt Previous Next vi If you want to see all different versions all files shown as gray below just choose the Show all files radio button on the Decrypt Files Wizard dialog Files which are shown in gray and marked as deleted below e g dell img delete are being stored in the retention area on the removable media but you can still restore these files Page 58 l nataeos Ahsay Offsite Backup Server v4 6 User s Guide L n Dec
4. Log Controller E FileBackupSet 1 Ee Log E E E E E E E E E E E e E V ay Backup Restore Log Table 2005 06 28 14 52 25 l0g Start Start running pre commands Finished running pre commands Reading backup source from hard disk Downloading server file list Downloading server file list Completed Reading backup source from hard disk Getting all files which have been added Getting all files which have been added Getting all files which have been updated Getting all files which have been updated Getting all files which have been deleted Getting all files which have been deleted Getting all files which have been moved Getting all files which have been moved Total New Files 353 Total Updated Files 0 Total Deleted Files 0 Total Moved Files 0 New File Uploading 100 of C Docume New File Uploading 100 of CADocume New File Uploading 100 of CADocume New Filel I Ininadine 190 nf nemme 2005 06 28 14 52 26 2005 06 28 14 52 26 2005 06 28 14 52 26 2005 06 28 14 52 26 2005 06 28 14 52 26 2005 06 28 14 52 27 2005 06 28 14 52 28 2005 06 28 14 52 28 2005 06 28 14 52 28 2005 06 28 14 52 28 2005 06 28 14 52 28 2005 06 28 14 52 29 2005 06 28 14 52 29 2005 06 28 14 52 29 2005 06 28 14 52 29 2005 06 28 14 52 29 2005 06 28 14 52 29 2005 06 28 14 52 28 2005 06 28 1
5. 1 006 8M 4616 868 3M 4518 868 3M 4518 868 3M 4518 1 000 2M 5289 875 2M 5288 875 2M 5288 875 2M 5288 875 2M 5288 917 7M 6041 917 7M 6041 917 7M 6041 918 2M 6066 918 2M 6066 918 2M 6066 918 2M 6066 918 4M 6131 918 4M 6131 Uploaded Size 2 2M 8 436 2M 2891 0 D 0 0 0 68 9M 914 0 Total Storage 826 2M 3112 778 2M 3111 778 2M 3111 780 4M 3119 1 19G 6010 J 1 056 5912 1 05G 5912 1 05G 5912 1 07G 6825 973 9M 6824 973 9M 6824 973 9M 6824 973 9M 6824 974M 6884 974M 6884 974M 6884 984 9M 7206 984 9M 7206 984 9M 7206 984 9M 7206 984 9M 7206 984 9M 7206 Key Description Date The date the following statistics are collected Data Area Total number and size of backup files stored in the data area on a particular date Retention Area Total number and size of backup files stored in the retention area on a particular date Uploaded Size Total number and size of backup files uploaded to the backup server on a particular date Total Storage Total number and size of backup files stored under your backup account on a particular date Page 120 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS 15 Further Information 15 1 FAQs Please see if your question has already been answered in our F
6. C all non default initialization parameters will be spooled to an initializing file located in the temporary directory specified by this backup set d all control files will be copied to the temporary directory specified by this backup set e all archived log files will be copied to the temporary directory specified by this backup set If the backup type to run is Archived Log Backup type a all archived log files will be copied to the temporary directory specified by this backup set Run all Post Commands of this backup set Upload all files copied to the temporary directory to the Databoks Offsite Backup Server If your Oracle database is running on Windows please install DataboksOBM onto the company running the Oracle database if DataboksOBM is to backup this Oracle database This would shorten the time required to backup the Oracle database Page 66 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS 8 3 How to backup an Oracle Database Please follow the instructions below to backup your Oracle database to the Databoks Offsite Backup Server i Install DataboksOBM onto your computer ii Open DataboksOBM Right click DataboksOBM icon available in the system tray and choose Open Backup Backup and Logoff Backup and Restart Backup and Shutdown b d Help Stop Running Backup Exit 14 46 iii Create a backup set a From the Menu Choose Backup Set gt New
7. gt New gt MS Exchange Backup Set Create a backup set a From the Menu Choose Backup Set gt New gt MS Exchange Backup Set lol x Backup View New File Backup Set Remove Lotus Backup Set et MSSQLBackupSet 1 MS Exchange Backup Set MS SQL Server Backup Set S MySQL Backup Set 9jMSExc Oracle Database Backup Set Gi BackupSet 7 amp S MySQLBackupSet 1 jg Backup Source D Backup Schedule E Command Line Tool CF Setting amp Encryption S LBackupSet 1 rosoft SQL Server Backup SQL Server Login ID sa Password Properties t Log Table MSSQLBackupSet 1 mul e ee ae oe Welcome to Online Backup Manager Quota Remaining Total 49 9G 50G Last Backup 2004 07 22 14 32 b Enter a name for your backup set Page 95 Ahsay Offsite Backup Server v4 6 User s Guide C l pataBoxs r Backup Set Please type a name for this Backup Set Name MSExchangeBackupSet 1 Type Microsoft Exchange Server Backup Backup Source EE SS Please select Database to be backed up My Computer BA System State S Microsoft Exchange Server B WIN2000SVR amp 7 amp Microsoft Information Store GC gii First Storage Group O Mailbox Store WIN2000SVR Iv 3 Public Folder Store IN2000SVR aM gn SEE Iv 3 abc M acct Iv 9 mail2 zl r Temporary directory for storing backup f
8. Previous Next gt Cancel Hint For maximum security please select AES Advanced Encryption Standard Algorithm CBC Cipher Block Chaining mode and use an encrypting key with more than 8 characters iii Run Backup a Select the backup set you want to run on the left panel and press the Start Backup button ki Page 97 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS b Select the backup type e g Database Log Files you would like to perform ExchangeBackupSet 1 C LogFiles or cane C Select Off site Backup Server to start backing up your files to an Databoks Offsite Backup Server and press the OK button C Local Hard Disk Seed Load Utility Start the backup for MSExchangeBackupSet 1 OK Cancel d You should get something similar to the screen shot below Backup Set Backup View l E Backup Controller ak Backup Set MSExchangeBackupSet 1 Backup Set Backup Source Name MSExchangeBackupSet 1 fd Backup Schedule Type Microsoft Exchange Server Backup mu Line Tool Properties D Encryption Log Table MSExchangeBackupSet 1 Start 2004 01 31 13 53 47 Start running pre commands 2004 01 31 13 53 47 Finished running pre commands 2004 01 31 13 53 47 Using Temporary Directory F ABackupMSExchangeM 071124 2004 01 31 13 53 47 Start Microsoft Exchange backup 2004 01 31 13 53 47 Star Exchange Server
9. Restore Windows Active Directory if required If you have re installed Windows please download the Windows System State backup file named SystemState bkf from Databoks Offsite Backup Server and then use NTBackup exe to restore your Windows System State to its backup time from the backup file by following the instructions below a Run NTBackup exe from Start gt Run b Press the Restore Wizard button and then press the Next button c Press the Import button and use the Browse button to select the backup file SystemState bkf downloaded d Select the checkbox next to the description that matches your backup file e Press the Next button and then the Finish button Install DataboksOBM if required Please refer to the Installation section for information on how to install DataboksOBM onto your computer Startup the Microsoft Information Store services from Windows Services Restore exchange database s from backup a Download the database backup files to be restored from the Databoks Offsite Backup Server or find the cached copy available in the temporary directory defined in your backup set and save them to your hard disk please make sure the directory structure is the same as it appears on the browser b Ifthe database to be restored exists on your computer already please dismount it from the services using Start gt Program gt Microsoft Exchange gt System Manager C Use Exchan
10. After you have made your changes just press the Save Setting button on the toolbar Page 33 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS D Online Backup M r 1 la x Backup Set Backup Restore Tools View D Save Setting gt Start Backup m Siop Backup Backup Controller 8 User Profile r Retention Policy amp Gy FileBackupSet 1 a Backup Source Keep deleted file s for feo sl Days I Backup Schedule ak Cy Setting FileBackupSet 1 amp Backup Filter Transfer Block Size dem Line Tool 128k sl Bytes amp Encryption Symbolic Link D In File Delta ES Local Copy Follow symbolic link H A MSSQLBackupSet 1 Yes C No zi L i OracleBackupSet 1 a MSExchangeBackupSet 1 H LotusBackupSet 1 a E M SQLBackupSet 1 j Log Table FileBackupSet 1 Welcome to Online Backup Manager Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 4 9 Network Mapped Drive If you need to backup a network mapped drive on Windows it will only work in Windows NT 2000 XP 2003 you must enter your Windows domain username and password into the Network Resources Authentication for Windows section as shown below It is required because scheduled backups will always run under the context of windows LocalSystem account which does not have the privilege required to access network resources by default DataboksOBM need to collect y
11. D model D msdb D lj pubs CD D Northwind D abe D D vincent D new model Temporary disk space used for storing spool files CABackupMSSOLServer Change Cancel lt Previous Next Enter a temporary location to store the backup files before they are sent to an Databoks Offsite Backup Server Page 76 Ahsay Offsite Backup Server v4 6 vii User s Guide l pataBoxs f Set the backup schedule for full database backup and transaction log backup 1ver Backup Set xj Backup Schedule Please schedule the backup time Database complete BackupSchedule Type Datab jeekly Transaction log BackupSchedule Type Log Weekly Monday Tu 3 Add Remove Properties lt Previous Next gt Cancel Note You can have more than one schedule in a backup set i e you can perform intra day transaction log backup by adding more than one daily transaction log backup schedule to your backup set g Set the encryption algorithm encryption mode and encrypting key for this backup set cle Database Backup Set E Encryption Setting Please setup the encryption setting of the Backup Set Do NOT use encryption Algorithm TE Mode CBC Cipher Block Chaining C ECB Electronic CookBook Encrypting Key Confirm Encrypting Key Previous Next gt Cancel Hint For maximum security please select AES Advanced Encryption Standard Algorithm CBC Cipher
12. WIN2000SVR 2004 01 31 13 53 47 Start Service Microsoft Information Store 2004 01 31 13 53 47 Start Storage Group First Storage Group 2004 01 31 13 53 47 Start Database Mailbox Store WIN2000SVR 2004 01 31 13 53 47 Backing up EXProgram Files Exchsrvrimdbdatalpriv1 edb 2004 01 31 13 53 47 Backing up EXProgram Files Exchsrvrimdbdatalpriv1 zim 2004 01 31 13 53 49 End Database 2004 01 31 13 53 51 Start Database Public Folder Store WIN2000SVR 2004 01 31 13 53 51 Backing up E3XProgram Files Exchsrvrimdbdatalpub1 edb 2004 01 31 13 53 51 Backing up EXProgram Files Exchsrvrimdbdatalpub1 stm 2004 01 31 13 54 19 End Database 2004 01 31 13 54 22 Start Backing up log files 2004 01 31 13 54 22 Backing up E3XProgram Files Exchsrvrimdbdata EQO000B 2004 01 31 13 54 23 e nnne Backing up EAProgram FilesiExchsrmeG2tacct stm Quota Remaining Total 48 066 50G Last Backup 2004 01 31 10 42 Page 98 Ahsay Offsite Backup Server v4 6 User s Guide l pataBoxs 11 4 How to restore Microsoft Exchange Server 2000 2003 Please follow the instructions below to restore Microsoft Exchange Server 2000 2003 from an Databoks Offsite Backup Server Prepare the system for your Exchange Server if required Install the original version of Windows and Exchange Server with the same level of service pack installed as in the original system back to your computer
13. chosen in the sub menu in background and restart Windows Backup and Shutdown Run the backup set or all backup sets chosen in the sub menu in background and shutdown this computer Help Show a help dialog Stop running backup Interrupt the running backup set or all backup sets chosen in the sub menu Exit Close this system tray launcher application 3 2 Logon Dialog Before you can use DataboksOBM you have to be authenticated by the Databoks Offsite Backup Server first The logon dialog shown below will check if you have the right to access DataboksOBM by submitting the username and password you provided to the backup server Page 18 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS Online Backup Manager Logon t Login Name temo Password ia language English sl Backup Server C http https Address fwww backup provider com Proxy Setting C Proxy C Socks None Praxy Address Iesse Port a User Marne Password m Ok Cancel Options lt lt Please logon to Online Backup Manager For secure communication you can choose to communicate with Databoks Offsite Backup Server in SSL Secure Socket Layer by selecting the https option The Address field shows the Databoks Offsite Backup Server to which DataboksOBM will connect to authenticate your username and password You can use either a resolvable host name e g backup your doma
14. 2005 06 29 12 47 14M 2 fa dell img deleted 14M 2004 04 26 19 21 1 4M 2 fa drvnetimg 2004 04 27 16 23 854k 40 Delete Restore This shows all files directories within a backup job of a backup set 2 To restore files directories check the checkbox next to the files directories and press the Restore button To delete files directories check the checkbox next to the files directories and press the Delete button vi Select the files that you would like to restore and press the Restore button on the toolbar vii A dialog shown below would appear Page 54 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS a Online Backup n t Intemet Explorer Restore Install Software FAQs Help S Please wait while applet is downloading Please select the Java Virtual Machine you would like to use to restore your backup files and press the Restore button below Restore lt You should see a Restore button here Troubleshooting i Make sure you have clicked the Yes button on the security warning dialog box If you have clicked the No button already please restart your browser and try again a Press the Restore button b Enter the directories to which backup files should be restored in the Restore File to textbox Page 55 Ahsay Offsite Backup Server v4 6 User s Guide C d l pataBoxs ini xl Online Backup File Restoring b Re
15. All database s restored successfully Page 84 Ahsay Offsite Backup Server v4 6 l pataBoxs User s Guide 10 Backup Restore Lotus Domino Notes This chapter will describe in details how to use DataboksOBM to backup your Lotus Domino server Notes client 5 6 6 5 and how you can restore your Lotus Domino server Notes client 5 6 6 5 from the backup files 10 1 Requirements i DataboksOBM must be installed onto the computer running Lotus Domino server Notes client ii Data from Lotus Domino server Notes client will be backed up to a temporary directory before they are sent to Databoks Offsite Backup Server Please make sure you have sufficient space on your computer to store these data when you run the backup job iii Lotus Domino server must runs with archive transaction logging enabled To set up transaction logging in archive style please do the following a Ensure that all databases to be logged reside in the Domino data directory either at the root or in subdirectories b From the Domino Administrator click the Configuration tab a In the Use Directory on field choose the server s Domino Directory b Click Server Configuration and then click Current Server Document C Click the Transactional Logging tab d Complete these fields and then save the document Field Enter Transactional Logging Choose Enabled The default is Disabled Log path Path name locati
16. E Apply To v File Directory Op set L Enc p Pattern Matching D di Type Text C Regular Expression C starts with contains C endswith Pattem Add Remove Properties Filter Mode J Include matched C Exclude matched exclude all others je amp Backup Restore 3 Log Welcome to Online Backup Ma Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 Key Description Name The name of a filter Top Directory The top directory to which this filter is applied Filtering rules will be applied to all files and or directories under this directory Apply To Define whether to apply the filtering rule to files and or directories Pattern Matching Jr defines the filtering rules of a filter A filtering rule can be of one of the following types Start With Include Exclude all files directories with name starting with a certain pattern For example You can use B to match all files with name starting with a B character Contain Include Exclude all files directories with name containing a certain pattern For example You can use B to match all files with Page 28 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS name containing with a B character End With Include Exclude all files directories with name ending with a certain pattern For example You can use doc to match all files with name ending with doc all Word doc
17. Registration ER P 8 Edit SQL Server Registration properties wA Delete SQL Server Registration m 3 set up your monitor your import or E database SQL Server export data D MS a Start i D Ven H Ey Dat Al tasks D e Mar CC Sea View EC Sup New Window from Here Delete Refresh Properties Help Page 80 Ahsay Offsite Backup Server v4 6 User s Guide U DATABOKS QL Serve erprise Manage onsole Roo oso 1 SQL Ser Group 2 5 xj i i Console Window Hel x action vew Tos m X c B 9 3e 2 BP e 5 68 SQL Server Group 1 Item E Microsoft SQL Servers FOI L Ip WINZO000 EN wind New SQL Server Registration cc Edit SQL Server Registration properties Delete SQL Server Registration Connect Sti Pe New All Tasks D New Window From Here Delete Refresh Properties Hela b Restore master database 1 From Enterprise Manager gt Tools gt Restore Database Za SQL Server Enterprise Manager Console Root Microsoft SQL Servers SOL Server Groupi 10 x Console window Help el elx Action view Tos gt lm X ES 3 I9 2 B G Gn Ca Tree Data Transformation Services gt wWindowsNT 5 Items S Job Scheduling pi pud Replication Started Taskpad Full Text Indexing ag sai se PRM SQL Server Query Analyzer P S amp J
18. Select Devices button e Press the button to choose your backup files bak for the database to be restored f Press the OK button Restore user database s For each of the database you would like to restore a From Enterprise Manager gt Tools gt Restore Database b Select the database to be restored in the Restore as database drop down list Page 83 l pataBoxs Ahsay Offsite Backup Server v4 6 User s Guide c Select the Database radio button x General Options 5 Restore as database fabe s Restore Database Filegroups or files C From device Parameters Show beckups of onge PS First backup to restore 1271172001 18 52 43 EI E Paint in tir Bi Restore Type Backup set date Size Restore from Backup set name Mo 45 13 11 2001 1 DER CAMSSQL d From the Show backups of database drop down list select the database to be restored e From the First backup to restore drop down list select the snapshot of the database you would like to restore to You can restore your database to the snapshot of your database at any point of the time between the time you did your full backup and the time you did your last subsequent backup fi Change the Restore From entry If you backup files bak are not in the default directory you need to update the full path to your backup files by pressing the Properties button g Press the OK button vi
19. Startup Parameters button SQL Server Properties WIN20000 EN xj Connections Server Settings Database Settings General Memory Processor l Security a Name WIN20000 EN Product SQL Server Enterprise Operating system Windows NT 5 0 2195 Product version 7 00 623 Language English United States Platform NT INTEL X86 OS memory 256 MB Processors d Root directory F A MSSQL Code page CP 1252 r amp utoStart policies when the operating system starts vi us S r Autostart MSDTC Startup parameters Page 79 Ahsay Offsite Backup Server v4 6 User s Guide U DATABOKS 3 Add a m parameter to the Startup Parameters wtup Parameters TESTING 2000 x Parameter Add n Remove Existing parameters dC Program Files Microsoft SOL Server eC Program Files Microsoft SQL Server C Program Files Microsoft SQL Server 4 Restart Microsoft SQL Server From Enterprise Manager right click your Microsoft SQL Server and select Stop and then Start ifi SQL Server Enterprise Manager Console Root Microsoft SQL Servers SQL Server Group WINZUOBOCENAUN nmi xj J Console Window Help 184 8 ll aton vew Te amp 9 BR X r B D z B6 O n Ca Tree WIN20000 EN Windows NT Items C Console Root E Microsoft SQL Servers Getting Started Taskpad EY SQL Server Group E EL Dat New SQL Server
20. Type When Pre Backup Commands run When Post Commands run Server File Before uploading backup files After uploading all backup files Non File Backup Sets Before spooling backup files to After spooling backup files to e g Microsoft SQL temporary directory temporary directory i e before the first backup file is uploaded Note You should never backup an application while it is running as this can result in inconsistent and unusable files getting backed up Please use the Pre Backup Command feature to shutdown your application before running a backup job and use the Post Backup Command feature to restart your application after the backup job has completed Page 31 Ahsay Offsite Backup Server v4 6 User s Guide l pataBoxs 4 7 Encryption Before your files are sent to Databoks Offsite Backup Server all your files are to be compressed and encrypted by your choice of encrypting algorithm mode and key The following table explains all encryption parameters available within a backup set Note Encryption settings are set at backup set creation time and cannot be modified You need to create a new backup set if you want to change your encryption settings for a backup set En Online Backup bv Backup Set Backup Restore Tools View VW Save Setting gt Start Backup w Stop Backup Q amp Backup Controller ax B Encryption FileBackupSet 1 fj User Profile p Encryptio
21. Upd te User Pei gata setieas coccreedecetencsuelenteand saa 115 14 3 Request ER 116 14 4 Delete ndelete Backup Piles oi etras tt nd eran tad end gees 116 14 5 Review Backup Jobs 2uieeiii bere eigene eege dE 117 14 6 Ereegnes 120 15 Purth r Information uie ieee ME pki ia REM DURER eech 121 LANERO o 121 15 2 C ntact WS e 121 Page 5 Ahsay Offsite Backup Server v4 6 User s Guide l pataBoxs 1 Overview 1 1 Benefits Backup of Microsoft Exchange Server 2000 2003 Microsoft SQL Server 7 0 2000 Lotus Domino Notes 5 0 or above Oracle 8i or above MySQL 4 x or above Windows System State 7 Common files e g doc xls Support of backing up only changes within a file In file Delta Easy to use deploy and maintain Fully automated No administrative tasks required DUBON 1 2 Features new In File Delta backup i e backing up only changes within files new Real time backup server replication allows backup server to be easily backup OEM version only All references to Databoks can be removed or branded to your own company name address phone and email OEM version only Allow backup trial accounts to be created on the backup server with max 500MB backup quota OEM version only Create branded installer for backup client software No special setup is required to offer free trial subscriptions to potential users Customizable backup schedule all
22. all If you try to issue it you will receive an error message Page 86 Ahsay Offsite Backup Server v4 6 User s Guide M DATABOKS 10 2 Overview DataboksOBM will backup your Lotus Domino server Notes client by taking the following steps i Run all Pre Commands of this backup set ii If the backup type to run is Database Backup type a all file s database s selected are copied to the temporary directory specified by this backup set b the notes ini file if selected will be copied to the temporary directory C only filled log extents will be copied to the temporary directory and the Domino server is notified of their availability for reuse for Domino server only iii for Domino server only If the backup type to run is Transaction Log Backup typel a only filled log extents will be copied to the temporary directory and the Domino server is notified of their availability for reuse iv Run all Post Commands of this backup set v Upload all files copied to the temporary directory to the Databoks Offsite Backup Server 10 3 How to backup Lotus Domino Notes database s file s Please follow the instructions below to backup your Lotus Domino server Notes client databases files using DataboksOBM i Open DataboksOBM Right click DataboksOBM icon available in the system tray and choose Open Backup gt Backup and Logoff gt D b Backup and Restart Backup and Shutdown Help p Ruming Backup
23. an inactive user reminder in email if your account has been left inactive for the period of 7 days or the period specified by the system administrator This is to remain you that you have not been running backup for more 7 days If you are a free trial user your account will be removed from the system automatically if the system can track no records of your backup activities in the next 30 days after receiving this report Sample Report Inactive User Reminder Generated at Sat Jun 21 11 53 38 HKT 2003 Why are you receiving this report User Setting Login Name NewAccount You are receiving this report because this backup account has Alias New Testing Account Name been inactive for 30 days If this account stays inactive for Language English another 30 days this account will be removed from our Contact user your company com system automatically without further notice The following is the backup activity ofthis account Last Login Time 2003 06 21 10 18 AM Last Backup Time 2003 06 21 09 57 AM If further assistance is necessary please referto the FAQs section Key Description Login Name Login name Alias Alias Language Preferred Language for your backup reports Contact Email Address that will be used to contact you Backup Quota Backup Quota Last Login Time The last time you logon to the backup system Last Backup Time The last time you ran a backup job
24. and uploaded to the backup server 7 6 Temporary Directory The Temporary Directory setting defines a temporary directory where DataboksOBM can be used to save its temporary files during the delta file generation operation Please set this directory to a partition with lots of free space Page 64 Ahsay Offsite Backup Server v4 6 User s Guide 8 l pataBoxs Backup Restore Oracle 8i 9i This chapter will describe in details how DataboksOBM backup your Oracle 8i 9i and how you can restore an Oracle 8i 9i database using the backup files 8 1 Requirements DataboksOBM must be installed onto the computer that can connect to your Oracle 8i 9i server using TCP IP protocol Data from Oracle 8i 9i database will be backed up to a temporary directory before they are sent to Databoks Offsite Backup Server Please make sure you have sufficient space on your computer to store these data when you run the backup job Database must be in archived log mode To switch to archived log mode and enable automatic log archiving please do the following a Set the parameters below in the PFILE to enable automatic archiving log_archive_dest directory where archived logs will be stored log_archive_format ARCH S LOG log_archive_start TRUE b Switch to archived log mode SVRMGRL gt connect internal SVRMGRL gt startup mount SVRMGRL gt alter database archivelog SVRMGRL gt alter database open C Oracle JVM is enabled To enabl
25. any server wide or database configuration options have added logins or other login security related operations have created or removed logical backup devices have configured the server for distributed queries and remote procedure calls such as adding linked servers or remote logins You do not need to restore your master database if you just want to restore a user database For more information on Microsoft SQL Server master database please visit http www microsoft com sql Page 78 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS To restore master database please do the following a Start Microsoft SQL Server in Single User Mode 1 Right click your Microsoft SQL Server and select Properties a SQL Server Enterprise Manager Console Root Microsoft SQL Servers SQL Server Group WIN20000 EN indo D nl x Console Window Help 248424 action view mos gt gn X ct 3 53 P sk Ni vo Gn Ca Tree Databases 8 Items Saz uv WT i i ij ij E KJ Microsoft SQL Servers GO SQL Server Group abe master model msdb Northwind pubs tempdb B Gigi New SQL Server Registration m a Edit SQL Server Registration properties _ Delete SQL Server Registration 7 Cl disconnect Bas or Pause Start New gt All Tasks D New Window from Here Delete Refresh Help Opens property sheet for the current selection 2 Press the
26. e Help Stop Running Backup v Exit 14 46 ii From the Menu Choose Backup Set gt New gt MySQL Backup Set Create a backup set a From the Menu Choose Backup Set gt New gt MySQL Backup Set File Backup Set Remove gt Lotus Backup Set Save MS Exchange Backup Set Ext MS SQL Server Backup Set t MSSQLBackupSet 1 QLBackupSet 1 rasoft SQL Server Backup SQL Server LoginID sa Password E Oracle Database Backup Set mz Bi BackupSet 7 S E MySQLBackupSet 1 ig Backup Source fd Backup Schedule Command Line Tool CF setting B Encryption Properties Ip Log Table MSSQLBackupSet 1 pr Welcome to Online Backup Manager Quota Remaining Total 49 9G 50G Last Backup 2004 07 22 14 32 Page 103 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS b Enter a name for your backup set Backup Set Please type a name forthis Backup Set Name MySQLBackupSet 1 Type MySQL Backup MySQL User Namefroot Password EN Hostlocalhost pot fs306 Path to mysqldump Sg Change Previous e Cancel c Enter the root password the MySQL server TCP IP port number and the path to MySQL backup utility mysgldump d Select the database s to be backup r Backup Source Please select databases to be backe
27. e 40 4 13 Follow Symbolic Link Linux Unix Mac only eese 41 3 Backing up EE 43 21 Howfilesare backed Up pe plis be eieiei eEeg 43 5 2 Backup files directly to the backup server sseseceseseeesresreeresrrssrrererreesreres 44 5 3 Backup files to removable hard disk seed loading 47 NEM C vsu qi T 50 6 1 Restore backup files directly from backup server 50 Page 3 l pataBoxs Ahsay Offsite Backup Server v4 6 User s Guide 6 2 X Restore backup files from removable hard disk sss 56 6 3 Restrict restoring files by IP addresses eene 60 7 JXn Puedelt Technology ausescnepe uestes srt csae tex etait es isi o HO tU ERU HEN MER rds 62 7 1 OVENI e 62 qul Eeer 63 7 3 Maximum Number of Delta wise esser eri ne tti tx RR eege 63 L Minimum File EEUU e 64 7 5 Delt Rati Ossetere osen ne e i E a eS 64 FO Temporary Directory cese Ep MUROS eai Eege M DIN REP iE h 64 Backup Restore Oracle E 65 8 1 Le cM n 65 PAMEC vis cc 66 8 3 How to backup an Oracle Database esee 67 8 4 Howtorestore an Oracle Database toot neri egene 71 9 Backup Restore Microsoft SQL Server 7 0 2000 see 74 9 1 E ets 74 MEE ci pec 74 9 3 How to backup Microsoft SQL Serv
28. gt Oracle Database Backup Set Backup View File Backup Set Remove gt Lotus Backup Set Save MS Exchange Backup Set Ca MSSQL Server Backup Set MySQL Backup Set H Oracle Database Backup Set SQL Servel d BackupSet 7 p LoginID sa Password E E MySQLBackupSet 1 Properties et MBSQLBackupSet 1 SQLBackupSet 1 rosoft SQL Server Backup icici a j Backup Source fj Backup Schedule E Command Line Tool CF Setting amp Encryption 5 Log Table MS8QLBackupSet 1 Welcome to Online Backup Manager Quota Remaining Total 49 9G 50G Last Backup 2004 07 22 14 32 Page 67 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS b Enter a name for your backup set Backup Set Please type a name for this Backup Set Name OracleBackupSet 1 Type Oracle Database Server Backup r Oracle Database Server Login ID sem Password jJ Host fo Port 1521 SID y Cancel Previous Next gt C Enter the system password the Oracle Database Server Host Name TNS Port and SID d Select the tablespace s you want to backup r Backup Source Please selecttablespaces to be backed up Oracle Database Server 5 SYSTEM M j OEM REPOSITORY DARBS 5 TEMP m USERS 85 INDX Temporary disk space used for storing spool files C Backup OracleDB Change
29. isi xi Backup Set Backup Restore Tools View g Save Setting gt Start Backup 8 Stop Backup amp Backup Controller fj User Profile S G4 Files SP d Backup Source FileBackupSet 1 B Ee Desktop si Backup Schedule V y My Documents amp Backup Filter a Gy Options E Command Line Tool S d My Computer CF Setting amp 7 A 3 Floppy A B Encryption IC ze Data C I In File Delta B ze Win2003 D amp Local Copy amp i 7 Documents and Settings a leBackupSet 2 H D O deminoserver E a e DO LocalBackup DO Program Files C3 RECYCLER C3 shadowcpy2003 System Volume Information ODO temp OO VEHADOW Log Table FileBackupSet 1 GR FileBackupSet 3 GC SII Welcome to Online Backup Manager Quota Remaining Total 8 17G 10G Last Backup 2005 06 30 13 19 The checkbox next to the files directories shown above can be in one of the following mode Mode Description V All files directories recursively under this directory will be backed up All files directories recursively except those explicitly excluded under this directory will be backed up If you add files directories to this directory in the future they will be backed up as well files directories to this directory in the future they will NOT be backed up v P Only the checked files directories under this directory will be
30. large block size for security reasons If you are in a network with this type of restriction please lower the transfer size value and try again To change the transfer block size of any backup set please select the Setting node on the left panel to invoke the Setting panel on the right You can then make changes to the Transfer Block Size After you have made your changes just press the Save Setting button on the Page 40 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS toolbar zn Online Backu Backup Set Backup Restore Tools View D Save Setting gt Start Backup w Siop Backup Q Backup Controller Es User Profile R 3 z etention Polic amp B FileBackupSet 1 g D Backup Source Keep deleted file s for foo sl Days fg Backup Schedule K Cj Setting FileBackupSet 1 SI Backup Filter Transfer Block Size E command Line Tool 128k v Bytes amp Encryption Symbolic Link S In File Delta de Local Copy Follow symbolic link amp amp MSSQLBackupSet 1 Yes C No E m E S amp 8 MSExchangeBackupSet 1 amp f amp LotusBackupSet 1 Es MyS LBackupSet1 Hi Log Table FileBackupSet 1 Q Backup Restore 3 Welcome to Online Backup Manager Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 4 13 Follow Symbolic Link Linux Unix Mac only Under Unix Linux users can u
31. lt Previous Next gt Cancel e Enter a temporary location to store the database file s before they are sent to an Databoks Offsite Backup Server Page 68 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS f Set the backup schedule for database backup and archived log backup Backup Schedule Please schedule the backup time Database Tablespaces Control amp Init File Archived Logs Backu Archived Logs BackupSchedule Type Archived Logs Weekly Mc 4 Add Remove Properties lt Previous Next Cancel Database complete BackupSchedule Properties Name Database complete BackupSchedule Backup Database complete Database differential Transaction log Type C Daily Ze Weekly C Monthly C Custom Day Backup on the following day s every week Sunday Monday Tuesday Wednesday Thursday v Friday Saturday r Start Start Time hh mm z1 v sl r Stop Stop on completion Full Backup Note You can have more than one schedule in a backup set i e you can perform intra day Page 69 l pataBoxs Ahsay Offsite Backup Server v4 6 User s Guide transaction log backup by adding more than one daily transaction log backup schedule to your backup set g Set the encryption algorithm encryption mode and encrypting key for this backup set cle Database Backup Set E Encryption Setting Plea
32. scheduled backup on this computer MSExchangeBackupSet 1 LotusBackupSet 1 MySQLBackupSet 1 Ree fs Log Table FileBackupSet 1 e Star 2005 06 28 16 59 07 E D Start running pre commands 2005 06 28 16 59 07 G Finished running pre commands 2005 06 28 16 59 07 Downloadina server file list 2005 06 28 16 59 071 E Backup Restore Backup Completed Successfully Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 iv Repeat the previous step for the rest of all backup sets that are not intended to run on this computer v Repeat step ii to step iv for each computer that has been installed with DataboksOBM under the same backup account IMPORTANT If you want to backup an extra computer using the same backup account some time later this implies that you need to create an additional backup set under this backup account for the new computer please make sure to repeat the procedure above unchecking the Run scheduled backup on this computer checkbox for the added backup set for each computer 4 12 Transfer Block Size Transfer block size defines the block size DataboksOBM will use to transfer your backup blocks Generally backup job using a larger block size would have a better performance as there will be less roundtrip involved in connection initialization However some firewalls or proxy servers may block out going network traffic HTTP HTTPS POST method with
33. to start backing up your files to an Databoks Offsite Backup Server Confirm Backup Start xf Backup to C Local Hard Disk Seed Load Utility Start the backup for FileBackupSet 1 OK Cancel Note 1 You can have more than one backup set in backup account 2 Please write the encrypting key down on paper and keep it in a safe place If you lost your encrypting key is lost you will not be able to restore your backup files 5 3 Backup files to removable hard disk seed loading If you have a lot of data e g 300GB to backup to the backup server it would take a considerable amount of time to perform the first full backup through the Internet If you run into this problem you can use the Seed Loading Utility to backup your backup set to local hard disk instead of directly to the backup server and then transport the backup data using removable hard disk to the offsite backup server The administrator can then load all your backup files from your removable hard disk into your backup account This could then save you days even weeks of performing your first full backup Since subsequent backup will be incremental backup only new or updated files will be uploaded to the server you should have no problems finishing backing up all files afterwards To perform seeding loading please do the following Open DataboksOBM from the System Tray see previous sections for details ii Setup your backup set s
34. web installation guide and install it over existing installation of DataboksOBM It will upgrade the DataboksOBM to the latest version e Online Backup Services M ent Console Microsoft Intemet Explorer Select your Operation System pide solaris Installation Guide OBM Windows System Requirement Operating System Windows 95 98 ME NT 2000 XP 2003 Memory 128 Mbytes Disk Space 100 Mbytes Network Protocol TCP IP Http Https Additional Requirement o Windows 95 Please download and install Windows Socket 2 Update for Windows 95 w9Sws2setup exe o Windows NT 2000 XP 2003 Please make sure you have logged onto Windows using an account with administrative privileges Online Backup Manager obm win exe Get Started 1 Download the setup file obm win exe above and run it 2 Follow the instructions on the installation wizard to complete installation Notes You will only be prompted to reboot your computer if some files are locked and cannot be overwritten during upgrade Upgrade instructions of DataboksOBM on Netware a Download the latest release bundle obm netware zip from the web installation guide Page 11 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS L Online Back nent Console crosoft Internet Explorer your Operation System ay m solaris rint Installation Guide OBM NetWare System Requirement Operating System Novell NetWare 5 1 or
35. 06 28 16 59 10 Getting all files which have been added 2005 06 28 16 59 10 Gy Natina all filac whieh have haan added ormnlatad Leide RM E Q Backup Restore Log Backup Completed Successfully Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 How to restore Local Copy files Local copy files are stored in the Copy to directory under Local Copy setting in encoded filenames A nozip extension is appended to all filenames if Zip setting is not enabled A zip extension is appended to all filenames if Zip is enabled To restore backup files back to their original filenames and to their original contents if Zip is enabled please do the followings i Choose Tools gt Unzip Local Copy Page 37 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS n Online 3 Backup Set Backup Restore Tools View E Save Setting gt Start Backu il ETA S Decrypt Files Wizard Backup Controller Backup Set Name FileBackupSet 1 Type File Backup Network Resources Authentication for Windows Backup Source fi Backup Schedule amp Backup Filter E command Line Tool Domain O Setting User Name B Encryption Password D In File Delta amp Local Copy amp MSSQLBackupSet 1 5 OracleBackupSet 1 MSExchangeBackupSet 1 8 LotusBackupSet 1 is M SQLBackupSet 1 P
36. 2005 06 28 21 57 02 Downloading CMell img Total 1 4M bytes 2005 06 28 21 57 03 C Mell img 1 4M bytes downloaded 2005 06 28 21 57 03 Same file CACONFIG SYS exists already 2005 06 28 21 57 03 End Estimated Total Restore Time sec Total 2 2M bytes 2 2M bytes restored Estimated Restore Time O sec Total 1 37M bytes 1 37M bytes restored Saving File To CMellimg Restoring Speed 1M bytes second Close Start Stop End Using the web interface You can backup your data to an Databoks Offsite Backup Server by following instructions below i Logon to the Databoks Offsite Backup Server web interface ii From the top menu click File Explorer Page 52 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS e Online Back n Internet Explorer Restore Install Software FAQs Help Select Lanquage Last Modified Zipped Ratio This shows all backup sets available within this backup account To restore backup files please click the backup set link shown above to continue To delete a backup set check the checkbox next to the backup set and press the Delete button iii Click the Backup Set link that contains the files that you want to restore iv Select the snapshot of your backup files that you would like to restore from the backup server by using Show files after Job drop down list Z Online Backup n t Internet Explorer Restore Install Software FAQs Help
37. 4 52 29 2005 06 28 14 52 31 2005 06 28 14 52 31 2005 06 28 14 52 31 Dnnatnni n 14 52 31 il Welcome to Online Backup Manager Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 Page 23 Ahsay Offsite Backup Server v4 6 User s Guide M DATABOKS 4 Setting up backup set A backup set contains all backup settings of a backup operation This section will describe all features available within a backup set and explain how you can use each of them to achieve various tasks Each backup account can have multiple backup sets Each backup set is an individual and independent entity For example if you want one directory to be backed up during the day and another directory to be backed up during the night you can create two backup sets each with a different backup schedule and backup source to serve this need 4 1 Backup Set Type A backup set can be of one of the following types Backup Type Description File Backup set type to backup common files directories Microsoft SQL Server Backup set type to backup Microsoft SQL Server 7 0 2000 Oracle Database Server Backup set type to backup Oracle 8i 9i database Lotus Domino Notes Backup set type to backup Lotus Domino Notes Microsoft Exchange Server Backup set type to backup Microsoft Exchange Server 2000 2003 MySQL Backup set type to backup MySQL Server Backup set type is defined at backup set creation and cannot be modifi
38. AQs available on our website 15 2 Contact Us You can backup your data to an Databoks Offsite Backup Server by following instructions below i Open DataboksOBM from the system tray ii Choose View gt About from the top menu Backup Set Backup Restore Tools View H Save Setting gt Start Backup m St UserProfile Backup amp Backup Controller ak ERA f User Profile E a Backup Source fg Backup Schedule amp Backup Filter Network Resources Authentication for Windows Command Line Tool Domain Cf Setting User Name amp Encryption Password E In File Delta amp Local Copy Properties IO MSSQLBackupSet 1 OracleBackupSet 1 v Run scheduled backup on this computer 9 MSExchangeBackupSet 1 LotusBackupSet 1 EI MySQLBackupSet 1 D l Log Table FileBackupSet 1 e Start 2005 06 28 16 59 07 E a Start running pre commands 2005 06 28 15 59 07 D Finished running pre commands 2005 06 28 16 59 07 G Downloadina server file list 12005 06 28 16 59 071 zl amp Backup Restore Backup Completed Successfully Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 iii Contact your backup service provider using the information shown in the About dialog box Page 121 l nArABoKs Ahsay Offsite Backup Server v4 6 User s Guide ECE Online Backup Manager Page 122
39. Ahsay Offsite Backup Server v4 6 User s Guide l pataBoxs 1 3 Security Point to point SSL communication between server and client Support HTTP HTTPS Proxy and Socks v4 v5 firewall Data are 128 bit encrypted when stored on backup server Choice of different encryption algorithms e g Twofish Triple DES Advanced Encryption Standard AES Choice of different encryption modes e g Electronic Cook Book ECB and Cipher Block Chaining CBC An random initializing vector salt and iteration count will be generated by the software automatically for each file when encrypting your data Each backup user can restrict online access to his files to his pre defined list of IP addresses 1 4 System Requirements Operating System 1 Windows 95 98 ME NT 2000 XP 2003 Linux Kernel 2 2 or above e g RedHat Linux 6 x or above Solaris 2 x or above Mac OS X NetWare 5 1 or above all other operating systems that supports Java2 Runtime Environment 1 3 1 or above Memory 128MB minimum 256MB recommended Disk Space 100MB Network Protocol TCP IP http https DWN Standard C libraries for backwards compatibility compiler compat libstdc X X y y y y i386 rpm must be installed if you are not using a Linux 2 2 kernel These libraries are required to run all Java applications Page 7 Ahsay Offsite Backup Server v4 6 2 l pataBoxs User s Guide System Configuration Before you can start backing up data to D
40. Block Chaining mode and use an encrypting key with more than 8 characters Run Backup a Select the backup set you want to run on the left panel and press the Start Backup button ki Page 77 Ahsay Offsite Backup Server v4 6 User s Guide b C l pataBoxs Select the backup type e g Complete Differential Transaction Log you would like to perform ackup Type MSSQL Backupsetj xi Backup C Database differential C Transaction log Select Off site Backup Server to start backing up your files to an Databoks Offsite Backup Server Confirm Backup Start E Backup to C Local Hard Disk Seed Load Utility Start the backup for MSSQL BackupSet OK Cancel 9 4 How to restore Microsoft SQL Server database s Please follow the instructions below to restore your Microsoft SQL Server databases from an Databoks Offsite Backup Server Download the backup files bak from the Databoks Offsite Backup Server Please refer to the Quick Start Backup File section for information on how to download backup files from Databoks Offsite Backup Server Open Microsoft SQL Enterprise Manager You can open Microsoft SQL Enterprise Manager from Start Menu gt Program gt Microsoft SQL Server gt Enterprise Manager Optional Restore master database You need to restore master database if you a pans are rebuilding all your databases from scratch have changing
41. C Test lib KING1 BAK Generated at Sat Jun 21 10 00 05 HKT 2003 Backup Job Statistics Unit Number of files Total file size Backup Logs Backup Logs Start running pre commands Finished running pre commands Start running post commands Finished running post commands Timestamp 2003 06 21 09 57 2003 06 21 09 57 2003 06 21 09 57 2003 06 21 09 57 compressed Last Modified 2003 06 21 09 57 New Files Updated Files Size i C Test lib DANIEL DOC 9k compressed Last Modified 2003 06 21 09 57 Deleted Files compressed Last Modified 1996 11 29 18 45 Moved Files compressed Last Modified 2003 06 05 12 35 Parameter Description Backup Set The name of the backup set Backup J ob The name of the backup job which is the start time of the backup job Backup Status The overall status of the backup job Backup Time The time when the backup job ran Backup Log All messages logged when running this backup job New Files Total number and size of backup files added to your backup set Updated Files Total number and size of backup files updated in your backup set Deleted Files Total number and size of backup files deleted from your backup set Moved Files Total number and size of backup files relocated in your backup set New File List Full list of all backup files added to your backup set Updated File List Full list of all backup files updated i
42. M HOME tar xvfz obm linux tar gz e Start backup scheduler by running OBM_HOME bin Scheduler sh f You can then open DataboksOBM by running OBM_HOME bin BackupManager sh 2 3 Un installation of DataboksOBM This section describes the steps required to uninstall DataboksOBM from your computer Page 15 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS Uninstallation instructions of DataboksOBM on Windows a Open Start gt Control Panel gt Add Remove Programs b Select DataboksOBM from the list and press the Remove button Uninstallation instructions of DataboksOBM on Netware a Stop running backup scheduler by running SYS gt touch SYS OBM ipc Scheduler stop b Remove all program files by removing the directory SYS OBM C Remove all backup settings by removing the directory SYS OBM Uninstallation instructions of DataboksOBM on Mac OS X a Stop running backup scheduler by running SystemStarter DataboksOBM stop b Remove all program files by removing Applications OBM 3t rm rf Applications OBM C Remove all backup setting by removing obm rm rf obm d Remove backup scheduler service from system startup by System Library Startupltems DataboksOBM rm rf System Library Startupl tems DataboksOBM Uninstallation instructions of DataboksOBM on Linux a Stoprunning backup scheduler by running touch OBM HOME ipc Scheduler stop b Remove all program files by r
43. O Log applied ORA 00279 change 547222 generated at 06 18 03 19 58 26 needed for thread 1 ORA 00289 suggestion data ora815 vin archive ARCH0000000384 L0G ORA 00280 change 547222 for thread 1 is in sequence 384 ORA 00278 log file data ora815 vin archive ARCH0000000383 LOG no longer needed for this recovery ORA 00308 cannot open archived log data ora815 vin archive ARCH0000000384 L0G ORA 27037 unable to obtain file status Linux Error 2 No such file or directory Additional information 3 SVRMGR gt recover database using backup controlfile until cancel ORA 00279 change 547222 generated at 06 18 03 19 58 26 needed for thread 1 ORA 00289 suggestion data ora815 vin archive ARCH0000000384 L0G ORA 00280 change 547222 for thread 1 is in sequence 384 Specify log lt RET gt suggested filename AUTO CANCEL CANCEL Media recovery cancelled SVRMGR alter database open resetlogs Statement processed if Oracle 9i Use Recovery Manager to restore you database by doing the following a Run Oracle Server Manager rman b Connect to the target database C Startup mount d Reapply all transactions from the archived log files to the last sequence e Open database Oracle 9i Example C gt rman nocatalog Recovery Manager Release 9 2 0 1 0 Production Copyright c 1995 2002 Oracle Corporation All rights reserved Page 72 Ahsay Offsite Backup Server v4 6 User s Gui
44. Page 114 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS 14 Web Features Other than the features of DataboksOBM described in the previous chapter the web interface of Databoks Offsite Backup Server provides you access to some additional features that are not available in DataboksOBM This chapter describes each of these features in details 14 1 Install DataboksOBM Before you can use DataboksOBM you have to use the web interface of Databoks Offsite Backup Server to install DataboksOBM onto your computer Please refer to the installation section Chapter 2 for information on how to install DataboksOBM onto your computer 14 2 Update User Profile You can update your user profile by using the Profile panel available on the web interface To change your profile just make any changes to your profit on the panel shown below and press the Update button Online Backup Services Ma nent Console Microsoft Intemet Explorer Restore Install Software FAQs Help Select Language User Summary Quota Data Area Retention Area otal U Total Restore 500M 861k 3 i4M 1 A 5 2M 5 Unit Compressed Size Total No of Files User Profile demo Alias Demonstration Account Language English D Timezone GMT 08 00 HKT Contact isName DemoAccount Remove Email derno your company com 2 Name Add Email E Add on Modules Microsoft Exchange Server Enable Microsoft SQL Server Enable Ora
45. SQLServer Profiler EMEJ Database Scripting ie ate ee B a Wizards Eg e 1 Database Maintenance Planner SQL Server Configuration Properties Manage SQL Server Messages External Tools Options Font Termin 2 Select master in the Restore as database drop down list 3 Select the From device radio button Page 81 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS 4 Press the Select Devices button Restore database E xj General Options amp Restore as database master v Restore C Database Filegroups or files From device Parameters Devices Select Devices Backup number P Restore backup set Database complete C Database differential Transaction log C File or filegroup C Read backup set information and add to backup history 5 From the Choose Restore Devices press the Add button Choose Restore Devices x When the backup is restored SOL Server will attempt to restore from the devices listed below Backup set Unknown Restore from Disk C Tape Device name Media verification option Only restore from media with the following name Media name 6 From the Choose Restore Destination panel press the button to choose your master backup bak from your backup files Choose Restore Destination E x Choose the file name or backup device to use for the aS r
46. Select Language Home gt FileBackupSet i gt C Show files after Job 2005 06 28 16 59 C Show allfiles C Show Jobs View Delete Restore f3 File Directory Last Modified Zipped Ratio KI Vv s CONFIG SYS 2003 12 13 13 17 32 0 el dell img 2004 04 26 19 21 14M 2 iv Iv ai drvnet img 2004 04 27 16 23 854k 40 Delete Restore Note 1 This shows all files directories within a backup job of a backup set 2 To restore files directories check the checkbox next to the files directories and press the Restore button 3 To delete files directories check the checkbox next to the files directories and press the Delete button V If you want to see all different versions all files shown as gray below just choose Page 53 Ahsay Offsite Backup Server v4 6 User s Guide I DATABOKS the Show all files radio button on the File Explorer page Files which are shown in gray and marked as deleted below e g dell img delete are being stored in the retention area on the backup server but you can still restore these files from the backup server ict xi Restore Install Software FAQs Help Select Lanquage Microsoft Intemet Explorer Home gt FileBackupSet 1 gt C C Show files after Job 2005 06 28 22 17 D Show allfiles C Show Jobs View Delete Restore O File Directory Last Modified Zipped Ratio 2 CONFIG sYs 2003 12 13 13 17 32 0 fa dell img
47. a matched data block can be found between the last full backup file and the file on local computer It therefore produces in a smaller delta file but it would require more processing power to detect these changes On the other hand in file delta backup running with larger block size will run faster but this will generally produce a larger delta file In most case the default setting Auto will choose the optimal block size for each file depending on the size of the file for you 7 3 Maximum Number of Delta The Maximum number of delta setting defines the maximum number of delta files from the same full backup file to be generated and backed up to the backup server before a full backup the whole file of this file is uploaded to the backup server instead For example if you have created 100 delta files from the full backup file already and the Maximum number of delta setting is 100 the next backup will upload a full backup file the Page 63 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS whole file instead of just the delta file However if the Maximum number of delta setting is unlimited it will keep generating a delta file and uploading the delta file to the backup server until any of the other delta setting conditions force a full backup e g delta ratio is exceeded This setting is here to make sure that there will always be a full backup file after a certain number of delta files have been generated 7 4 Mi
48. aboksOBM icon available in the system tray and choose Open Backup Backup and Logoff Backup and Restart Backup and Shutdown b LH d Help Stop Running Backup Exit 14 46 vi Create a backup set a From the Menu Choose Backup Set gt New gt MS SQL Server Backup Set File Backup Set Lotus Backup Set et MSSQLBackupSet 1 MS Exchange Backup Set rver Backup Set MySQL Backup Set Oracle Database Backup Set pa BackupSet 7 3i MySQLBackupSet 1 SQLBackupSet 1 rosoft SQL Server Backup SALSewer LoginID sa jg Backup Source Password fd Backup Schedule J Ed Line Tool Properties etting Encryption ij Log Table MSSQLBackupSet1 eT SEES Welcome to Online Backup Manager Quota Remaining Total 49 9G 50G Last Backup 2004 07 22 14 32 Page 75 Ahsay Offsite Backup Server v4 6 b c d e Enter a name for your backup set Add new r Backup Set Please type a name for this Backup Set Name MSSQLBackupSet 1 Type Microsoft SQL Server Backup Microsoft SQL Server LoginiD sa Password Previous Next gt Cancel User s Guide l pataBoxs Enter the Microsoft SQL Server administrator username and password Select the database s you want to backup r Backup Source Please select databases to be backed up Microsoft SQL Server D amp master O B tempat
49. above Memory 128 Mbytes Disk Space 100 Mbytes Network Protocol TCP IP Http Https Additional Requirement o Novell MM 1 3 x or above for NetWare must be installed already Download Online Backup Manager obm netware zip Get Started 1 Download the setup file obm netware zip above 2 Expand the zip file to SYS OBM 3 Open OBM by running SYS OBM bin BackupManager ncf b Backup existing installation by renaming SYS OBM to SYS OBM bak c Restarting backup scheduler by running SYS OBM bin Scheduler ncf d You can then open DataboksOBM by running SYS OBM bin BackupManager ncf Upgrade instructions of DataboksOBM on Mac OS X a Download the latest release bundle obm mac zip from the web installation guide Page 12 Ahsay Offsite Backup Server v4 6 User s Guide U DATABOKS Z Online Back ent Con osoft Internet Explorer Select your Operation System Alle solaris A Print Installation Guide OBM Mac OS X System Requirement Requirement Operating System Mac OS X v10 x Memory 128 Mbytes Disk Space 20 Mbytes Network Protocol TCP IP Http Https Additional Requirement o Apple Java2 Standard Edition 1 3 x or above must be installed already Download Online Backup Manager obm mac zip Get Started 1 Download the setup file obm mac zip above 2 Expand the archive and run the installation wizard OBM within the archive 3 Follow the instru
50. ackup Set Backup Restore Tools View EI Save Setting b Start Backup W Stop Backup Backup Controller df Command Line Tool FileBackupSet 1 Fa User Prone Pre backup Gy FileBackupSet 1 L Backup Source No existing Command Line Tool zl T Backup Schedule No existing Command Line Tool v amp Backup Filter Command Working Directory B Encryption E In File Delta amp amp Local Copy Name J MSSQLBackupSet comm OracleBackupSet 1 9 MSExchangeBack Workin H LotusBackupSet 1 e al MyS LBackupSet Add new BE SCH dr Backup Restore Post backup Command Line Tool Post backup Command 1 and g Directory Browse 9l Cancel Add Remove Properties Al Log Table FileBackupSet 1 e Type Log Time welcome to Online Backup Manager Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 Both Pre Backup an d Post Backup commands comprise of the following parameters Key Description Name Name of this Command Command The command to be run e g C My Documents Application exe or C My Documents Batch ob bat Working Directory The directory at which this command will run The backup set type affects the time at which Pre Backup and Post Backup commands run The following table outlines when Pre Backup and Post Backup commands will run in different types of backup set Backup Set
51. also ensures the privacy of your data File Retention Policy The built in file retention policy allows you to access multiple versions of the same file or even deleted files from your backup set Backup files are put into a retention area before they are removed from the server If you want to get back a deleted file or you want to get back the previous versions of an updated files within the retention period these files will always be available in the retention area This feature is particularly useful when you have accidentally deleted a file or incorrectly updated a file within the file retention period file retention period is user customizable 5 2 Backup files directly to the backup server You can backup your data to an Databoks Offsite Backup Server by following instructions below i Open DataboksOBM ii Right click DataboksOBM icon available in the system tray and choose Open a Create a backup set b From the Menu Choose Backup Set gt New gt File Backup Set Lotus Backup Set Save Setting MS Exchange Backup Set Ext MS SQL Server Backup Set MySQL Backup Set D8 Backi Oracle Database Backup Set F Bach amp Backup Filter Password Change E Command Line Tool Display Name Demonstration Account Change Cf Setting Encryption i Dn Account Information Quota 500M E In File Delta Time Zone GMT 08 00 HKT v Local Copy Contact demo your company com v Contact Nam
52. are registered trademarks of Apple Computer Inc All other product names are registered trademarks of their respective owners l pataBoxs Ahsay Offsite Backup Server v4 6 User s Guide Table of Content E 8 pc 6 1 1 Benefits M 6 MEM onc mem 6 UE OT 7 1 4 System Requirements seseseeeeseeesseesseeeeeeessstrsstesstessersseresseesseeessresseesseresent 7 2 System LOUIE UT ALI E 8 2 1 Installation of DataboksOBM eeesseseeseesrseseesessessesresseesrrsernserssesreesresseseresee 8 2 2 Upgrade of DataboksOBM siicsscpssscsasnesccsastevesssasecassanteseasasdeseseisencwesaszevenvase 11 2 3 Un installation of DataboksOBM esee enne enne 15 3 Using DataboksOBM nido iesieta niria iesi aiie 18 3 1 System IHN 18 32 Logon Dial g secerni i e aa er a i a iaa 18 Deo Lang age Selecon cenn ee or r E E ee 19 34 User EE 20 25 E RE 22 E Up WACK UY SEL c eeaeee 24 4 1 brmaicdhg c 24 S MEMENTO OP 25 4 3 Ba k p Schedules D E 26 LE MEMLDCIMb Jic 27 MEE e dodi m 28 4 6 PuelPos Backup ComiDaill EE 30 eq PEE I m Tm 32 45 Retention Policy aggies 33 49 Network Mapped EE bb niisiis desea ocupa UM EN eC 34 4 10 Local Copy P 35 4 11 Multiple Computers using one backup account esee 39 4 12 Transfer Block SDIB oua eb OPTED REIN DANDI Rei M Ut M DUM
53. ataboks Offsite Backup Server you need to install DataboksOBM DataboksOBM onto your computer 2 4 Installation of DataboksOBM Please follow the instructions below to install DataboksOBM onto your computer i Click the one of the language links under the Download Client Software section ffsite k 6 oft Intemet Explorer ol x Sep epp MAO peu IAD HAW EIS Welcome to Offsite Backup Server v4 6 OEM Edition Welcome to Offsite Backup Server v4 6 If you are Key Features Ten dat accessing this page using a web browser you have rotect business data started up Offsite Backup Server successfully Protect all desktops and easily notebooks easily Reduce work load e Support Windows Linux Error free Mac NetWare Solaris Save money and time Support Exchange Backup Server Management 1 OBS System Management Console Allow system administrator to manage the backup system e g server configuration and user accounts management English Czech Danish Dutch French German Icelandic Spanish Swedish Simplified Chinese Traditional Chinese Backup Client Man Download Client Software Download and install backup client software English Czech Danish Dutch French German Icelandic Spanish Swedish Simplified Chinese Traditional Chinese OBS User Confiquration Console optional Allow users to access their backup files and settings through a web browser Icelandic Spanis
54. backed up If you add Oo Nothing under this directory will be backed up 4 3 Backup Schedule A backup schedule defines the frequency and the time backup will run automatically Page 26 Ahsay Offsite Backup Server v4 6 Online Backup Manager Backup Set Backup Restore Tools View User s Guide l pataBoxs O1 x VW Save Setting gt Start Backup mw Stop Backup amp Backup Controller fj User Profile amp d3 FileBackupSet 1 D Backup Source E Command Line Tool Cf Setting B Encryption D In File Delta amp Local Copy H A MSSQ LBackupSet1 OracleBackupSet 1 MSExchangeBackupSet 1 LotusBackupSet 1 H E MySQLBackupSet 1 m E j Backup Restore j L Welcome to Online Backup Manag fd Backup Schedule FileBackupSet 1 ule 1 Properties Name BackupSchedule 1 r Backup Files Type C Daily Weekly C Monthly C Custom Day Backup on the following day s every week Sunday IT Monday Tuesday Wednesday Thursday Friday v Saturday Start Start Time hh mm E sl 00 sl r Stop Stop on completion Full Backup C Stop afier B hour s Properties p 2005 06 28 14 51 Backup schedule can be in one of the following types Type Description Daily Backup jobs will run everyday Weekly Backup jobs will run on the specified day s of every week Monthly Backup
55. ckup finished successfully in this field If you happen to get something else please consult the attached full report for more information New Files Total number and size of backup files added to your backup set Updated Files Total number and size of backup files updated in your backup set Deleted Files Total number and size of backup files deleted from your backup set Moved Files Total number and size of backup files relocated in your backup set Login Name Login name Alias Alias Page 110 Ahsay Offsite Backup Server v4 6 User s Guide l pataBoKs Language Preferred Language for your backup report Contact Email Address that will be used to contact you Backup Source All files directories that will be backed up Backup Data Size The total backup data stored in the data area Retention Area Size The total backup data stored in the retention area Old copies of updated or deleted backup files are retained in the retention area for the number of days as specified by the retention policy of the backup set before they are removed from the system Backup Quota Backup Quota Remaining Quota Remaining Quota The full backup report which contains a full listing of all files backed up by the backup job is attached to the backup job report email as a zip file You need to unzip it before you can read the full report Sample Report Backup Job Full Backup Repo
56. cle Database Server Enable MySQL Database Server Enable Lotus Domino Enable Lotus Notes Enable In File Delta Enable Update Reset Key Description Quota Backup Quota Data Area Total number and size backup files stored in the data area Retention Area Total number and size of backup files stored in the retention area Total Upload Total number and size of backup files uploaded to the backup server Page 115 l pataBoxs Ahsay Offsite Backup Server v4 6 User s Guide Total Restore Total number and size of backup files restored from the backup server Login Name Login name Display Name Alias of your backup account Language Preferred Language for your backup report Time Zone Your Time zone Contact Email Address that will be used to contact you 14 3 Request Forgotten Password If you have forgotten your password you can retrieve it by simply entering your login name or your registered email address on the Password Request form and press the Request button Your password will be sent to your registered email address automatically A Online Bac Install Software nt Console Microsoft Intemet Explorer FAQs Help Select Language Password Request Easy to use S ldem Fully Automated Login Name demol or Daily backup Email Save you time and y money At a glance How to retrieve your forgotten password Backup y
57. count Name setting has been updated Please confirm the information Language English shown on the right is correct Please make sure your settingis Contact user your company com not updated by someone on your contact list If none of them Backup Quota 50M makes this changes change your password correct your setting and see ifthis happens again If this happens again please contact us for further investigation If further assistance is necessary please refer to the FAQs section Backup Set BackupSet 0 Source s CAMy Documenti Schedule s None Filter None Retention Policy Keep deleted files for 7 days Transfer Size 256k bytes Pre Command s None PostCommand s None Key Description Login Name Login name Alias Alias Language Preferred Language for your backup reports Contact Email Address that will be used to contact you Backup Quota Backup Quota Backup Source s All backup sources of the backup set Backup Schedule s All backup schedules of the backup set Filter s All backup filters of the backup set Retention Policy The retention policy of the backup set Transfer Size The transfer block size of the backup set Pre Command s All Pre Command s of the backup set Post Command s All Post Command s of the backup set Page 113 Ahsay Offsite Backup Server v4 6 13 5 Inactive User Reminder User s Guide l pataBoxs You will receive
58. ctions on the installation wizard to complete installation b Expand the zip archive and run the DataboksOBM installer inside the archive Upgrade instructions of DataboksOBM on Linux a Download the latest release bundle obm linux tar gz from the web installation guide Page 13 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS a Intemet Explorer ll Select your Operation System RW 2 solaris Installation Guide OBM Linux System Requirement e Operating System Linux Kernel 2 2 or above e g Redhat 6 0 or above Memory 128 Mbytes Disk Space 100 Mbytes Network Protocol TCP IP Http Https Additional Requirement o The Standard C libraries for backwards compatibility compiler compat libstdc x x y y i386 rpm are required to run Online Backup Manager correctly If it is not installed already please download and install this library from your Linux vendor Download Online Backup Manager obm linux tar gz Get Started X Window Mode Started X Window Mode 1 Download the setup file obm linux tar gz above and run it 2 Setthe OBM HOME environment variable directory to where Online Backup EI M e enee Ae te ken Zeck allen di b Stop running backup scheduler by running touch OBM_HOME ipc Scheduler stop C Backup existing installation by renaming OBM HOME default directory is usr local obm to 0BM_HOME bak mv usr local obm usr local obm bak d Expand
59. d up V DH menagerie Iv H mysal Iv ij test Temporary directory for storing backup files CABackupMySQL Change Previous Ne e Enter a temporary directory for storing the backup files before they are sent to an Databoks Offsite Backup Server e g C Backup MySQL Page 104 Ahsay Offsite Backup Server v4 6 User s Guide f g l pataBoxs Set the backup schedule for Database Backup r Backup Schedule Please schedule the backup time BackupSchedule Type Weekly Friday Add Remove Properties Previous i j Cancel Set the encryption algorithm encryption mode and encrypting key for this backup set Encryption Setting Please setup the encryption setting of the Backup Set Do NOT use encryption Algorithm AES Mode CBC Cipher Block Chaining C ECB Electronic CookBook Encrypting Key pe Confirm Encrypting Key Ie Cancel Hint For maximum security please select AES Advanced Encryption Standard Algorithm CBC Cipher Block Chaining mode and use an encrypting key with more than 8 characters Page 105 l nataeos Ahsay Offsite Backup Server v4 6 User s Guide iii Run Backup a Select the backup set you want to run on the left panel and press the Start Backup button f b Select Off site Backup Server to start backing up your files to an Databoks Offsite Backup Server and press the OK button
60. de DATABOKS RMAN gt connect target connected to target database not started RMAN gt startup mount connected to target database not started Oracle instance started database mounted Total System Global Area 269556596 bytes Fixed Size 453492 bytes Variable Size 243269632 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes RMAN gt recover database until sequence 63 thread 1 Starting recover at 24 JUN 03 allocated channel ORA_DISK_1 channel ORA_DISK_1 sid 11 devtype DISK starting media recovery archive log thread 1 sequence 56 is already on disk as file C ORACLE ORADATA VIN ARCHIVE 1_56 DBF archive log filename C ORACLE ORADATA VIN ARCHIVE 1_56 DBF thread 1 sequence 56 archive log ORACLE ORADATA VIN ARCHIVE 1_57 DBF thread 1 sequence 57 archive log ORACLE ORADATA VIN ARCHIVE 1_58 DBF thread 1 sequence 58 archive log ORACLE ORADATA VIN ARCHIVE 1_59 DBF thread 1 sequence 59 archive log ORACLE ORADATA VIN ARCHIVE 1_60 DBF thread 1 sequenc 0 archive log filename C ORACLE ORADATA VIN ARCHIVE 1_61 DBF thread 1 sequence 61 archive log filename C ORACLE ORADATA VIN ARCHIVE 1_62 DBF thread 1 sequence 62 media recovery complete Finished recover at 24 JUN 03 RMAN alter database open resetlogs database opened Page 73 Ahsay Offsite Backup Server v4 6 User s Guide 9 l pataBoxs Backup Restore Microsoft SQL Server 7 0 2000 This chapter will describe in details how t
61. ded to the backup server This delta file is assumed to be small because the content of all PST files doesn t change lot of even after it has been updated iv Subsequent backups of this 10GB Outlook pst file will go through step ii and step iii again As explained only a small delta file will be uploaded to the backup server v With in file delta technology daily backing up of large file over low speed internet connection is now possible All delta files are generated with respect to changes made since the last full backup file i e differential backup This means that only last full backup file and the last delta file are required to restore the latest snapshot of a backup file This means that other intermediate delta files are only required if you want to restore other snapshots of a backup file The full backup file its checksum file and the last delta file uploaded if more than one delta files have been uploaded to the backup server are always stored in the data area This means that these files are not affected by the setting of the retention policy and will always be kept on the backup server This is done this way because all these files are required to get the latest snapshot of the backup file and they should not be removed from the backup server by the retention area cleanup routine All other intermediate delta files are stored in the retention area Page 62 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS zn Onlin
62. e Demonstration Account Email Address demo your company com Add Remove Properties amp Backup i Restore welcome to Online Backup Manager Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 C Enter a name for your backup set Page 44 l nataeos Ahsay Offsite Backup Server v4 6 User s Guide Add new File Backup Se FileBackupSet 1 Frevigus d Select the files directories you want to backup Add new File Backup Set ka G Favorites a ME Desktop V 3 My Documents 2 Options W My Computer a Han Floppy A DI ze Data C 1 7 ze Win2003 D H 0 s Win2000 E a s Temp F 7 2 DVD R Drive 63 e Set the backup schedule Note You can have more than one schedule in a backup set Page 45 l nataeos Ahsay Offsite Backup Server v4 6 User s Guide Add new File Backup Set jule 1 Type Daily f Set the encryption algorithm encryption mode and encrypting key for this backup set Hint For the sake of simplicity just select the Default radio button your encrypting key is set to be the same as your backup account password ew File Backup Set iii Run Backup Page 46 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS a Select the backup set you want to run on the left panel and press the Start Backup button P on the toolbar b Select Off site Backup Server
63. e Backup Manager E ini x Backup Set Backup Restore Tools View g Save Setting gt Start Backup w Siop Backup Backup Controller j User Profile gt 5 FileBackupSet 1 v Enable In File Delta 8 Backup Source Block Size Auto v Bytes fs Backup Schedule Backup Filter Maximum No of Delta 100 E Command Line Tool B In File Delta FileBackupSet 1 i OF Setting Apply to files BE i Minimum Size zs Mbytes E Delta Ratio MSSQ LBackupSet 1 EE H i STI De EDS TEC SON RETO ALS LU DLE T Tm Si OracleBackupSet 1 O 10 20 30 40 50 60 70 80 90 100 MSExchangeBackupSet 1 LotusBackupSet 1 MySQLBackupSet 1 Delta Ratio Delta Size File Size Ce r Temporary directory for storing backup files catemp Log Table FileBackupSet 1 e Start 2005 06 28 16 59 07 E Start running pre commands 2005 06 28 16 59 07 D Finished running pre commands 2005 06 28 16 59 07 D Downloading server file list 2005 06 28 16 59 07 sl Z Backup Restore Backup Completed Successfully Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 7 2 Block Size The block size defines the size of data block being used to detect changes between last full backup file and the file sitting on the local computer right now In general the smaller the block size the more likely
64. e Oracle J VM for Oracle 8i 9i please do the following 1 Please make sure shared pool size is larger than 50MB and java pool size is larger than 20MB in the PFILE For example java pool size 20971520 shared pool size 52428800 2 Runthe scripts below Oracle 8i Oracle 9i SVRMGRL gt connect internal SOL connect sys change on install as sysdba SVRMGRL javavm install initjvm sql SOL javavm install initjvm sql SVRMGRL gt rdbms admin catalog sql SQL gt xdk admin initxml sql SVRMGRL gt rdbms admin catproc sql SQL gt xdk admin xmlja sql SVRMGRL gt javavm install initdbj sql SQL rdbms admin catjava sql Page 65 Ahsay Offsite Backup Server v4 6 User s Guide iv l pataBoxs JAVASYSPRIV role is granted to system account You can grant this role to system account by executing SQL gt grant J AVASYSPRIV to system 8 2 Overview DataboksOBM will backup your Oracle database by taking the following steps vi Note Connect to the Oracle database using SQL NET over TCP IP Run all Pre Commands of this backup set If the backup type to run is Database Backup type a all data files in each of the tablespace s selected are copied to the temporary directory specified by this backup set b if there are temporary files in the database the script to re create the temporary files are generated to a file located in the temporary directory specified by this backup set
65. ed If you want to change the backup set type you have to create another backup set Page 24 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS En Online Backup Backup Set Backup Restore Tools View DI Save Setting gt StartBackup m Stop Backup Backup Controller X L I User Profile E Backup Set Name FileBackupSet 1 Type File Backup Backup Set FileBackupSet 1 Y Backup Source fs Backup Schedule amp Backup Filter Network Resources Authentication for Windows Command Line Tool Domain CF Setting User Name amp Encryption Password 3 In File Delta amp Local Copy Properties v Run scheduled backup on this computer j Log Table FileBackupSet 1 e Welcome to Online Backup Manager Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 4 2 Backup Source A backup source defines the files directories that are to be included in a backup set There are two types of backup source Selected and Deselected Selected backup source defines files directories that are to be included in a backup set while deselected backup source defines files directories that are to be excluded from a backup set Online Backup Manager will generate appropriate backup source setting for you automatically when you make your backup source selection on DataboksOBM Page 25 DATABOKS Ahsay Offsite Backup Server v4 6 User s Guide
66. ee previous sections for details iii Select the backup set you want to run on the left panel and press the Start Backup button f on the toolbar iv Select Local Hard Disk Seed Load Utility to start backing up your files to local hard disk and press the OK button Page 47 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS Confirm Backup Start Backup to Local Hard Disk Seed Load Utility Start the backup for FileBackupSet 1 OK Cancel v Enter a directory where you want all backup files to be stored in the Destination Directory field and press the Start button Please make sure you have enough free space in the directory specified If you are going to transport a removable hard disk to the offsite backup server please enter a directory under your removable hard disk here Backup Set FileBackupSet 1 Backup Type File Destination Directory ExSeed Loading Directory Browse vi You should get the message Backup Completed Successfully as shown below after all backup files are spooled to the directory you specified Page 48 l pataBoxs Ahsay Offsite Backup Server v4 6 User s Guide xi ard Di Backup Set FileBackupSet 1 Backup Type File Destination Directory JE Seed Loading Directory Browse Collecting all files in this backup set Completed Total Files 5 1 5 Processed C AUTOEXEC BAT 2 5 Processed CAboot ini 3 5 Proce
67. emoving OBM HOME rm rf 0BM HOME C Remove all backup setting by removing obm rm rf obm Page 16 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS Uninstallation instructions of DataboksOBM on Sun Solaris a Stop running backup scheduler by running touch OBM HOME ipc Scheduler stop b Remove all program files by removing 0BM_HOME rm rf OBM_HOME C Remove all backup setting by removing obm rm rf obm Page 17 Ahsay Offsite Backup Server v4 6 User s Guide 3 i DATABOKS Using DataboksOBM This chapter will describe all features available in DataboksOBM and outline how you can use the features of DataboksOBM to meet various backup needs 3 1 System Tray Launcher After you have successfully installed DataboksOBM to your computer an OBM icon will be added to the system tray area next to your system clock automatically Backup Backup and Logoff Backup and Restart E Backup and Shutdown Help Exit 14 46 This icon is the entry point to DataboksOBM Right clicking the icon will show a menu that provides the following functions Menu I tem What it does Open Run DataboksOBM Backup Run the backup set or all backup sets chosen in the sub menu in background Backup and Logoff Run the backup set or all backup sets chosen in the sub menu in background and logoff from Windows Backup and Restart Run the backup set or all backup sets
68. er database s sss 75 9 4 How to restore Microsoft SQL Server database s sss 78 10 Backup Restore Lotus Domino Notes 85 DEE Requirements iei or E poi n EEA dee aiu Isi Peu EE 85 102 MOV ouo rc E 87 10 3 How to backup Lotus Domino Notes database s file s 87 10 4 How to restore Lotus Domino Notes database s file s 9 11 Backup Restore Microsoft Exchange Server 2000 2003 sss 93 LI TR Gp Ge aa oe ees aca co a et e e e sE 93 112 AVI P 93 11 3 How to backup Microsoft Exchange Server 2000 2003 95 11 4 How to restore Microsoft Exchange Server 2000 2003 99 12 Backup Restore MySQL Seryetue oec eitis t teneirloicit eei ue acti RCM E et preteen 102 CNR e 102 ip ME OW CRI E 102 12 3 How to backup MySQL SE eret ike te i eot ixi deed 103 124 How to restore MySQL Server Ereegnes ede eee ieee 107 13 EE E 108 13 1 New User RS ccc 108 13 2 Forgot Password Report E 109 13 3 Buckup dob BepOtt ss eos vino ped idu nee ou Mp up DM MEE 110 13 4 Sethe Change EEN 113 l pataBoxs Ahsay Offsite Backup Server v4 6 User s Guide 13 5 Inactive EE 114 14 oos e 115 14 1 Install DdtabBORSODBNL u s erennere ag euni apad araia iais 115 14 2
69. es check the checkbox next to the files directories and press the Delete button 14 5 Review Backup Jobs In addition to reviewing your backup activities from the email report and from DataboksOBM you can also review any of your backup jobs by using the Report panel available on the web interface To review a backup job just select the required backup job from the Backup Set and Backup Job drop down list Page 117 Ahsay Offsite Backup Server v4 6 Online Backup Se Restore Install Software User s Guide anagement Console Microsoft Intemet Explorer l pataBoxs FAQs Help Select Lanquage CEAT EA FileBackupSet 1 m Backup Job 200 Job Status Backup finished successfully Backup Time 2005 06 28 22 16 2005 06 28 22 17 HKT ore Information detailed Report is Detaile hg Report Sag Backup Job Statistics User Account Statistics New Files O 0 bytes Updated Files 0 0 bytes Deleted Files 1 1 4M bytes Moved Files 0 0 bytes Unit Number of files Total file size Data Area 861k bytes Retention Area 1 4M bytes Total Upload 2 2M bytes Backup Quota 500M bytes Remaining Quota 497 8M bytes Key Description Job Status The overall status of the backup job Normally you should see Backup finished successfully in this field If you happen to get something else please click the Detailed Report images on the page Backup T
70. estore operation Backup devices can be created for files that you use frequently F MSSQL7 BACKUP m J C Backup device Y coe 7 Press the OK button to start restoring the master database Page 82 Ahsay Offsite Backup Server v4 6 User s Guide l pataBoxs C Restart Microsoft SQL Server in Normal Mode 1 Remove m parameter from the Startup Parameters as in previous step 2 Restart your Microsoft SQL Server as in previous step Optional Restore model msdb and distribution database You need to restore model database if you have changed the database template of your SQL Server You need to restore msdb database if you have changed the scheduling information or you want to restore the backup and restore history of your databases You need to restore distribution database if you are running the replication components of SQL Server You do not need to restore these databases if you just want to restore a user database For more information on Microsoft SQL Server model msdb and distribution database please visit http www microsoft com sql You need to restore each of these databases one by one To restore any of these databases please do the following a From Enterprise Manager gt Tools gt Restore Database b Select the database to be restored in the Restore as database drop down list C Select the From device radio button d Press the
71. ge 56 Ahsay Offsite Backup Server v4 6 User s Guide l pataBoxs 4Anixi Backup Set Backup Restore Tools View E Save Setting gt StartBacky C3 Unzip Local Copy amp Backup Controller Backup Set Name FileBackupSet 1 Type File Backup Network Resources Authentication for Windows f Backup Schedule amp Backup Filter E Command Line Tool Dornain Ci Setting User Name B Encryption Password DS In File Delta amp Local Copy amp MSSQLBackupSet 1 Lal OracleBackupSet 1 MSExchangeBackupSet 1 8 LotusBackupSet 1 EJ MyS LBackupSet 1 Properties v Run scheduled backup on this computer lm isl Log Table FileBackupSet 1 e Start 2005 06 28 16 59 07 E D Start running pre commands 2005 06 28 16 59 07 D Finished running pre commands 2005 06 28 16 59 07 Downloading server file list 2005 06 28 16 59 07 Reading backup source from hard d 2005 06 28 16 59 07 Downloading server file list Compl 2005 06 28 16 59 08 gt amp Backup Restore 3 Log Backup Completed Successfully Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 Use the Browse button to locate the files directory provided by your backup provider in removable hard disk or DVD which contains the backup files that you want to decrypt Full path to the files folder
72. geRestore exe from the bin directory under the installation directory of DataboksOBM e g C Program Files DataboksOBM bin ExchangeRestore exe to restore the exchange database s Simply run ExchangeRestore exe to print the usage Page 99 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS ExchangeRestore exe Usage C Program Files DataboksOBM bin gt ExchangeRestore exe Microsoft Exchange Server 2000 2003 Backup Recovery Utility Usage ExchangeRestore DIR path SERVER server TEMP tempDir SERVICE service STORAGE st orage DATABASE database DIR Directory containing all backup files SERVER Name of Exchange Server to be restored TEMP Temporary directory to be used during restore Please specific a path with plenty of free space SERVICE Name of Exchange Service to be restored It must be either Microsoft Information Store Microsoft Key Management Service or Microsoft Site Replication Service STORAGE Name of storage group to be restored DATABASE Name of database to be restored Examples 1 To restore an exchange server ExchangeRestore DIR C Backup SERVER ExchangeServer TEMP C Temp 2 To restore the information store ExchangeRestore DIR C Backup SERVER ExchangeServer TEMP C Temp SERVICE Microsoft Information Store 3 To restore an exchange storage group ExchangeRestore DIR C Backup SERVER ExchangeServer TEMP C Temp SERVICE Microsoft Information Store STORAGE St
73. h Swedish Simplified Chinese Traditional Chinese Server SQL Server Oracle Lotus Notes MySQL Support In File delta backup and real time data replication Secure and reliable Easy to use Or click the Install Software link available at the top of the Online Backup Services Management Console Page 8 DATABOKS Ahsay Offsite Backup Server v4 6 User s Guide 9 Services Me ent Console Microsoft Intemet Explorer lt nstall Software FAQs Help Select Lanquage Benefits Easy to use a ns Fully Automated E Daily backup Password Save you time and money Forgotten your password Login At a glance Backup your data researc one Check to see if your CAPS LOCK is on Both the Login Name and Password are case Access your data SES anywhere anytime ii If you have forgotten your password you Retain all backup files can use the Forgot Password Page to even those that have retrieve your password been deleted iii Please check if your system clock is correct Backup your data to Cookies may function incorrectly if your our secure data center system clock is incorrect Fire Earthquake Typhoon Your data is always safe Troubleshooting ii Select the operating system to which you want to install DataboksOBM Page 9 Ahsay Offsite Backup Server v4 6 User s Guide E Online Back ement C Microsoft Internet Explorer gt DATABOKS Select your Operatio
74. he attached full report for more information Page 111 l pataBoxs Ahsay Offsite Backup Server v4 6 User s Guide Backup Time The time when the backup job ran Backup Log All messages logged when running this backup job New Files Total number and size of backup files added to your backup set Updated Files Total number and size of backup files updated in your backup set Deleted Files Total number and size of backup files deleted from your backup set Moved Files Total number and size of backup files relocated in your backup set New File List Full list of all backup files added to your backup set Updated File List Full list of all backup files updated in your backup set Deleted File List Full list of all backup files deleted from your backup set Moved File List Full list of all backup files relocated in your backup set Page 112 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS 13 4 Setting Change Report After you have updated your user profile or backup setting a setting change report will be sent to you This report allows you to track record of the changes that have been made to your backup account Sample Report Backup Setting Changes Report Generated at SatJun 21 11 00 00 HKT 2003 Why are you receiving this report Login Name NewAccount You are receiving this report since your personal or backup Alias New Testing Ac
75. hsrvr mdbdata publ stm End Database Public Folder Store WIN2000SVR Start Restoring transaction log First Storage Group Restoring Log File F Temp restore tmp First Storage Group E00000B3 1log Restoring Log File F Temp restore tmp First Storage Group E00000B4 1log End Restoring transaction log First Storage Group Start Applying transaction log End Applying transaction log End Storage Group First Storage Group Start Storage Group SG2 Start Database acct Page 100 Ahsay Offsite Backup Server v4 6 User s Guide vi l pataBoxs Restoring file E Program Files Exchsrvr SG2 acct edb Restoring file E Program Files Exchsrvr SG2 acct stm End Database acct Start Restoring transaction log SG2 Restoring Log File F Temp restore tmp SG2 E0100072 1log Restoring Log File F Temp restore tmp SG2 E0100073 1log End Restoring transaction log SG2 Start Applying transaction log End Applying transaction log End Storage Group SG2 End Exchange Server WIN2000SVR E Program Files DataboksOBM bin gt Example 2 To restore the database named mail in storage group SG5 from backup available in F Backup to an exchange server named WIN2000SVR using the temporary directory F Temp you can use this command E Program Files DataboksOBM bin gt ExchangeRestore DIR F Backup TEMP F Temp SERVER WIN2000SVR SERVICE Microsof
76. i DATABOKS Databoks Offsite Backup Server v4 6 User s Guide Version 4 6 1 1d Jun 2005 i DATABOKS Databoks Offsite Backup Server v4 6 User s Guide Copyright Notice Databoks Company Limited 2005 All rights reserved Author Scherring Chong The use and copying of this product is subject to a license agreement Any other use is prohibited No part of this publication may be reproduced transmitted transcribed stored in a retrieval system or translated into any language in any form by any means without the prior written consent of Databoks Company Limited Information in this manual is subject to change without notice and does not represent a commitment on the part of the vendor Databoks does not warrant that this document is error free If you find any errors in this document please report to Databoks Company Limited in writing This product includes software developed by the Apache Software Foundation http www apache org Trademarks Microsoft Windows Microsoft Exchange Server and Microsoft SQL Server are registered trademarks of Microsoft Corporation Sun Solaris SPARC Java and Java Runtime Environment are registered trademarks of Sun Microsystems Inc Oracle Oracle 8i Oracle 9i are registered trademarks of Oracle Corporation Lotus Domino Notes are registered trademark of IBM Corporation Red Hat is registered trademark of Red Hat Inc Linux is registered trademark of Linus Torvalds Apple and Mac OS X
77. ile without uploading the whole database file everyday T 1 Overview In file delta technology is an advanced data block matching algorithm which has the intelligence to pick up changes delta of file content between two files when one of the files is not accessible and use the delta information between two files to rebuild one file from the other Using this algorithm daily backing up of large file e g a 10GB Outlook pst file over low speed internet connection is made possible because it requires only the changes of information should be marginal since last backup to be sent over a low speed internet connection to complete the backup of a large file here we assume that the full backup of the file has been saved on the backup server already This is what would happen to the backup of a 10GB Outlook pst file when it is backed up by DataboksOBM with in file delta technology i The whole files 10GB along with its checksum 128 bit file are backed up to the backup server This can be done directly through the internet or indirectly using the seed loading utility on a removable hard disk ii When backup is run again later normally the next day DataboksOBM will download a checksum listing of all data blocks of the full backup file from the backup server and use it to pick up all changes that have been made to the current Outlook pst file from the first full backup iii Changes detected are then saved in a delta file which is uploa
78. iles CABackup MSExchange Change Previous Next Cancel If this Exchange Server is also a domain controller of this Active Directory select the System State checkbox as well Otherwise please install DataboksOBM to the domain controller of this Active Directory and select the System State checkbox on that computer Enter a temporary directory for storing the backup files before they are sent to an Databoks Offsite Backup Server Set the backup schedule for Database Backup Page 96 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS Backup Schedule Please schedule the backup time Database Backup Schedule Type Database Weekly Friday Transaction Log Backup Schedule Type Transaction log Weekly w Add Remove Properties lt Previous Next gt Cancel f Set the backup schedule for Transaction Log Backup for Domino server only Note You can have more than one schedule in a backup set i e you can perform intra day transaction log backup by adding more than one daily transaction log backup schedule to your backup set g Set the encryption algorithm encryption mode and encrypting key for this backup set Encryption Setting em Please setup the encryption setting of the Backup Set Do NOT use encryption Algorithm Twofish e Mode CBC Cipher Block Chaining C ECB Electronic CookBook Encrypting Key Confirm Encrypting Key
79. ime The time when the backup job ran New Files Total number and size of backup files added to your backup set Updated Files Total number and size of backup files updated in your backup set Deleted Files Total number and size of backup files deleted from your backup set Moved Files Total number and size of backup files relocated in your backup set Backup Data Size The total backup data stored in the data area Retention Area The total backup data stored in the retention area Old copies of updated or Size deleted backup files are retained in the retention area for the number of days as specified by the retention policy of the backup set before they are removed from the system Total Upload Total number and size of backup files uploaded to the backup server Backup Quota Backup Quota Remaining Quota Remaining Quota Page 118 Ahsay Offsite Backup Server v4 6 You can open the Full Backup Report to review all information logged by a backup job by clicking l nataeos User s Guide the Detailed Report image on the Report panel Full Backup Report Files No Files Files Files Full Backup Report Backup Job Summary Backup Set BackupSet 0 Backup job 2003 06 21 09 58 Backup Status Backup finished successfull Backup Time 2003 06 21 09 57 2003 06 21 09 57 Ci Test lib New DANIEL DOC C Test lib DANIEL_4 BAK Ci Test KING1 BAK gt
80. in com or an IP address e g 192 168 1 1 If the Databoks Offsite Backup Server is not accepting connection from the standard ports Port 80 and 443 for http and https respectively you can append a semi colon and your custom port number to the host name of the Address field e g www backup provider com 8080 to connect to the server using the custom port number port 8080 in this case If you need to connect to the server through proxy just enter your proxy setting in the Proxy Setting section For SOCKS proxy both v4 and v5 without user authentication are supported 3 3 Language Selection You can switch the language of the DataboksOBM user interface by choosing the desired language available from the Language drop down list The languages available include English Czech Danish German Spanish Icelandic Dutch Swedish Traditional Chinese and Simplified Chinese Page 19 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS ckup Manager Logon Login Name demo t Password 1 p Language English sl User Name Password OK Cancel Options lt lt Please logon to Online Backup Manager 3 4 User Profile After the backup server authenticates you successfully DataboksOBM main window appears You can then use DataboksOBM to update your user profile Page 20 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS tt Online Backup Manage
81. inal locations Control files data files and archived logs are stored on Databoks Offsite Backup Server along with their full path information You just need to put all these files back to their original locations when performing a database restore Put the PFILE back to its default location Oracle 8i ORACLE HOME dbs init SID ora Oracle 9i ORACLE HOME admin SID pfile init ora Restore Database if Oracle 8i Use Server Manager to restore you database by doing the following a Run Oracle Server Manager svrmgrl b Connect to the target database Page 71 Ahsay Offsite Backup Server v4 6 User s Guide l pataBoxs C Startup mount d Reapply all transactions from the archived log files e Open database Oracle 8i Example svrmgrl SVRMGRL gt connect internal SVRMGR startup mount ORACLE instance started Total System Global Area 95874448 bytes Fixed Size 64912 bytes Variable Size 52744192 bytes Database Buffers 40960000 bytes Redo Buffers 2105344 bytes Database mounted SVRMGRL recover database using backup controlfile ORA 00279 change 419671 generated at 06 14 03 02 51 49 needed for thread 1 ORA 00289 suggestion data ora815 vin archive ARCH0000000225 L0G ORA 00280 change 419671 for thread 1 is in sequence 225 ORA 00278 log file data ora815 vin archive ARCH0000000224 LOG no longer needed for this recovery Specify log RET suggested filename AUTO CANCEL AUT
82. ipped amp may Raw Encrypted aresentinSSL Encrypted Mary 30 2 Data Ahsay Backup Manager can be configured to start automatically every night AIl user files created updated during the day will then be backed up to backup server on the same night without any user intervention File Allusers files are encrypted by a world first class 128 bit encryption algorithm with a user defined encrypting key File content is meaningless to everyone except user itself Run backup at scheduled time automatically Once you set your backup scheduled a backup job will be started automatically to perform backup operation for you at your absence You can have backup running at your scheduled time as often as you want e g twice a day or hourly during office hour without requiring doing any extra work Incremental Backup Unchanged files are already backed up to server and need not to be backed up again DataboksOBM will pick the new or updated files from your backup set files and upload only these files to the server It significantly reduces the time required to perform the backup operation since most users update less than 5 of their total data each day Compress and encrypt data automatically Data are compressed and encrypted before they are uploaded to the server Not only does it Page 43 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS reduce the storage space to keep you backup files it
83. ite Backup Server v4 6 User s Guide l pataBoxs 10 4 How to restore Lotus Domino Notes database s file s Please follow the instructions below to restore Lotus Domino server Notes client database s file s from an Databoks Offsite Backup Server Install Lotus Domino server Notes client back to its original folder if required Install DataboksOBM Please refer to the Installation section for information on how to install DataboksOBM onto your computer Copy LotusMediaRecovery exe from the bin directory default to C Program Files DataboksOBM bin to Lotus Domino installation directory default to C Lotus Domino Shutdown Lotus Domino Server If you want to perform a full domino restore restore all databases and files a Download the backup files to be restored from the Databoks Offsite Backup Server and save them back to its original location It includes notes ini all backup files from the lotus domino data directory and all archived transaction logs b Run LotusMediaRecovery exe from the Lotus Domino installation directory e g C Lotus Domino LotusMediaRecovery exe and press Y to continue For example C Lotus Domino gt LotusMediaRecovery exe This will run media recovery for all databases nsf and mail box found under the Lotus data directory e g C Lotus Domino Data You should see something similar to the screen below Media Recovery Example C Lotus Domino gt LotusMediaRecover
84. jobs will run on the specified day or on a day with a given criteria e g first weekend last weekday of every month Custom Backup job will run once on any particular date For each type of schedule above backup will run at scheduled time for a maximum of the duration specified or until all data are backed up if Stop on backup completion option is chosen If a backup job does not finish within the maximum duration specified it will be interrupted Please note that you can have more than one schedule within a backup set For example you can have a daily backup schedule that runs at 13 00 at noon and another daily backup schedule that runs at 00 00 at midnight The combination of both of these schedules effectively creates a backup schedule that runs daily at 00 00 and 13 00 everyday 4 4 In File Delta Please refer to the in file delta section for more information on this topic Page 27 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS 4 5 BackupFilter A backup filter defines the file selection rules that allow user to easily include exclude files into from the backup set by applying user defined criteria s to the file names or directory names Online Backup Manager E nml x Backup Set Backup Restore Tools View H Save Settin oan martin m Sinn Barkun p kup Filter Filter 1 fj User Profil l Ee 00 G ByFileBac Top Directory a amp Bad Browse Add new H
85. kup W Stop Backup Q Backup Controller fj User Profile amp d3 FileBackupSet 1 a Backup Source G Backup Schedule amp Backup Filter E Command Line Tool Cf Setting amp Encryption D OracleBackupSet 1 MSExchangeBackupSet 1 LotusBackupSet 1 o Lal MySQLBackupSet 1 amp Backup ax Local Copy FileBackupSet 1 r Copy to CALocalBackup Change K Zip copied file s Yes C No fs Log Table FileBackupSet 1 Welcome to Online Backup Manager Check the Copy to Local Hard Disk checkbox Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 Enter a directory to where you want an extra copy of your backup files to be stored in the Copy to field provided preferably a directory under another hard disk Optional Select the Yes radio button if you want to store your backup files in compressed form to conserve free space usage An extra copy of backup will be saved in the Copy to directory when you run your backup job Page 36 l pataBoxs Ahsay Offsite Backup Server v4 6 User s Guide n Online Backup Manager Backup Set Backup Restore Tools View g Save Setting gt Start Backup W Slop Backup amp Backup Controller dX Gy Backup Set FileBackupSet 1 Eg User Profile Backup Set E Ne REES Name FileBack
86. lled onto the computer running MySQL server Data from MySQL server will be backed up to a temporary directory before they are sent to Databoks Offsite Backup Server Please make sure you have sufficient space on your computer to store these data when you run the backup job There must be a MySQL account can be used to connect from localhost Add two new MySQL accounts for Databoks Backup Manager mysql gt GRANT ALL PRIVILEGES ON TO root localhost gt IDENTIFIED BY some pass mysql gt GRANT ALL PRIVILEGES ON TO root localhost localdomain gt IDENTIFIED BY some pass mysql gt FLUSH PRIVILEGES They are superuser accounts with full privileges to do anything with a password of some_pass 12 2 Overview DataboksOBM will backup your MySQL server by taking the following steps Run all Pre Commands of this backup set All database s selected are backed up to a temporary directory specified in its backup set Run all Post Commands of this backup set Upload all backup files from the temporary directory to an Databoks Offsite Backup Server Page 102 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS 12 3 How to backup MySQL server Please follow the instructions below to backup your MySQL server using DataboksOBM i Open DataboksOBM Right click DataboksOBM icon available in the system tray and choose Open Backup Backup and Logoff Backup and Restart Backup and Shutdown wow ow
87. mino does not run the Fixup task automatically and notifies the administrator to run the Fixup task with the J parameter on corrupt logged databases Runtime Restart performance This field controls how often Domino records a recovery checkpoint in the transaction log which affects server performance To record a recovery checkpoint Domino evaluates each active logged database to determine how many transactions would be necessary to recover each database after a system failure When Domino completes this evaluation it e Creates a recovery checkpoint record in the transaction log listing each open database and the starting point transaction needed for recovery e Forces database changes to be saved to disk if they have not been saved already Choose one Standard default and recommended Checkpoints occur regularly Favor runtime Domino records fewer checkpoints which requires fewer system resources and improves server run time performance e Favor restart recovery time Domino records more checkpoints which improves restart recovery time because fewer transactions are required for recovery Logging style Choose Archive The default is Circular Notes You can only run transaction log backup if you have transaction logging enabled and you are using archive mode This command does not apply if you have transaction logging enabled not in archive mode or if transaction logging is not enabled at
88. n amp amp FileBackupSet 1 Typ L Backup Source Algorithm AES fi Backup Schedule Mode CBC amp Backup Filter 7 Command Line Tool iam e In File Delta amp Local Copy MSSQLBackupSet 1 OracleBackupSet 1 MSExchangeBackupSet 1 LotusBackupSet 1 MySQLBackupSet 1 E IW RH amp amp Backup Restore j Encrypting Key Fe v Mask Encrypting Key EE Log Table FileBackupSet 1 Welcome to Online Backup Manager Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 Parameter Description Encryption Algorithm It defines the encrypting algorithm used to encrypt your backup files There are three encryption algorithms available AES Advanced Encryption Standard algorithm DESede Triple DES algorithm Twofish Twofish algorithm We recommend the use of AES as it has been chosen as the encryption standard for commercial use Please refer to references on Cryptography for more information on this area Encryption Mode It defines the encrypting mode used to encrypt your backup files There are two encryption modes available Page 32 l pataBoxs Ahsay Offsite Backup Server v4 6 User s Guide ECB Electronic Cook Book Mode CBC Cipher Block Chaining Mode We recommend the use of CBC mode as it offers better security Please refer to references on Cryptography for more information on this area Encry
89. n System solaris Sp Installation Guide OBM Windows System Requirement Requirement Operating System Windows 95 98 ME NT 2000 XP 2003 Memory 128 Mbytes Disk Space 100 Mbytes Network Protocol TCP IP Http Https Additional Requirement o Windows 95 Please download and install Windows Socket 2 Update for Windows 95 w9Sws2setup exe o Windows NT 2000 XP 2003 Please make sure you have logged onto Windows using an account with administrative privileges Download Online Backup Manager obm win exe Get Started 1 Download the setup file obm win exe above and run it 2 Follow the instructions on the installation wizard to complete installation iii Follow the instructions on the installation guide to complete DataboksOBM installation Notes on Windows Installation A quick launcher is now installed in the system tray next to your system clock To open DataboksOBM just right click the quick launcher icon Th and choose Open Backup Backup and Logoff Backup and Restart Backup and Shutdown Help Stop Running Backup b b b b Exit 14 46 Page 10 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS 2 2 Upgrade of DataboksOBM This section describes the software upgrade instructions required to upgrade DataboksOBM to the latest release Upgrade instructions of DataboksOBM on Windows Download the latest installer obm win exe from the
90. n on how to retrieve your forgot password report The Forgot Password Report contains the following information Sample Report Request for forgotten password Generated at Sat Jun 21 09 47 14 HKT 2003 FAQs 1 Why are you receiving this report Login Name NewAccount When a user visits the forgot password page and requests Password pwd for the lost password ofthis backup account all registered Alias New Testing Account Name contacts ofthis particular account will receive a password Language English reminder email If none ofthe contact person has visited Contact user your company com the page above and you are receiving this email in error please contact us 2 What should you do after reading this email Your current password is shown under the user setting You are suggested to change your password to a more easily remembered password and delete this email to avoid any third party gaining your password Key Description Login Name Login name Password Password Alias Alias Language Preferred Language for your backup report Contact Email Address that will be used to contact you Page 109 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS 13 3 Backup Job Report For each backup job you have run a backup job report will be sent to you by email This report contains a summary for the backup job that was run and a full listing of all files being backed up by the back
91. n your backup set Deleted File List Full list of all backup files deleted from your backup set Moved File List Full list of all backup files relocated in your backup set Page 119 l pataBoxs Ahsay Offsite Backup Server v4 6 User s Guide 14 6 Review Storage Statistics You can review the amount of data you have stored on the backup server and uploaded to the backup server on each day by opening the Statistics panel available on the web interface To review your storage statistics for a different month just select the month you are after by selecting from the Month drop down list E Online Backup Services Ma a Restore Install Software ement Console Microsoft Intemet Explorer FAQs Help Select Lanquage LE Month YYYY MM 2005 06 Storage Usage Summary 2005 06 01 2005 06 02 2005 06 03 2005 06 04 2005 06 05 2005 06 06 2005 06 07 2005 06 08 2005 06 09 2005 06 10 2005 06 11 2005 06 12 2005 06 13 2005 06 14 2005 06 15 2005 06 16 2005 06 17 2005 06 18 2005 06 19 2005 06 20 2005 06 21 2005 06 22 Data 4rea 209 7M 1394 209 7M 1394 209 7M 1394 209 7M 1394 98 6M 1536 98 6M 1536 98 6M 1536 98 6M 1536 98 6M 1536 56 4M 843 56 4M 843 56 4M 843 66 7M 1140 66 7M 1140 66 7M 1140 66 7M 1140 66 5M 1075 66 5M 1075 Retention Area 816 5M 3076 768 5M 3081 768 5M 3081 768 5M 3084
92. nagement Service Exchange 2000 only Similarly if you have setup your Exchange Server with Key Management Services enabled please make sure that you backup the key management database as well DataboksOBM will backup your Microsoft Exchange Server by taking the following steps vi Run all Pre Commands of this backup set If the backup type to run is Database Backup type a Windows System State will be backed up to a temporary directory specified in its backup set b All exchange database s selected are backed up to a temporary directory specified in its backup set If the backup type to run is Transaction Log Backup type a New transaction log extents generated since last backup will be copied to the temporary directory Remove transaction log extents backed up from the Exchange Server Run all Post Commands of this backup set Upload all backup files from the temporary directory to an Databoks Offsite Backup Server Page 94 Ahsay Offsite Backup Server v4 6 User s Guide l pataBoxs 11 3 How to backup Microsoft Exchange Server 2000 2003 Please follow the instructions below to backup your Microsoft Exchange Server 2000 2003 using DataboksOBM Open DataboksOBM Right click DataboksOBM icon available in the system tray and choose Open Backup gt Backup and Logoff D b Backup and Restart Backup and Shutdown Help Stop Running Backup P Exit From the Menu Choose Backup Set
93. nimum File Size The Minimum File Size setting defines the smallest file size a file must have before the use and application of in file delta backup technology If the size of a file that is being backed up is smaller than the Minimum File Size setting in file delta backup technology won t be applied to this file and the whole file instead of just the delta file will be uploaded to the backup server It is not necessary to perform in file delta backup on small files because backing up the whole file doesn t take too long anyway Backing up the whole file instead reduces the time required to restore a backup file 7 5 Delta Ratio The Delta Ratio setting is defined to be the size of a delta file divided by the size of its full backup file i e the percentage of changes detected between the last full backup file and the current file If delta ratio calculated from the size of the generated delta file and the size of the full backup is greater than the Delta Ratio setting the whole file instead of just the delta file will be backed up to the backup server It is done this way because the difference between backing up the whole file and the delta file is not significant and it is better to upload the whole file instead to reduce the time required to restore the file The default setting of Delta Ratio is 50 This means that if more than 50 changes have been detected the whole file instead of just the delta file will be backed up
94. o use DataboksOBM to backup your Microsoft SQL Server 7 0 2000 server and how you can restore your Microsoft SQL Server 7 0 2000 server from the backup files 9 1 Requirements DataboksOBM must be installed onto the computer running Microsoft SQL Server Data from Microsoft SQL Server will be backed up to a temporary directory before they are sent to Databoks Offsite Backup Server Please make sure you have sufficient space on your computer to store these data when you run the backup job 9 2 Overview DataboksOBM will backup your Microsoft SQL Server database s by taking the following steps Before running any backup activities DataboksOBM will run all Pre Commands of the backup set For each database that is to be backed up DataboksOBM will issue a database transaction log backup command to Microsoft SQL Server to backup each database to a Microsoft SQL Server database backup file bak file and save it in the temporary directory you specified After all bak files have been spooled to the temporary directories DataboksOBM will run all Post Commands of the backup set Upload all files copied to the temporary directory to the Databoks Offsite Backup Server Page 74 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS 9 3 How to backup Microsoft SQL Server database s Please follow the instructions below to backup your Microsoft SQL Server databases using DataboksOBM v Open DataboksOBM Right click Dat
95. og d Restart Lotus Domino server vi If you just want to restore a single database a Download the database file to be restored from the Databoks Offsite Backup Server and save them back to its original location b optional If you need to perform media recovery on this database please download all archived transaction logs and save them back to its original location C Run LotusMediaRecovery exe from the Lotus Domino installation directory with an argument of the full path of database to be restored For example if you want to restore C Lotus Domino data admin4 nsf please run C Lotus Domino gt LotusMediaRecovery exe C Lotus Domino data admin4 nsf You should see something similar to the screen below Media Recovery Example C Lotus Domino gt LotusMediaRecovery C Lotus Domino data admin4 nsf Media Recovery Utility for Lotus Domino 5 0 or above Running media recovery Restart Analysis 0 MB 100 02 12 2003 14 42 15 Recovery Manager Restart Recovery complete 0 0 databases needed full partial recovery Media Recovery Replay 122 MB 10 20 30 40 50 60 70 80 90 100 02 12 2003 14 42 17 Recovery Manager Media Recovery complete for C Lotus Domino data admin4 nsf last update applied 01 12 2003 00 02 42 Backup file C Lotus Domino data admin4 nsf recovered C Lotus Domino gt d All content of the database are now rolled forward to the last committed transaction found in the la
96. on of the transaction log The default path name is LOGDIR in the Domino data directory although it is strongly recommended to store the log on a separate mirrored device such as a RAID Redundant Array of Independent Disks level 0 or 1 device with a dedicated controller The separate device should have at least 1GB of disk space for the transaction log If you are using the device solely for storing the transaction log set the Use all available space on log device field to Yes Maximum log space The maximum size in MB for the transaction log Default is 192MB Maximum is 4096MB 4GB Domino formats at least 3 and up to 64 log files depending on the maximum log space you allocate Page 85 Ahsay Offsite Backup Server v4 6 l pataBoxs User s Guide Use all available space on log device Choose one e Yes to use all available space on the device for the transaction log This is recommended if you use a separate device dedicated to storing the log If you choose Yes you don t need to enter a value in the Maximum log space field e No to use the default or specified value in the Maximum log space field Automatic fixup of corrupt databases Choose one e Enabled default If a database is corrupt and Domino cannot use the transaction log to recover it Domino runs the Fixup task assigns a new DBIID and notifies the administrator that a new database backup is required e Disabled Do
97. orageGroupl 4 To restore an exchange database ExchangeRestore DIR C Backup SERVER ExchangeServer TEMP C Temp SERVICE Microsoft Information Store STORAGE StorageGroupl DATABASE Databasel where C Backup is the directory containing all backup files ExchangeServer is the server name of an exchange server C Temp is the temporary directory to be used StorageGroupl is the name of a storage group Databasel is the name of a database d Example 1 To restore all databases from backup available in F Backup to an exchange server named WIN2000SVR using the temporary directory F Temp you can use this command E Program Files DataboksOBM bin gt ExchangeRestore DIR F Backup TEMP F Temp SERVER WIN2000SVR Exchange Server Recovery Example E Program Files DataboksOBM bin gt ExchangeRestore DIR F Backup TEMP F Temp SERVER WIN2000SVR Microsoft Exchange Server 2000 2003 Backup Recovery Utility Start Exchange Server WIN2000SVR Start Service Microsoft Information Store Start Storage Group First Storage Group Start Database Mailbox Store WIN2000SVR Restoring file E Program Files Exchsrvr mdbdata privl edb Restoring file E Program Files Exchsrvr mdbdata privl stm End Database Mailbox Store WIN2000SVR Start Database Public Folder Store WIN2000SVR Restoring file E Program Files Exchsrvr mdbdata publ edb Restoring file E Program Files Exc
98. our Windows username password and domain name to authenticate itself to the windows domain controller to acquire the required access privileges to the network files which are to be backed up If you don t supply a username and password DataboksOBM will have problem accessing network resources in its scheduled backup jobs If you need to backup network mapped drive in scheduled backup please do this i Select the backup set from the left panel and press the Properties button Page 34 Ahsay Offsite Backup Server v4 User s Guide U DATABOKS 3l Backup Source Backup Schedule Backup Filter f Command Line Tool C Setting Bj Encryption In File Delta Local Copy windows domain demo user iii Press the Save Setting button on the toolbar 4 10 Local Copy If you want to save an extra copy of backup data on your local disk in addition to a copy of backup data stored on the backup server to minimize file restoring time and or to provide an extra safety precaution you can do the following i Open DataboksOBM from the System Tray see previous sections for details Page 35 Ahsay Offsite Backup Server v4 6 Setup your backup set See previous sections for details vi vii User s Guide l pataBoxs Select Local Copy under your backup set from the left panel n Online Backup Backup Set Backup Restore Tools View 5 Save Setting gt Start Bac
99. our data Mund every i Enter either your Login Name or Email in the Access your data ii Press the Request button anywhere anytime iii You should receive your password immediately Retain all backup files via email even those that have been deleted Backup your data to our secure data center Fire Earthquake Typhoon Your data is always safe form above 14 4 Delete Undelete Backup Files In addition to reviewing your backup activities from the email report and from DataboksOBM you can also review any of your backup jobs by using the Report panel available on the web interface To review a backup job just select the required backup job from the Backup Set and Backup Job drop down list Page 116 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS E Tomes nt Console Microsoft Intemet Explorer Restore Install Software FAQs Help Select Language Home gt FileBackupSet 1 gt 2005 06 28 22 17 gt C C Show files after Job 2005 06 28 22 17 z C Show allfiles Show Jobs View Delete Restore Undelete File Directory Last Modified Zipped Ratio kel dell img deleted 14M 2004 04 26 19 21 14M 2 Delete Restore Undelete Note 1 This shows all files directories within a backup job of a backup set 2 To restore files directories check the checkbox next to the files directories and press the Restore button 3 To delete files directori
100. ows backup to be scheduled at any time Compress and encrypt data automatically before sending them to the server server stores only encrypted data Increment backup strategy ensures that only new or updated files or changes with last backup file are sent to backup server Support both full backup database backup and incremental backup transaction log backup for Microsoft SQL Server 7 0 2000 Microsoft Exchange Server 2000 2003 Lotus Domino Notes 5 0 and Oracle 8i or above Can integrate with external Open File Manager to provide open file backup support to all open files Access backup data anytime anywhere by using a browser Comprehensive backup report lists all files being backup Backup report will be delivered to user automatically via email when each backup job completed Backup data are CRC validated before they are stored on server Customizable data retention policy allows user to access files even when they have been deleted Select files to be backed up easily by using backup filter e g selecting all doc and xls in your computer in a single operation Run any custom OS commands before after a backup job Run on Windows Mac OS X Linux NetWare Unix and all other platforms supporting a Jave2 Virtual Machine LiveUpdate allows patches to be deployed to hundreds of clients easily System activity report showing all backup system information will be delivered to system administrator via email everyday Page 6
101. p schedule for Transaction Log Backup for Domino server only Note You can have more than one schedule in a backup set i e you can perform intra day transaction log backup by adding more than one daily transaction log backup schedule to your backup set Page 89 Ahsay Offsite Backup Server v4 6 User s Guide h l pataBoxs Set the encryption algorithm encryption mode and encrypting key for this backup set Add new Lotus B Encryption Setting Please setup the encryption setting ofthe Backup Set Do NOT use encryption Algorithm Twofish e Mode CBC Cipher Block Chaining C ECB Electronic CookBook Encrypting Key Confirm Encrypting Key Previous Next gt Cancel Hint For maximum security please select AES Advanced Encryption Standard Algorithm CBC Cipher Block Chaining mode and use an encrypting key with more than 8 characters iii Run Backup C Select the backup set you want to run on the left panel and press the Start Backup button ki Select the backup type e g Database Transaction Log you would like to perform for Domino server only ackup Type LotusBackupSet 1 Backup C Transaction Logs Select Off site Backup Server to start backing up your files to an Databoks Offsite Backup Server C Local Hard Disk Seed Load Utility Start the backup for LotusBackupSet 1 OK Cancel Page 90 Ahsay Offs
102. pting Key The key used to encrypt all files within a backup set Please write it down on paper and keep it in a safe place If the key is lost you will not be able to recover your files from the encrypted backup files 4 8 Retention Policy During backup if DataboksOBM finds out that you have deleted a file or updated a file on your computer it will put the corresponding deleted or updated file already backed up on the backup server into a retention area The retention policy setting defines how long files inside the retention area will be kept on the backup server before they are deleted automatically from the server Retention policy will only affect retained file i e files that have already been deleted or updated on your computer For those files that have not been updated on your computer the backup of these files are kept in the data area on the backup server and won t be affected by the setting of retention policy These backup files of unchanged files will stay on the backup server forever until the original files are removed or updated from your computer You can choose to have retained files deleted automatically after a number of days or after a certain number of backup jobs To change the retention policy setting of any backup set please select the Setting node on the left panel to invoke the Setting panel on the right You can then make changes to your retention policy under the Retention Policy section
103. r Backup Set Backup Restore Tools View g Save Setting gt Start Backup m Stop Backup Ka amp Backup Controller User Profile 3 FileBackupSet 1 A Backup Source Login Name demo fs Backup Schedule amp Backup Filter Password Change User Profile r User Information E Command Line Tool Display Name Demonstration Account Change LR Setting S Encryption 1 In File Delta Account Information amp Local Copy Quota 500M Time Zone ewr o amp oo HKT sl r Contact derno your company com Contact Name Demonstration Account Email Address demo your company com Add Remove Properties Z Backup amp Restore s Welcome to Online Backup Manager Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 You can perform the following update to your user profile To change your Password press the Change button next to the password field A Change Password dialog will appear Enter your original password and new password into the text field of this dialog and press OK Old Password New Password Confinn New Password To change your Display Name press the Change button next to the display name field A Change Display Name dialog will appear Enter the new display name and press OK Change Display Name Display Name Demo Account OK Cancel Page 21 l pataBoxs Ah
104. r to restrict online file restoring for your backup sets by IP addresses to allow people from authorized IP addresses to restore files from the backup server To check if online file restore of any backup set is restricted this way please take a look at the web interface of DataboksOBS Online Backup Services Management Console gt Backup Set gt Online Restore IP restriction shown below Users are not allowed to update the Online Restore IP restriction directly Please ask your backup services provider to do the changes for you Page 60 Ahsay Offsite Backup Server v4 6 User s Guide p DATABOKS Intemet Explorer Restore Install Software 1 Name Command Working Directory SS Help Post backup command 1 Name IT Idi Command 2 T Directory Online Restore IP restriction 1 Only from 192 168 0 0 to 192 168 0 255 pdate Reset T i ate Reset Key Name Name of the backup set Backup Source Files Directories that are to be included into or excluded frorn the backup set Backup Schedule Schedules when backup should be performed automatically Enable In File Delta Enable In File Delta backup feature Page 61 Ahsay Offsite Backup Server v4 6 User s Guide 7 i DATABOKS In File Delta Technology The chapter describes what in file delta technology is and how in file delta can be used to backup large database files e g a 10GB Outlook pst f
105. roperties v Run scheduled backup on this computer Log Table FileBackupSet 1 e ype Start 2005 06 28 16 59 07 E Start running pre commands 2005 06 28 16 59 07 D Finished running pre commands 2005 06 28 16 59 07 3 Downloadina server file list 2005 06 28 16 59 071 pe Z Backup Restore Backup Completed Successfully Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 ii Select the required Backup Set from the drop down list Backup Set F eBackupset v r Source Directory c ALocalBackup Change r Destination Directory PRs o e 2005 06 28 22 25 22 Start 2005 06 28 22 25 22 Copying C LocalBackup C_ CONFIG SYS zip to D Restore C_ CONFIG SYS 2005 06 28 22 25 22 Copying C LocalBackup C_Mdrvnet img zip to IDARestoreVC WMrvnet ms 2005 06 28 22 25 22 Completed Successfully iii Fill in the Source Directory directory where Local Copy files are stored and Destination Directory directory to where you want Local Copy files to be Page 38 Ahsay Offsite Backup Server v4 6 User s Guide M DATABOKS restored iv Completed 4 11 Multiple Computers using one backup account If you want to backup multiple computers using a single backup account you need to create different backup sets to backup each individual computer Also for each installed copy of DataboksOBM
106. rs setting is not enabled because you don t want to include all files under C into the backup set Example 4 advanced Page 29 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS If you want to include everything except the log directory under C Applications into a backup set you should setup your backup filter as follows Top Directory Apply To Matching Type C Applications Directory true Regular Expression Matching Patterns log Filter Mode Exclude Include all others True Example 5 advanced If you want to include all directories named log from the backup set files with file name starting with B and ending with doc under C My Documents into the backup set you can use a regular expression of B doc to do your selection The filter backup can then be setup as follows Top Directory C My Documents Apply To File true Matching Type Regular Expression Matching Patterns B doc Filter Mode Include Exclude all others True 4 6 Pre Post Backup Command The command line tool feature has two major components the Pre Backup command and the Post Backup command You can use the Pre Backup or Post Backup commands to run any native OS operating system commands before or after running a backup job Page 30 l pataBoxs a Ahsay Offsite Backup Server v4 6 User s Guide Online Backup Manager lBl x B
107. rt Backup Job Summary Backup Set Generated at Sat Jun 21 10 00 05 HKT 2003 Backup Job Statistics 1 9k bytes BackupSet 0 2003 06 21 09 58 Updated files 1 9k bytes Deleted files 1 4k bytes Backup Time No Files No Files No Files LG Backup Sata Backup finished successfully CiNTestMibNNew DANIEL DOC C Test lib DANIEL DOC C Test lib DANIEL_4 BAK 4k 1996 11 29 18 45 Moved files 1 3k bytes Unit Number of files Total file size 2003 06 21 09 57 2003 06 21 09 57 Backup Logs Timestamp Backup Logs 2003 06 21 09 57 Start running pre commands 2003 06 21 09 57 Finished running pre commands 2003 06 21 09 57 Start running post commands 2003 06 21 09 57 Finished running post commands compressed Size Last Modified 2003 06 21 09 57 New Files Updated Files compressed Size Last Modified 2003 06 21 09 57 compressed Size Last Modified Deleted Files Moved Files No Files Size Last Modified 1 C Test KING1 BAK gt C Test lib KING1 BAK 3k 2003 06 05 12 35 Key Description Backup Set The name of the backup set Backup Job The name of the backup job which is the start time of the backup job Backup Status The overall status of the backup job Normally you should see Backup finished successfully in this field If you happen to get something else please consult t
108. rypt Files Wizard E Backup Server 3 6 CA D e CONFIG SYS Last Modified 2003 12 13 13 17 Size 1k 0 dell img Last Modified 2005 06 29 12 47 Size 1M 0 dell img Last Modified 2004 04 26 19 21 Size 1M O gronetimg Last Modified 2004 04 27 16 23 Size 856k vii Enter the directories to which you want backup files to be restored in the Decrypt Files to section and enter the Decrypting Key the same as the encrypting key of this backup set Decrypt Files viii Press the Start button Page 59 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS n Decrypt Files x Backup Set FileBackupSet 1 FILE Decrypt files to Original location TEE Browse be 2005 06 28 22 21 38 Start 2005 06 28 22 21 38 Initializing decrypt action 2005 06 28 22 21 38 Decrypting C Motet ng 2005 06 28 22 21 48 Decrypted C drvnetimg 854k bytes 2005 06 28 22 21 48 Skipping CACONFIG zz 2005 06 28 22 21 48 End ETTTETTTTTTTTTTTTTTTTTTTTTTTEELTTTTTTTTTTTTEEETETTTTTTTI Elapsed Time 854k bytes decrypted 10 sec elapsed Current File Time 0 sec Total 854k bytes 854k bytes decrypted Saving File To C divnetimg Decrypting Speed 85k bytes second Close Start Stop End 6 3 Restrict restoring files by IP addresses Online file restoring operation can be restricted by IP addresses You can ask your backup provide
109. s Active Directory It is important that Windows Active Directory is backup properly when backing up a Microsoft Exchange Server Active Directory is stored inside a Windows Server running as Windows domain controller If your Exchange Server is a domain controller you can simply backup the Windows System State of your Exchange Server If your Exchange Server is running as a member server you will need to install another copy of DataboksOBM onto the domain controller to backup the Windows System State of inside the domain controller For more information on Active Directory please refer to http www microsoft com windows2000 technologies directory ad de fault asp Microsoft I nformation Store Exchange Server stores all emails and documents inside its databases which are Page 93 Ahsay Offsite Backup Server v4 6 User s Guide l pataBoxs grouped together as storage groups inside Microsoft Information Store It is important that Microsoft Information Store is fully backup when backing your Exchange Server Microsoft Site Replication Service Microsoft Site Replication Service is installed automatically when exchange server site replication feature is enabled Microsoft Site Replication stores its runtime and configuration information inside its own database If you are running your Exchange Server with Site Replication Service enabled please make sure that you backup the site replication database as well Microsoft Key Ma
110. say Offsite Backup Server v4 6 User s Guide To change your Time Zone just select your time zone from the drop down list next to the time zone entry To add a new contact email to this account press the Add button in the Contact section A Add New Contact dialog will appear Enter a name and an email address in the text field provided and then press the OK button Add new Contact xj Contact Name Email Address OK Cancel To remove a contact email select the email that is to be removed from the email list and press the Remove button Press OK to confirm the removal To update a contact email select the email that is to be updated from the email list and press the Properties button A Update Contact Property dialog will appear After you have made the changes that you want press the OK button your company com Properties x Contact Name Demo Account Email Address demo your campany cam OK Cancel 3 5 Backup Logs All backup activities are logged to backup activity log files They are available for reviewing from DataboksOBM How to review backup activities You can review all your backup jobs by iv Select the Log tab available at the bottom of DataboksOBM v Select the Backup Job you want to review on the Log Controller panel Page 22 Ahsay Offsite Backup Server v4 6 Backup Set Backup Restore Tools View User s Guide DATABOKS g Save Setting
111. se setup the encryption setting ofthe Backup Set Do NOT use encryption Algorithm Mode CBC Cipher Block Chaining C ECB Electronic CookBook Encrypting Key Confirm Encrypting Key lt Previous Next Cancel Hint For maximum security please select AES Advanced Encryption Standard Algorithm CBC Cipher Block Chaining mode and use an encrypting key with more than 8 characters iv Run Backup a Select the backup set you want to run on the left panel and press the Start Backup button ki Page 70 Ahsay Offsite Backup Server v4 6 User s Guide l pataBoxs b Select the backup type e g Database Backup Archived Log Backup you would like to perform 3ackup Type OracleBackupSet 1 3 x Backup ei C Archived Logs OK Cancel C Select Off site Backup Server to start backing up your files to an Databoks Offsite Backup Server Confirm Backup Start E Backup to C Local Hard Disk Seed Load Utility Startthe backup for DracleBackupSet 1 OK Cancel 8 4 Howto restore an Oracle Database Please follow the instructions below to restore your Oracle 8i 9i databases from an Databoks Offsite Backup Server Download the backup files from the Databoks Offsite Backup Server Please refer to the Quick Start Backup File section for information on how to download backup files from Databoks Offsite Backup Server Put all data files back to their orig
112. se symbolic link to create a simple link to a directory from another directory This setting defines whether you want DataboksOBM to traverse any symbolic links encountered on your backup path To change the transfer block size of any backup set please select the Setting node on the left panel to invoke the Setting panel on the right You can then make changes to the Follow Symbolic Link After you have made your changes just press the Save Setting button on the toolbar Page 41 l pataBoKs Ahsay Offsite Backup Server v4 6 User s Guide 2H Online Ba z Command Line Tool Setting etting amp Encryption 3 In File Delta amp Local Copy G MSS LBackupSet 1 OracleBackupSet 1 MSExchangeBackupSet 1 LotusBackupSet 1 5 MyS LBackupSet 1 Page 42 Ahsay Offsite Backup Server v4 6 5 Backing up files User s Guide l pataBoxs This chapter describes how files are backed up by DataboksOBM to the backup server 5 1 How files are backed up The diagram below describes how DataboksOBM backup your files Backup Operations 1 Collect all files which are new or have been updated since last backup 2 Each of these files is zipped encrypted and securely backup to Ahsay Backup Server through File File i Secure Socket Layer SSL User s ayar SS Ah Say Server Authentication Backup Server _ User Directory parmeters amp CI Ahsay Directory e Zipped amp encrypted files Z
113. ssed C dell img 4 5 Processed CAdrenet img 5 5 Processed C drvnet2 img Start running post commands Finished running post commands Backup Completed Successfully Processed 3 1M 3206764 byte Start sip vii Transport the data specified in the Destination Directory field to the offsite backup server Page 49 Ahsay Offsite Backup Server v4 6 User s Guide I DATABOKS 6 Restoring files This chapter describes different ways files can be restored from to the backup server 6 1 Restore backup files directly from backup server You can use either DataboksOBM or the web restorer to restore backup files from the backup server Using DataboksOBM You can restore your data from the backup server Databoks by following instructions below i Open DataboksOBM from the System Tray see previous sections for details ii Select the Restore tab at the bottom part of DataboksOBM zn Online Backup Manager ini xl Backup Set Backup Restore Tools View D Save Setting gt Restore Files Log Controller 2 Gi Restore Source FileBackupSet 1 ileBackupSet 1 Show files after Job 2005 06 28 16 59 07 el C Show all files 6 59 07 E CONFIGSY ast WO ZUUJ T 2 13 13 17 Size 32 dell img Last Modified 2004 04 26 19 21 Size 1M drvnet img Last Modified 2004 04 27 16 23 Size 854k OracleBackupSet 1 MSExchangeBackupSet 1 Lo
114. st archived transaction log vii Restart Lotus Domino Server Page 92 Ahsay Offsite Backup Server v4 6 User s Guide l pataBoxs 11 Backup Restore Microsoft Exchange Server 2000 2003 This chapter will describe in details how to use DataboksOBM to backup your Microsoft Exchange Server 2000 2003 and how you can restore your Microsoft Exchange Server 2000 2003 from the backup files 11 1 Requirements Microsoft Exchange Server 2000 with Services Pack 3 and post SP3 update rollup installed Please refer to http www microsoft com exchange for more information or Microsoft Exchange Server 2003 DataboksOBM must be installed onto the computer running Microsoft Exchange Server 2000 2003 Data from Microsoft Exchange Server will be backed up to a temporary directory before they are sent to Databoks Offsite Backup Server Please make sure you have sufficient space on your computer to store these data when you run the backup job 11 2 Overview A Microsoft Exchange Server 2000 2003 stores its data in Windows Active Directory as well as in its databases To fully backup a Microsoft Exchange Server 2000 2003 you need to backup the following components Windows System State The Windows System State contains the information about your Windows system including Windows Active Directory A Microsoft Exchange Server 2000 2003 stores some of its configuration e g email accounts and mailbox properties inside Window
115. store files to Ee RENE Decrypting Key ej id 2005 06 28 22 01 42 Start 2005 06 28 22 01 42 Downloading restore file list 2005 06 28 22 01 42 Same file CYACONFIG SYS exists already 2005 06 28 22 01 42 Skipping CYACONFIG SYS 2005 06 28 22 01 44 CAdell img 1 4M bytes downloaded 2005 06 28 22 01 44 CAdrvnet img 854k bytes downloaded Saving drvnet img from 192 168 0 22 Estimated Total Restore Time 0 sec Total 2 2M bytes 2 2M bytes restored Estimated Restore Time 0 sec Total 854k bytes 854k bytes restored Saving File To CAdrvnetimg Restoring Speed 1M bytes second Close Start stop Enter the encrypting key which will be used to decrypt your backup files upon restoring your backup files Press the Start button 6 2 Restore backup files from removable hard disk If you want to restore lots of backup files from the backup server and you find it too slow to restore all your backup files from the backup server through the internet You can ask your backup services provider to send you all your backup files in removable hard disk or CD DVD However all backup files stored on backup server are in encrypted format You need to decrypt them back to their original format before you can use them To decrypt your backup files from removable media please do the followings i Open DataboksOBM from the System Tray ii Select the Tools gt Decrypt Files Wizard from the menu Pa
116. t Information Store STORAGE SG5 DATABASE mail1 Exchange Server Recovery Example E Program Files DataboksOBM bin gt ExchangeRestore DIR F Backup TEMP F Temp SERVER WIN2000SVR SERVICE Microsoft Information Store STORAGE SG5 DATABASE mail Microsoft Exchange Server 2000 2003 Backup Recovery Utility Start Storage Group SG5 Start Database mail Restoring file E Program Files Exchsrvr SG5 mail edb Restoring file E Program Files Exchsrvr SG5 mail stm End Database mail Start Restoring transaction log SG5 Restoring Log File F Temp restore tmp SG5 E0300012 1log Restoring Log File F Temp restore tmp SG5 E0300013 1log End Restoring transaction log SG5 Start Applying transaction log End Applying transaction log End Storage Group SG5 E Program Files DataboksOBM bin gt Repeat the same procedure for each database to be restored to the Exchange Server You can use Start gt Program gt Administrative Tools gt Event Viewer to check if there are any errors generated from the exchange databases restoring activities Completed Page 101 Ahsay Offsite Backup Server v4 6 User s Guide l pataBoxs 12 Backup Restore MySQL Server This chapter will describe in details how to use DataboksOBM to backup your MySQL server and how you can restore your MySQL server from the database backup files 12 1 Requirements DataboksOBM must be insta
117. the new client software to SOBM HOME 3t cd 0BM HOME tar xvfz obm linux tar gz e Start backup scheduler by running OBM_HOME bin Scheduler sh f You can then open DataboksOBM by running OBM_HOME bin BackupManager sh Upgrade instructions of DataboksOBM on Sun Solaris a Download the latest release bundle obm solaris tar gz from the web installation guide Page 14 Ahsay Offsite Backup Server v4 6 User s Guide DATABOKS at Console Microsoft Intemet Explorer Select your Operation System Mig solaris bld Print v D Installation Guide OBM Solaris solaris e Operating System Sun Solaris 2 5 or above e Memory 128 Mbytes e Disk Space 100 Mbytes e Network Protocol TCP IP Http Https Download OBM Online Backup Manager obm solaris tar gz Get Started X Window Mode Started X Window Mode 1 Download the setup file obm solaris tar gz above and run it 2 Set the OBM_HOME environment variable directory to where Online Backup Manager is to be installed export OBM_HOME usr local obm Set the JAVA_HOME environment variable directory where J2SE Java Runtime zl b Stop running backup scheduler by running touch OBM HOME ipc Scheduler stop C Backup existing installation by renaming OBM HOME default directory is usr local obm to OBM HOME bak 3t mv usr local obm usr local obm bak d Expand the new client software to 0BM HOME cd OB
118. thin the backup system is correct to receive the reports described in this chapter 13 1 New User Report User s Guide l pataBoxs When a new backup account is added to the backup server a new user report will be delivered to the contact email s of the new account The New User Report contains the following information Sample Report Welcome to Online Backup Services Generated at Sat Jun 21 09 32 36 HKT 2003 Getting started Login Name NewAccount 1 Login to our homepage Password pwd Alias New Testing Account Name 2 Follow the User s Guide to start using our backup Language English CES Contact user your company com Backup Quota Backup Server Further Information If further assistance is necessary please refer to the FAQs 50M backup your company com section Key Description Login Name Login name Password Password Alias Alias Language Preferred Language for your backup report Contact Email Address that will be used to contact you Backup Quota Backup quota Backup Server Backup server Page 108 Ahsay Offsite Backup Server v4 6 13 2 Forgot Password Report User s Guide l pataBoxs If you have forgotten your password you can use the Forgot Password feature available on the web interface to have your password delivered to you through email Please refer to Retrieve Forgotten Password section in the next chapter for more informatio
119. tusBackupSet 1 aj MyS LBackupSet 1 q Backup qf Restore Backup Completed Successfully Quota Remaining Total 500M 500M Last Backup 2005 06 28 14 51 Page 50 Ahsay Offsite Backup Server v4 6 User s Guide vi vii l pataBoxs Select the backup set from which you would like files to be restored from the left panel Select the snapshot of your backup files that you would like to restore from the backup server by using Show files after Job drop down list Select the files that you would like to restore and press the Restore Files button on the toolbar Estimated Total Restore Time Estimated Restore Time Saving File To Restoring Speed Close Use the Browse button to select the directory to where you want files to be restored or simply select Original location to restore files to their original path Files will be restored automatically as shown below a file won t be downloaded from the backup server again if an identical file exists on local path already Page 51 Ahsay Offsite Backup Server v4 6 User s Guide I DATABOKS En Restore Files Backup Set FileBackupSet 1 FILE Restore files to Original location L Browse 2005 06 28 21 57 01 Start 2005 06 28 21 57 01 Downloading restore file list 2005 06 28 21 57 01 Downloading Cdrvnet mg Total 854k bytes 2005 06 28 21 57 02 C rvnet img B54k bytes downloaded
120. uments Regular Expression Include Exclude all files directories with name matching a regular expression Filter Mode Defines whether you want to include or exclude matched files into from the backup set Also for those unmatched files you can choose to exclude if include filter type or include if exclude filter type them into from the backup set Example 1 If you want to backup only Word Excel and PowerPoint documents in your document directory e g C My Documents you should setup your backup filter as follows Top Directory Apply To File true Matching Type End With Matching Patterns doc xls ppt Filter Mode Include Exclude all others True C My Documents Example 2 If you want to backup all files excluding all exe dll and tmp in C Applications you should setup your backup filter as follows Top Directory C Applications Apply To File true Matching Type End With Matching Patterns exe dll tmp Filter Mode Exclude Include all others True Example 3 If you have made your selection of files all under C X from the backup source setting but you want exclude all images e g jpg and gif from your selection you should setup your backup filter as follows Top Directory C Apply To File true Matching Type End With Matching Patterns jpg gif Filter Mode Exclude Include all others false Please note that the Include all othe
121. up job The backup summary report contains the following information Sample Backup Summary Report Online Backup Job Report Generated at SatJun 21 10 00 05 HKT 2003 Backup Time 21 Jun 2003 09 57 21 Jun 2003 09 57 Login Name NewAccount Status Backup finished successfully Alias New Testing Account Name New Files 21 9k Language English Updated Files 1 9k Contact Duser your company com Deleted Files 1 4k Moved Files 1 3k Unit No of Files Total Size Backup Setting Backup Source CAMy Document A full listing of all backup files is available in the attached file Backup Statistics Backup Data Size 7 314k Retention Area Size 2 13k Backup Quota 50M FAQs Remaining Quota 49 7M 1 Why are you receiving this report Unit No of Files Total Size You are receiving this report because you are registered as one ofthe contacts of this Online Backup account and this particular account has performed a backup job recently 2 What if you have exceeded your quota If your recycle bin size is not empty you can empty your recycle bin to free up more space Please contact us for more information on how to increase your storage quota If further assistance is necessary please refer to the FAQs section Key Description Backup Time The time when the backup job ran Backup Status The overall status of the backup job Normally you should see Ba
122. upSet 1 Backup Source SE EI a na GE Log Table FileBackunSet1 EI CF Setting Downloading server file list Completed 2005 08 28 16 59 08 a D Encryption Reading backup source from hard disk Completed 2005 06 28 16 58 09 By In File Delta Local Copy Start running local backup 2005 06 28 16 59 09 amp Local Copy Local Copy Reading local backup files from hard disk 2005 06 28 16 59 09 SES Local Copy Reading local backup files from hard disk Completed 2005 06 28 16 59 09 WM OraciebackupSott G Local Copy Getting all files which have been added Completed 2005 06 28 16 59 09 Z Daarna 4 erst Copy Getting all fles which have been updated Completed 2005 06 28 16 59 09 MySQLBackupSet 1 Local Copy Getting all files which have been deleted Completed 2005 06 28 16 59 09 Local Copy Getting all files which have been moved Completed 2005 06 28 16 59 09 d Local Copy Total New Files 3 2005 06 28 16 59 09 9 Local Copy Total Updated Files 0 2005 06 28 16 59 09 Local Copy Total Deleted Files 0 2005 06 28 16 59 09 EN Local Copy Total Moved Files 0 2005 06 28 16 59 09 Local Copy New File Copying CACONFIG SYS to CALocalBackup 2005 06 28 16 59 09 d Local Copy New File Copying CAdell img to CALocalBackupiC 1d 2005 06 28 16 59 09 Local Copy New File Copying CAdrvnetimg to CALocalBackuplC 2005 06 28 16 59 10 EN Local Copy Finish running local backup 2005
123. y Media Recovery Utility for Lotus Domino 5 0 or above Please make sure that you have done the following 1 Reinstall Lotus Domino on this computer in the same directory 2 Restore Notes ini to the Lotus Domino installation directory e g C Lotus Domino 3 Restore Domino Data directory back to the directory defined in Notes ini e g C Lotus Domino Data 4 Restore all archived transaction logs to the directory defined in Notes ini e g C Lotus Domino Data logdir Continue Y or N y Running media recovery Please wait creating new transaction logs in directory C logdir 02 12 2003 14 39 19 Recovery Manager Restart Recovery complete 0 0 databases needed full partial recovery Media Recovery Replay 122 MB 10 20 30 40 50 60 70 80 90 100 02 12 2003 14 39 22 Recovery Manager Media Recovery complete for C Lotus Domino Data admin4 nsf last update applied Backup file C Lotus Domino Data admin4 nsf recovered Page 91 l pataBoxs Media Recovery Replay 122 MB 10 20 30 40 50 60 70 80 90 100 02 12 2003 14 40 57 Recovery Manager Media Recovery complete for C Lotus Domino Data statrep nsf last update applied Ahsay Offsite Backup Server v4 6 User s Guide Backup file C Lotus Domino Data statrep nsf recovered C Lotus Domino gt C All content of all database s are now rolled forward to the last committed transaction found in the last archived transaction l
124. you must configure DataboksOBM so that it only runs scheduled backup for its intended backup sets on its computer If this is not being setup properly scheduled backup job of the same backup set from different computers will both be started This will result in lots of checksum errors and files being deleted on the backup server To allow multiple computers to be backed up under a single backup account you are required to do the following for each computer that has been installed with DataboksOBM under the same backup account i Logon to one of the computers that has been installed with DataboksOBM under the same backup account ii Open DataboksOBM and select a backup set that is not intended to run on this computer from the left panel iii Uncheck the Run scheduled backup on this computer checkbox on the right panel Page 39 Ahsay Offsite Backup Server v4 6 User s Guide i DATABOKS En Online Backup b er ll xi Backup Set Backup Restore Tools View VW Save Setting gt Start Backup mw Stop Backup e Backup Controller ak Backup Set FileBackupSet 1 fj User Profile Backup Set ERC SE Backup Source Name FileBackupSet 1 fb Backup Schedule az IEEE amp Backup Filter Network Resources Authentication for Windows Command Line Tool Domain Cf Setting User Name amp Encryption Password 3 In File Delta amp Local Copy Properties MSSQLBackupSet 1 OracleBackupSet 1 IV Run

Download Pdf Manuals

image

Related Search

Related Contents

lnitiezevous aux microprocesseurs  Inter-Tech SM-1688  Full Contents  Instrucciones de planificación y montaje  取扱説明書 - 会社情報  Untitled  Fiche descriptive sur les zones humides Ramsar  Morphy Richards 48815  Le schéma directeur de projet  VR1® Leg Press Owner`s and Service Manual  

Copyright © All rights reserved.
Failed to retrieve file