Home

Ahsay Offsite Backup Server v4.4 User's Guide

1. Q a Edit SQL Server Registration properties Q E u Delete SQL Server Registration a set up your monitor your import or gi B Disconnect database SQL Server export data oe Stop solution Pause p Start UW New Cy Dat all tasks gt Mar seca View C Sup New Window from Here Delete Refresh Properties Help Page 77 Ahsay Offsite Backup Server v4 4 QL Serve erprise Manage onsole Roo osoft SQL Ser SQL Server Grou Console Window Help action view ros e gt m x P Pixel 0 ww Tree SQL Server Group 1 Item J Console Root zB e Microsoft SQL Servers EG SQL Server Group WIN20000 EN B Dime New SQL Server Registration CC Edit SQL Server Registration properties Delete SQL Server Registration 2151 le x All Tasks gt New Window from Here Delete Refresh 4 Properties Hela b Restore master database 2 3 From Enterprise Manager gt Tools gt Restore Database T SQL Server Enterprise Manager Console Root Microsoft SOL Servers SOL Server Groupi 0 x Console window Help e xl action vew Tos e gt Olm XS Dekla Moe TE Data Transformation Services gt f windows NT 5 Items Job Scheduling C Console Root Replication gt Started Taskpad E amp Y Microsoft 5 ag sau se B R SQL Server Query Analyzer
2. yv v v Help Stop Ruming Backup P Exit 14 46 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 Lotus Backup Set MSSQLBackupSet 1 MS Exchange Backup Set MS SQL Server Backup Set S LBackupSet1 rosoft SQL Server Backup Oracle Database Backup Set SQL Serer H E BackupSet 7 E I MyS LBackupSet 1 Login ID sa jj Backup Source Password 7 fa Backup Schedule bai Line Tool Properties etting B Encryption gt Log Table MSSQLBackupSet 1 welcome to Online Backup Manager Quota Remaining Total 49 9G 50G Last Backup 2004 07 22 14 32 Page 100 Ahsay Offsite Backup Server v4 4 User s Guide b Enter a name for your backup set Backup Set Please type a name for this Backup Set Name MyS0LBackupset1 Type MySQL Backup MySQL User Name root Password Hostlocalhost Port 3306 E to mysqldump oamysqntin Change Previous a Cancel C Enter the root password the MySQL server TCP IP port number and the path to MySQL backup utility mysqldump d Select the database s to be backup Add new MySQL m Backup Source Please select databases to be backed up M amp menagerie M E mysal M B test directory for storing ba
3. 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 iii Run Backup a Select the backup set you want to run on the left panel and press the Start Backup button b Select the backup type e g Database Transaction Log you would like to perform for Domino server only up Type LotusBackupSet 1 Backup ci C Transaction Logs C Select Off site Backup Server to start backing up your files to an Ahsay Offsite Backup Server Confirm Backup i Backup to Disie Baup Sevei Local Hard Disk Seed Load Utility Start the backup for LotusBackupSet 1 OK Cancel Page 27 Ahsay Offsite Backup Server v4 4 User s Guide 3 5 Quick Start Microsoft Exchange Server Backup This chapter will give you the information on how you can backup a Microsoft Exchange Server to Ahsay Offsite Backup Server using Ahsay Online Backup Manager 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 Ahsay Online Backup Manager must be installed onto the computer running Microsoft Exchange Server 2000 2003 Data from Microsoft Exchange Server will be backed up to a te
4. Confirm Backup Start Backup to Offsite Backup Server C Local Hard Disk Seed Load Utility Start the backup for MyS LBackupSet 1 Cancel Page 36 Ahsay Offsite Backup Server v4 4 C User s Guide You should get something similar to the screen shot below 3 User Profile OracleBackupSet 1 otus Notes MSSQLBackupSet1 MSExchangeBackupSet 1 ackupSet 7 Backup Source Gd Backup Schedule E Command Line Tool Q 2004 07 22 16 47 01 i re commands 2004 07 22 16 1 Finished running pre commands E 2004 07 22 16 47 01 Using Temporary Directory C Backup MySQL 1 088760442718 2004 07 22 16 47 01 Star Backing up database mysql to mysql sql 2004 07 22 16 47 01 i End 2004 07 22 16 47 01 Start running post commands 2004 07 22 16 47 01 E Sr k Page 37 Ahsay Offsite Backup Server v4 4 User s Guide 4 Using Ahsay Online Backup Manager This chapter will describe all features available in Ahsay Online Backup Manager and outline how you can use the features of Ahsay Online Backup Manager to meet various backup needs 4 1 System Tray Launcher When you have successfully installed Ahsay Online Backup Manager to your computer an Ahsay Online Backup Manager icon will be added to the system tray area next to your system clock automatically Backup gt Backup and Logoff gt Backup and Restar
5. Put all data files back to their original locations Control files data files and archived logs are stored on Ahsay 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 lt SID gt ora Oracle 9i ORACLE_HOME admin lt SID gt 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 68 Ahsay Offsite Backup Server v4 4 User s Guide c Startup mount d Reapply all transactions from the archived log files e Open database Oracle 8i Example svrmgr1 SVRMGRL gt connect internal SVRMGR gt 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 gt 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 LO0G ORA 00280 change 419671 for thread 1 is in sequence 225 ORA 00278 log file data ora815 vin archive ARCH0000000224 L0G no longer needed for this recovery Specify log lt RET gt sugg
6. ii Data from MySQL server will be backed up to a temporary directory before they are sent to Ahsay Offsite Backup Server Please make sure you have sufficient space on your computer to store these data when you run the backup job iii There must be a MySQL account can be used to connect from localhost Please refer to Chapter 10 Backup Restore MySQL Server for more information on these requirements How to backup a MySQL server Please follow the instructions below to backup your MySQL databases using Ahsay Online Backup Manager i Open Ahsay Online Backup Manager Right click Ahsay Online Backup Manager icon available in the system tray and choose Open Backup Backup and Logoff Backup and Restart Backup and Shutdown b gt b gt Help Exit 14 46 Page 33 Ahsay Offsite Backup Server v4 4 User s Guide 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 MySQALBackupSet 1 Qj Backup Source fd Backup Schedule E Command Line Tool O setting B Encryption b Enter a name for your backup set MySQLBackupSet 1 root 3306 CAmysqhbin c Enter the root password the MySQL server TCP IP port number and the path to MySQL backup utility mysqldump Page 34 Ahsay Offsite Backup Server v4 4 User s Guide d e
7. Plug in 1 3 1 is used to restore your backup files Limitation of Microsoft Java Virtual Machine Troubleshooting 1 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 2 For Internet Explorer Users Please make sure the Use Java 1 x x for lt Applet gt option in Menu gt Tools gt Options gt Advance gt Java Sun is not checked 3 __ If everything failed please choose the Use Sun Java Plug in 1 3 1 to restore your backup files Page 58 Ahsay Offsite Backup Server v4 4 User s Guide 5 4 How to perform seed loading of your backup data 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 af
8. f Select the database s to be backup See Backup Source Please select databases to be backed up M B menagerie M B mysal M B test directory for storing backup files oagackupimysoL Change Previous Cancel Enter a temporary directory for storing the backup files before they are sent to an Ahsay Offsite Backup Server Set the backup schedule for Database Backup Backup Schedule Please schedule the backup time BackupSchedule Type Weekly Friday Add Remove Properties Cancel lt Previous Page 35 Ahsay Offsite Backup Server v4 4 User s Guide g Set the encryption algorithm encryption mode and encrypting key for this backup set Encryption Setting Please setup the encryption setting of the Backup Set I Do NOT use encryption Algorithm AES pi Mode CBC Cipher Block Chaining ECB Electronic CookBook Encrypting Key ee Confirm Encrypting Key E lt Previous 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 b Select Off site Backup Server to start backing up your files to an Ahsay Offsite Backup Server and press the OK button
9. 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 gt available at the toolbar b Select Off site Backup Server to start backing up your files to an Ahsay Offsite Backup Server Confirm Backup Start x Backup to C Local Hard Disk Seed Load Utility Start the backup for File Backup 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 Page 15 Ahsay Offsite Backup Server v4 4 3 2 Quick Start Microsoft SQL Server Backup User s Guide This section will give you the information on how you can backup a Microsoft SQL Server 7 0 2000 database to Ahsay Offsite Backup Server using Ahsay Online Backup Manager Requirements How to backup Microsoft SQL Server 7 0 2000 databases Ahsay Online Backup Manager must be installed onto the computer running Microsoft SQL Server Data from Microsoft SQL Server will be backed up to a temporary directory bef
10. Domino 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 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 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 ena
11. Lotus Backup Set MS Exchange Backup Set MS SQL Server Backup Set MySQL Backup Set Oracle Database Backup Set f y BackupSet 7 E E MySQLBackupSet 1 Ry Backup Source fd Backup Schedule E Command Line Tool CF setting B Encryption t MSSQ LBackupSet 1 S LBackupSet1 rosoft SQL Server Backup SQL Server Login ID sa Password Properties Log Table MSSQLBackupSet 1 oa Type Log Time welcome to Online Backup Manager Quota Remaining Total 49 96 50G Last Backup 2004 07 22 14 32 Page 53 Ahsay Offsite Backup Server v4 4 C d e Enter a name for your backup set Add new File Backup Set xj Backup Set Please type a name for this Backup Set Name FileBackupSet 1 Type File Backup m Backup Source Please select files or and directories to be backed up C O Backup E Documents and Settings A_Installers eF CQ My Music w O Oracle 7 O Program Files w O Projects CO RECYCLER DC O System Volume Information B C O Test 0O UTILity m7 O VisualCafe B C O WINNT CCWuTemp TM ttindnuwe Indata Gatin Cilon lt Previous Next gt Cancel User s Guide Set the backup schedule Note You can have more than one schedule in a backup set Add new File Bay Backup Schedule Please schedule the backup time BackupSchedule 1 Type Daily Add Remove Prop
12. System State checkbox as well Otherwise please install Ahsay Online Backup Manager 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 Ahsay Offsite Backup Server Set the backup schedule for Database Backup Page 93 Ahsay Offsite Backup Server v4 4 User s Guide Add new Lotus Backup Se r Backup Schedule Please schedule the backup time Database Backup Schedule Type Datah eekly Friday Transaction Log Backup Schedule Type Transaction log Weekly Add Remove Properties 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 Add new Lotus B Encryption Setting Please setup the encryption setting of the Backup Set I Do NOT use encryption Algorithm Twofish 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 Stand
13. files directories to this directory in the future they will NOT be backed up Nothing under this directory will be backed up Page 43 Ahsay Offsite Backup Server v4 4 User s Guide Backup Schedule A backup schedule defines the frequency and the time backup will run automatically Backup Set Backup View gt G Backup Controller amp E Backup Schedule File Backup ule Properties 2 Name Daily Schedule E cComman Type CF setting E amp Encryption Oracle9i VIN Oraclesi vin Day MSSQL Serve Backup everyday Start Start Time hh mm 21 00 v Stop H Properties C Stop on completion Full Backup i Stop after 11 hour s t OK Cancel Backup Log Welcome to Online Backup Manager Backup Quota SOMBytes Last Backup 2003 06 19 17 56 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 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
14. gt 14 46 Page 84 Ahsay Offsite Backup Server v4 4 User s Guide ii Create a backup set a From the Menu Choose Backup Set gt New gt Lotus Backup Set F Backup Schedule E Command Line Tool LotusBackupSet 1 Lotus Domino Server Backup c Select the Backup Set Type Lotus Domino Server Backup Lotus Notes Client Backup Page 85 Ahsay Offsite Backup Server v4 4 d e f Select the database s file s you want to backup Backup Source Please selectfiles or and directories to be backed up Lotus Domino M amp Data a m O domino M Chelp M CI IBM_TECHNICAL_SUPPORT M O iNotes a m C logdir3 a O mail iM mndeams I notes ini eaLotus Domino notes ini Change directory for storing backup files C ABackup Lotus Domino Previous Next gt Cancel User s Guide Enter a temporary location to store the backup files before they are sent to an Ahsay Offsite Backup Server Set the backup schedule for Database Backup Backup Schedule Please schedule the backup time Database Backup Schedule Type Databa Transaction Log Backup Schedule Type Transaction log Weekly Weekly Friday 4 Add Remove Properties Previous Next gt Cancel Set the backup schedule for Transaction Log Backup for Domino server only Note You can have more than one schedule in a backup Set
15. 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 86 Ahsay Offsite Backup Server v4 4 User s Guide h Set the encryption algorithm encryption mode and encrypting key for this backup set Encryption Setting Please setup the encryption setting of the Backup Set I Do NOT use encryption Algorithm Twofish Mode CBC Cipher Block Chaining C ECB Electronic CookBook Encrypting Key O Confirmencyptingkey itti s S S 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 iii Run Backup a Select the backup set you want to run on the left panel and press the Start Backup button b Select the backup type e g Database Transaction Log you would like to perform for Domino server only up Type LotusBackupSet 1 Backup ci C Transaction Logs C Select Off site Backup Server to start backing up your files to an Ahsay Offsite Backup Server Confirm Backup i Backup to Disie Baup Sevei Local Hard Disk Seed Load Utility Start the backup for LotusBackupSet 1 OK Cancel Page 87 Ahsay Offsite Backup Server v4 4 User s Guide 8 4 How to restore Lotus Domino
16. 1446 Page 12 Ahsay Offsite Backup Server v4 4 User s Guide iii Create a backup set a From the Menu Choose Backup Set gt New gt File Backup Set f Backup Schedule E Command Line Tool Encryption b Enter a name for your backup set FileBackupSet 1 Previous I ex Page 13 Ahsay Offsite Backup Server v4 4 C d Select the files directories you want to backup Add new File e xj r Backup Source Please select files or and directories to be backed up C O Backup CO Documents and Settings aM y Documents C O My Music 7 2 Oracle a Program Files Projects a RECYCLER System Volume Information OO Test OG utut COQ visualCafe CE WINNT C O wWuTemp MA windawn Indata Gatun Cilan Previous Next Cancel Be a User s Guide Set the backup schedule Note You can have more than one schedule in a backup set Add new e r Backup Schedule Please schedule the backup time BackupSchedule 1 Type Daily Add Remove Properties lt Previous Next gt Cancel Page 14 Ahsay Offsite Backup Server v4 4 User s Guide e Set the encryption algorithm encryption mode and encrypting key for this backup set Encryption Setting Please setup the encryption setting of the Backup Set I Do NOT use encryption Algorithm Twofish v Mode CBC Cipher Block Chaining
17. DOC Deleted Files No Files Size 1 C Test lib DANIEL_4 BAK 4k Moved Files No Files bl C Test KING1 BAK gt C Test lib KING1 BAK Last Modified 2003 06 21 09 57 compressed Last Modified 2003 06 21 09 57 compressed Last Modified 1996 11 29 18 45 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 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 12 7 Review storage statistics You can review the amount of data you have stored on the backup server and uploaded to the Page 117 Ahsay Offsite Backup Ser
18. Full Text Indexing D 1 SQL Server Profiler setup your monitor yourSQL import or export ae database solution 5 data a a aa SQL Server Configuration Properties Manage SQL Server Messages External Tools Options Font Termin Select master in the Restore as database drop down list Select the From device radio button Page 78 User s Guide Ahsay Offsite Backup Server v4 4 User s Guide 4 Press the Select Devices button x General Options 5 Restore as database master Ea Restore C Database Filegroups or files From device p Parameters Devices Backup number fi Restore backup set Database complete C Database differential Transaction log C File or filegroup 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 SQL Server will attempt to restore from the devices listed below Backup set Unknown Restore from Disk E Media verification option IT 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 xj Choose the file name or backup device to use for the restore operation Backup devi
19. 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 iii Run Backup a Select the backup set you want to run on the left panel and press the Start Backup button Page 74 Ahsay Offsite Backup Server v4 4 User s Guide b Select the backup type e g Complete Differential Transaction Log you would like to perform Backup cP C Database differential C Transaction log c Select Off site Backup Server to start backing up your files to an Ahsay Offsite Backup Server Confirm Backup Start xi Backup to ei C Local Hard Disk Seed Load Utility Start the backup for MSSQL BackupSet OK Cancel 7 4 How to restore Microsoft SQL Server database s Please follow the instructions below to restore your Microsoft SQL Server databases from an Ahsay Offsite Backup Server Download the backup files bak from the Ahsay Offsite Backup Server Please refer to the Quick Start Backup File section for information on how to download backup files from Ahsay 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
20. NT 2000 XP 2003 Redhat Linux 6 x or above Solaris 2 x 7 x 8 x 9 x Mac OS X NetWare 5 1 or above and all other platforms supporting Java2 Runtime 1 3 1 Memory 128MB Disk Space 30MB Network Protocol TCP IP http https 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 4 User s Guide 2 Installation Before you can start backing up data to Ahsay Offsite Backup Server you need to install Ahsay Online Backup Manager onto your computer IMPORTANT You should not install and run Ahsay Online Backup Manager on more than one computer using a single backup account As a rule of thumb for each computer you want to install and run Ahsay Online Backup Manager you need to have an individual backup account 2 1 Installing Ahsay Online Backup Manager Please follow the instructions below to install Ansay Online Backup Manager onto your computer i Logon to website ii Click Install Software link available at the top of the page v onsale Mozilla Backup Restore Install Software FAQs Help Select Language User Summary Data Area 2 ol Total Upload 500M o o o o Unit Compressed Size Total No of Files User Profile newAccount Alias New Account Name Language English fasl Timezo
21. None Post Command s None Generated at Sat Jun 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 Account Name setting has been updated Please confirm the information Language English shown on the right is correct Please make sure your setting is Contact user your company com not updated by someone on your contact list If none of them Backup Quota 250M Backup Set BackupSet 0 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 110 Ahsay Offsite Backup Server v4 4 11 5 Inactive User Reminder User s Guide You will receive 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 mo
22. Offsite Backup Server v4 4 User s Guide 9 Backup Restore Microsoft Exchange Server 2000 2003 This chapter will describe in details how to use Ahsay Online Backup Manager to backup your Microsoft Exchange Server 2000 2003 and how you can restore your Microsoft Exchange Server 2000 2003 from the backup files 9 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 Ahsay Online Backup Manager 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 Ahsay 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 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 Windows Active Directory It is important that Windows Active Directory is back
23. Offsite Backup Server v4 4 User s Guide g Set the encryption algorithm encryption mode and encrypting key for this backup set Backup Set xi Encryption Setting Please setup the encryption setting ofthe Backup Set I Do NOT use encryption Algorithm en 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 b Select the backup type e g Database Backup Archived Log Backup you would like to perform ckup Type OracleBackupSet 1 C Archived Logs OK Cancel c Select Off site Backup Server to start backing up your files to an Ahsay Offsite Backup Server Backup to C Local Hard Disk Seed Load Utility Start the backup for OracleBackupSet 1 OK Cancel Page 23 Ahsay Offsite Backup Server v4 4 User s Guide 3 4 Quick Start Lotus Domino Notes Backup This chapter will give you the information on how you can backup Lotus Domino Notes databases to Ahsay Offsite Backup Server using Ahsay Online Backup Manager Requirements i Ahsay Online Backup Manager must be installed onto the
24. Server with Key Management Services enabled please make sure that you backup the key management database as well Ahsay Online Backup Manager 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 Ahsay Offsite Backup Server Page 91 Ahsay Offsite Backup Server v4 4 User s Guide 9 3 How to backup Microsoft Exchange Server 2000 2003 Please follow the instructions below to backup your Microsoft Exchange Server 2000 2003 using Ahsay Online Backup Manager Open Ahsay Online Backup Manager Right click Ahsay Online Backup Manager icon available in the system tray and choose Open Backup Backup and Logoff Backup and Restart Backup and Shutdown b b b Help Stop Ruming Backup Exit 14 46 From the Menu Choose Backup Set gt New gt
25. Source file does not exist Index corrected Full Message BackupSetFileSystem move Source file C xxx yyy zzz Path C aaa bbb ccc does not exist Index corrected Explanation This problem normally implies that there is something wrong with the backup setting Please logon to the web interface of Ahsay Offsite Backup Server and check the Backup Sources and the Backup Filter setting Please pay special attention to the case of the directories configured Page 121 Ahsay Offsite Backup Server v4 4 User s Guide 14 5 Checksum incorrect Full Message Checksum incorrect File C xxx Recd 1111111111 Cald 2222222222 Explanation All files stored on the backup server are first verified before they are written to disk This error indicates that the backup file uploaded is corrupted as the checksum calculated from the receiving end does not match the one generated from the transmitting end Please check if there was anything wrong with the network at the time this error occurred Page 122 Ahsay Offsite Backup Server v4 4 User s Guide 15 Appendixes 15 1 Further Information If you need any additional information please contact us by support ahsay com Page 123
26. The diagram below describes how Ahsay Online Backup Manager 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 Ahsay Backup Manager can be configured to start automatically every night All user files created updated during the day will then be backed up to backup server on the same night without any user intervention n Secure Socket Layer SSL User s ayonan Ah Say Server Authentication _ User Directory parmeters amp 7 Mary Zipped amp encrypted fies Zipped amp Raw Encrypted aresentinSSL Encrypted File w All users files are encrypted by 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 Ahsay Online Backup Manager will pick the new or updated files from your backup set files and upload only these
27. all instances of your browser and visit this page again You should see this dialog again Please make sure you choose Yes this time Power ed by Ahsay Online Backup Server v4 2 Copyright c All Rights Reserved iii Choose either Microsoft Java Virtual Ma the Start button Page 114 B 4 chine or Sun Java Plug in 1 3 1 and press Ahsay Offsite Backup Server v4 4 User s Guide ckup files Microsoft Intemet Explorer Please select the Java Virtual Machine you would like to use to restore your backup files and press the Start button below Use Microsoft Java Virtual Machine Use Sun Java Plug in 1 3 1 Start lt You should see a Start button here Troubleshooting 1 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 2 For Internet Explorer Users Please make sure the Use Java 1 x x for lt Applet gt option in Menu gt Tools gt Options gt Advance gt Java Sun is not checked 3 If everything failed please choose the Use Sun Java Plug in 1 3 1 option above to restore your backup files Close iv Enter the source of your backup files in the Decrypt files From text field destination of the decrypted output in the Decrypt files to text field and the encrypting key in Decrypting Key text field Decrypt files
28. 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 Ahsay 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 Please refer to Chapter 8 Backup Restore Lotus Domino Notes for more information on these requirements How to backup Lotus Domino Notes Please follow the instructions below to backup your Lotus Domino Notes databases to the Ahsay Offsite Backup Server i Open Ahsay Online Backup Manager Right click Ahsay Online Backup Manager icon available in the system tray and choose Open Backup Backup and Logoff Backup and Restart Backup and Shutdown gt b gt b Help Exit 14 46 Page 24 Ahsay Offsite Backup Server v4 4 User s Guide ii Create a backup set a From the Menu Choose Backup Set gt New gt Lotus Backup Set F Backup Schedule E Command Line Tool LotusBackupSet 1 Lotus Domino Server Backup c Select the Backup Set Type Lotus Domino Server Backup Lotus Notes Client Backup Page 25 Ahsay Offsite Backup Server v4 4 d e f Select the database s file s you want to backup Backup Source Please selectfiles or and directories to
29. 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 Backup Set Type A backup set can only be of one of the following types Backup Type Description File Enable files backup Microsoft SQL Server Enable Microsoft SQL Server 7 0 2000 backup Oracle Database Server Enable Oracle 8i 9i Database backup Lotus Domino Notes Enable Lotus Domino Notes backup Microsoft Exchange Server Enable Microsoft Exchange Server 2000 2003 backup En Online Backup Manager 5 x Backup Set Backup View H a g Backup Controller ri Backup Set File Backup 3 User Profile 5 Backup Source fd Backup Schedule Backup Filter E Command Line Tool CF setting amp Encryption 9 Oracle9i VIN 3 Oraclesi VIN 9 MSSQL Server Backup Set Name File Backup Type File Backup Properties 4 Log Table BackupSet 1 Type Log Time Backup Log Backup Completed Successfully Backup Quota 50MBytes Last Backup 2003 06 13 17 20 Backup set type is defined at backup set creation and cannot be modified If you want to change the backup set type you have to create another backup set Page 42 Ahsay Offsite Backup Server v4 4 User s Guide Backup Source A backup source def
30. exchange database ExchangeRestore DIR C Backup SERVER ExchangeServer TEMP C Temp SERVICE Microsoft Information Store STORAGE StorageGroup1 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 StorageGroup1 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 AhsayOBM bin gt ExchangeRestore DIR F Backup TEMP F Temp SERVER WIN2000SVR Exchange Server Recovery Example E Program Files AhsayOBM 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 Exchsrvr mdbdata publ stm End Databa
31. full listing of all files being backed up by the backup 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 user your company com Deleted Files 1 4k Moved Files 1 3k Unit No of Files Total Size Backup Setting Backup Source C iMy Documenti 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 ofthis 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 th
32. 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 Page 44 Ahsay Offsite Backup Server v4 4 User s Guide Backup Filter 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 ioj xj Backup Se w Backup Filter x gt u E Name Fitter 1 B Backul Top Directory Browse Apply To IV File I Directory Pattern Matching Type Text C Regular Expression C starts with contains C ends with Pattern Add Mee Filter Mode Include matched C Exclude matched a J exclude all others Backup 1 Cancel Welcome to Online Backup Manager Backup Quota 50MBytes Last Backup 2003 06 19 17 56 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 It 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 chara
33. name location 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 82 Ahsay Offsite Backup Server v4 4 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 No to use the default or specified value in the Maximum log space field Automatic fixup of corrupt databases Choose one 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 Disabled
34. need to restore master database if you a are rebuilding all your databases from scratch have changing 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 pang 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 75 Ahsay Offsite Backup Server v4 4 User s Guide 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 fa SQL Server Enterprise Manager Console Root Microsoft SQL Servers SQL Server Group WIN20000 EN windows ioj xj I Console window Help E ajx Action vew Toos e gt Galea X TaBe HO woe Tree Databases 8 Items TEE D U T EE Microsoft SQL Servers i g SQL Server Group abc master model msdb Northwind pubs tempdb a E a New SQL Server Registration 8 Edit SQL Server Registration properties a Delete SQL Server Registration a Disconnect Stop Pause Start New All Tasks gt New Window from Here Delete Refresh
35. s Guide 2 3 Trouble Shooting i What can do if the install button does not show up on the installation page A Java Virtual Machine J VM is required to run the installer For Windows XP or Windows 2003 the Microsoft J VM is not bundled with the Operating System This is the reason why the Install button does not show up on the installation page If this problem applies to you please download and install the Sun Java2 Runtime Environment JRE from http java sun com and try installing the software again Page 11 Ahsay Offsite Backup Server v4 4 User s Guide 3 Quick Start For those of you who would like to get started quickly this chapter will give you all information required to start backing up your data using Ahsay Online Backup Manager Before you read on please make sure you have installed Ahsay Online Backup Manager to your computer by following the instructions outlined in the previous chapter 3 1 Quick Start File Backup This section will give you the information on how you can backup your document files to Ahsay Offsite Backup Server How to backup files Please follow the instructions below to backup your data to an Ahsay Offsite Backup Server i Open Ahsay Online Backup Manager ii Right click Ahsay Online Backup Manager icon available in the system tray and choose Open Backup Backup and Logoff Backup and Restart Backup and Shutdown yv v v Help Stop Ruming Backup Exit
36. server using TCP IP protocol Data from Oracle 8i 9i database will be backed up to a temporary directory before they are sent to Ahsay 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 J VM is enabled To enable Oracle JVM 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 Run the scripts below Oracle 8i Oracle 9i SVRMGRL gt connect internal SQL gt connect sys change_on_install as sysdba SVRMGRL gt javavm install initjvm sql SQL gt 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 gt rdbms admin ca
37. the Copy to Local Hard Disk checkbox 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 Page 61 Ahsay Offsite Backup Server v4 4 Vv User s Guide An extra copy of backup will be saved in the Copy to directory when you run your backup job Backup Set Backup View m Q Backup Controller X LotusBackupSet 1 OracleBackupSet 1 a Backup Source fed Backup Schedule amp Backup Filter Command Line Tool Cf Setting amp Encryption amp Local Copy Bacl Backup Set kup Set FileBackupSet1 Name FileBackupSet 1 Type File Backup E Log BLEC8 Ee 1OLOOOLLLLLEEE Table FileBackupSet 1 Local Copy Start running local backup Local Copy Reading local backup files from hard disk Local Copy Getting all files which have been added Completed Local Copy Getting all files which have been updated Completed Local Copy Getting all files which have been deleted Completed Local Copy Getting all files which have been moved Completed Local Copy Total New Files 5 Local Copy Total Updated Files 0 Local Copy Total Deleted Files 0 Local Copy Total Moved Files 0 Local Copy Reading local back
38. 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 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 Encrypting 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 Note Encryption settings are set at backup set creation time and cannot be modified You need to Page 49 Ahsay Offsite Backup Server v4 4 User s Guide create a new backup set if you want to change your encryption settings for a backup set Page 50 Ahsay Offsite Backup Server v4 4 4 5 Backup Logs User s Guide All backup activities are logged to backup activity log files They are available for reviewing from Ahsay Online Backup Manager How to review backup activities You can review all your backup jobs by Select the Log tab available at the bottom of Ahsay Online Backup Manager Select the Backup Job you want to review on the Log Controller panel y O x Backup Set Backup V
39. you have re installed Windows please download the Windows System State backup file named SystemState bkf from Ahsay 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 Ahsay Online Backup Manager if required Please refer to the Installation section for information on how to install Ahsay Online Backup Manager 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 Ahsay 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 ExchangeRestore exe from the bi
40. ACCESS S dO OA 35 5 a a ond hss A E Ea SEAE 121 14 3 Quota Exceededienus onsa n ceases A R a A EN A 121 14 4 Source file does not exist Index corrected ssssnsseesssessesereesesssseseeeeeess 121 14 5 Checksum OOT E CN a a a AA i A 122 tSr Appendi rE Sa re Ga ie ged AE Gevalia E E E T tehele aie 123 15 1 FEurtherifotmatiom sa nna a a N a I E 123 Page 5 Ahsay Offsite Backup Server v4 4 User s Guide 1 Overview 1 1 1 2 Benefits a Daily backup your files Microsoft SQL Server 7 0 2000 Oracle 8i 9i Lotus Domino Notes 5 0 or above Microsoft Exchanger Server 2000 2003 MySQL 3 23 42 or above a Fully automated No administration required Send business data offsite to a secure data center Protect business data against natural disasters e g fire flood as well as terrorist attacks a Save you time and money E Easy to deploy and maintain Features a Offsite backup your files Microsoft SQL Server 7 0 2000 Oracle 8i 9i Lotus Domino Notes 5 0 or above Microsoft Exchanger Server 2000 2003 support both full incremental backup MySQL 3 23 42 or above E Easy to use web interface a Customizable backup schedule allows backup to be scheduled at any time a Compress and encrypt data automatically before sending them to the server server stores only encrypted data E Increment backup strategy ensures that only new or updated files are sent to backup server a Access backup data anytime anywhere by
41. Ahsay Offsite Backup Server v4 4 User s Guide Version 4 4 4 May 2004 Ahsay Offsite Backup Server v4 4 User s Guide Copyright Notice Lebshama Company Limited 2004 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 Lebshama Company Limited Information in this manual is subject to change without notice and does not represent a commitment on the part of the vendor Lebshama does not warrant that this document is error free If you find any errors in this document please report to Lebshama 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 are registered trademarks of
42. Apple Computer Inc All other product names are registered trademarks of their respective owners Ahsay Offsite Backup Server v4 4 User s Guide Table Of Content I OVERVIEW E E E E ale a aie Wine tgtee 1 1 Benefits eod Shader ad ete hacia dhs Pennie alee hg den dea tide Soya Sate Wid POA QUreS E EE EET USS AVC CUUELLY once tracey cris cokes E a e a a a naaa ei E EE a LOEDE EE E E EE 2 Jnstallat oi searen e e iu E a rests E ecco ee eke 2 1 Installing Ahsay Online Backup Manager ssesseeseseeesseeereeresressireresrerseeeee 2 2 Installing Ahsay Online Backup Manager on NetWare eeneeeeeeeeeeeeee 2 3 Tro ble SHOGUNG scicccize cceacdecuasaaadoeasisananecnseeagtosdgensuceaandauaeens anes aeeaiesaaee agentes Be SOCK ESI e EE EEE E EE sebbadan esha Sigs ees esc eae eee etc ene 3 1 Quick Start Fil Bac k ps nicsen a RA 3 2 Quick Start Microsoft SQL Server Backup sssssssssssssesssesssssessseesssesseessee 3 3 Quick Start Oracle 8i 9i Backup oscar cate saan a vastus Seana eons eval 3 4 Quick Start Lotus Domino Notes Backup eecceeeeeeeeeeececeeeeeeeneeeeeaes 3 5 Quick Start Microsoft Exchange Server Backup ceescceeeeeeeeeseeeeeees 3 6 Quick Start MySQL Backup vec caye sc ciyescecusincestsycdecceovacoscadnaeecevecoteedecdars 4 Using Ahsay Online Backup Managet ceeccecesccecesececesececeeccecseeeecseeeeceneeeeeeeeee 4 1 System ray Launcher vs sietecgjuccace dices e E A E EKA EISSA A
43. Backup Source i Backup Schedule E Command Line Tool Start 2004 07 22 16 47 01 Start running pre commands 2004 07 22 16 47 01 Finished running pre commands 2004 07 22 16 47 01 Using Temporary Directory C Backup MySQL 1 088760442718 2004 07 22 16 47 01 Start Backing up database mysql to mysql sql 2004 07 22 16 47 01 End 2004 07 22 16 47 01 Start running post commands 2004 07 22 16 47 01 Page 103 Ahsay Offsite Backup Server v4 4 User s Guide 10 4 How to restore MySQL server Please follow the instructions below to restore MySQL server from an Ahsay Offsite Backup Server Download the database backup files to be restored from the Ahsay Offsite Backup Server Please refer to the 5 3 How to restore file section for information on how to download backup files from Ahsay Offsite Backup Server Restore the database named db_name from the database backup file db_name sql 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 gt mysql db_name lt db_name sql Repeat the same procedure for each database to be restored to the MySQL Server Completed Page 104 Ahsay Offsite Backup Server v4 4 11 Email Reporting User s Guide Ahsay Offsite Backup Server makes use of the email system to keep
44. D Logon Dialogs secs a aa e AEN a E NE A E aaa AS User Profiles irp a ee E ea o ES Sii 44 eBaekup Setanin n eer erst a T a T E BO Backup Loss greenen A A ay emer 5r Backup Restore File eorex ese r a boa N E ONA N NRE 5 1 How TUES Ale Backed Upierir nri a a eas cane wee oes 5 2 How to backup TSB vcsets caesecasien stds enn e A EA E E 5 3 How to restore 16S wisi Accessed Nase been eevee cel teas 5 4 How to perform seed loading of your backup data 0 0 0 eee eeeeeeeeeteeeeeees 5 5 How to save an extra copy of backup on local hard disk eee O7 Backup Restore Oracle 81 91 irie estat aes ice ae tinea ee E 6 1 IR COUNT HIT Sai Saad isan elds cca E EE E audios ts wanveaadees states 625 MO MET VIC Wa sree slices l staan oes Reena aca nesta ese ease a ace eee Ries 6 3 How to backup an Oracle Database e ce eeeceeeeececseeeeceteeeceteeeceneeeenneeeesaes 6 4 How to restore an Oracle Database c ce ceesccesececseececseeeecesececsteeeenteeeesaes 7 Backup Restore Microsoft SQL Server 7 0 2000 0 eceeecceceeccecseeeeceeeeeceteeeeeteeeees 7 1 REGUIPEMIEIIS asic susidscaeisuanaceideeddaiarensa a R E R AE 59 61 Ahsay Offsite Backup Server v4 4 User s Guide 10 11 12 13 14 L2 ON Wate at ic feet ra eee ag seat a th oe cio E R 71 7 3 How to backup Microsoft SQL Server database S ccesseeeeeeeeseeeeeeteees 72 TA How to restore Microsoft SQL Server database s cccscccceceeeesesen
45. Files AhsayOBM log default location for more information iii Try running backup again manually to see if the same error occurs Page 119 Ahsay Offsite Backup Server v4 4 User s Guide 13 5 How do I backup 300GB of data through the Internet Please refer to the Seed Loading Utility section for more information Page 120 Ahsay Offsite Backup Server v4 4 User s Guide 14 Common Errors 14 1 The process cannot access the file because it is being used by another process Full Message Error New File File C xxx Error C xxx The process cannot access the file because it is being used by another process Explanation This means that the file above is currently locked by another process or program Please advice the user to shutdown the program locking this file before running the online backup program again You can also refer to our FAQs How do we backup Open Files section for more information 14 2 Access is denied Full Message Error New File File C xxx Error C xxx Access is denied Explanation This means that the file above is not accessible by the backup program Please check if the backup program has read access permission to the file above 14 3 Quota Exceeded Full Message Quota Exceeded Explanation This means that the backup account has run out of its allocated quota Please contact your administrator or backup services provider to increase your backup quota 14 4
46. From C BackupJob Decrypt files to IC BackupJob Decrypted Decrypting Key peek 2003 06 21 12 38 17 Start 2003 06 21 12 38 19 Decrypted C BackupJob Decrypted C_ Test 1ib javamail 1 3 CHANGE 2003 06 21 12 38 19 Decrypted C BackupJob Decrypted C_ Test 1ib javamail 1 3 LICENS 2003 06 21 12 38 19 Decrypted C BackupJob Decrypted C_ Test lib javamail 1 3 mail j 2003 06 21 12 38 19 Decrypted C BackupJob Decrypted C_ Test lib New DANIEL DOC 8k 2003 06 21 12 38 19 Decrypted C BackupJob Decrypted C_ Test 1ib DANIEL DOC 8k byt 2003 06 21 12 38 19 Decrypted C BackupJob Decrypted C_ Test 1ib KING1 BAK 2k byte Decrypted_ C BackupJob Decrypted C_ Test KINGIANS BAK 2k bytes Decrypting C Test KINGLANS BAK Elapsed Time 303k bytes restored 2 sec elapsed Current File Time 0 sec Total 2k bytes 2k bytes restored Saving File To C BackupJob Decrypted C_ Test KINGIANS BAK Restoring Speed 149k bytes second Cancel Start Stop v Press the Start button 12 6 Review backup jobs In addition to reviewing your backup activities from the email report and from Ahsay Online Backup Manager 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 115 Ahsay Offsite Backup Server v4 4 User s Guide Backup Re
47. Help Opens property sheet for the current selection 2 Press the Startup Parameters button x Connections Server Settings l Database Settings General Memo Processor Security g Name WINZO000 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 i Root directory F MSSQL Code page CP 1252 AutoStart policies when the operating system stats a re IT Autostart MSDTC Startup parameters Page 76 Ahsay Offsite Backup Server v4 4 User s Guide 3 Adda m parameter to the Startup Parameters STING 2000 Startup Parameters Parameter Add m Remove Existing parameters dC Program Files Microsoft SQL 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 QL Serve erprise Manage onsole Roo osoft SQ Q oup WIN20000 EN Wind I E lt li Console Window Help e x action vew tools e gt an xele HG Ho Tree WIN20000 EN Windows NT 5 Items C Console Root EEJ Microsoft SQL Servers Getting Started Taskpad EG SQL Server Group 7 5 Go Dat New SQL Server Registration
48. M 283 22 2M 227 204M 573 a ear as Powered by Ahsay Online Backup Server v4 2 Copyright c All Rights Reserved Bo o i T Be z 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 118 Ahsay Offsite Backup Server v4 4 User s Guide 13 Frequently Asked Questions 13 1 How do I uninstall Ahsay Online Backup Manager To uninstall Ahsay Online Backup Manager from your computer just run INSTALL_DIR bin uninstall bat default location is C Program Files AhsayOBM bin uninstall bat 13 2 How is data privacy maintained All data are encrypted with user s defined encrypting key before they are sent to the online backup server Without the encrypting key the backup files are useless to anyone The backup user is the only person who can decrypt the backup files to reveal the original content 13 3 How do we backup Open Files Files should never be backed up while they are open by an application When an application is running it stores its data both in sy
49. MS Exchange Backup Set Create a backup set a From the Menu Choose Backup Set gt New gt MS Exchange Backup Set File Backup Set Lotus Backup Set MS Exchange Backup Set MS SQL Server Backup Set MySQL Backup Set Oracle Database Backup Set H E BackupSet 7 E E MySQ LBackupSet 1 Backup Source F Backup Schedule Command Line Tool Cf Setting B Encryption et MSSQLBackupSet 1 S LBackupSet 1 rosoft SQL Server Backup SQL Sener LoginID sa Password 1 Properties Log Table MSSQLBackupSet 1 eo Type Log Time 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 92 Ahsay Offsite Backup Server v4 4 User s Guide Backup Set Please type a name for this Backup Set Name MSExchangeBackunSet 1 Type Microsoft Exchange Server Backup Backup Source E Please select Database to be backed up My Computer O BA System State E Microsoft Exchange Server B WIN2000SVR amp Microsoft Information Store gi First Storage Group DC 9 Mailbox Store VIN2000SVR M Public Folder Store VIN2000SVR aM gv ie M abe M acct V a mail2 xl Temporary directory for storing backup files CA BackupiMSExchange Change Previous Next Cancel If this Exchange Server is also a domain controller of this Active Directory select the
50. Notes database s file s Please follow the instructions below to restore Lotus Domino server Notes client database s file s from an Ahsay Offsite Backup Server Install Lotus Domino server Notes client back to its original folder if required Install Ansay Online Backup Manager Please refer to the Installation section for information on how to install Ahsay Online Backup Manager onto your computer Copy LotusMediaRecovery exe from the bin directory default to C Program Files AhsayOBM 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 Ahsay 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 LotusMediaRecovery Media Recovery Utility for Lotus Domino 5 0 or above Plea
51. Server Set the backup schedule for full database backup and transaction log backup r Backup Set xi Backup Schedule Please schedule the backup time Database complete BackupSchedule Type Database Weekly Transaction log BackupSchedule Type Log Weekly Monday Tu Add Remove Properties Previous Next 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 Page 18 Ahsay Offsite Backup Server v4 4 User s Guide g Set the encryption algorithm encryption mode and encrypting key for this backup set Database Backup Set xj Encryption Setting Please setup the encryption setting of the Backup Set I Do NOT use encryption Algorithm DARA Mode CBC Cipher Block Chaining C ECB Electronic CookBook Encrypting Key Confirm Encrypting Key lt 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 b Select the backup type e g Complete Differential Transaction Log you would like to perform Database differential C Transaction log c Se
52. Start Microsoft Exchange backup 2004 01 31 13 53 47 Start Exchange Server WIN2000SVR 2004 01 31 13 53 47 Start Service Microsoft Information Store 2004 01 31 13 53 47 amp Start Storage Group First Storage Group 2004 01 31 13 53 47 Start Database Mailbox Store 4 IN2000SVR 2004 01 31 13 53 47 Backing up E Program Files Exchsrvrimadbdatalpriv1 edb 2004 01 31 13 53 47 Backing up E Program Files Exchsrvrimadbdata priv1 stm 2004 01 31 13 53 49 G End Database 2004 01 31 13 53 51 Start Database Public Folder Store WIN2000S R 2004 01 31 13 53 51 Backing up E Program Files Exchsrvrimdbdatalpub1 edb 2004 01 31 13 53 51 amp Backing up E Program Files Exchsrvrimdbdata pub1 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 E Program Files Exchsmrimdbdata EQO000B 2004 01 31 13 54 23 z Backing up E Program Files ExchsrrisG 2iacct stm Quota Remaining Total 48 066 506 Last Backup 2004 01 31 10 42 Page 32 Ahsay Offsite Backup Server v4 4 User s Guide 3 6 Quick Start MySQL Backup This chapter will give you the information on how you can backup a MySQL server to Ahsay Offsite Backup Server using Ahsay Online Backup Manager Requirements i Ahsay Online Backup Manager must be installed onto the computer running MySQL server
53. Windows please install Ansay Online Backup Manager onto the company running the Oracle database if Ansay Online Backup Manager is to backup this Oracle database This would shorten the time required to backup the Oracle database Page 64 Ahsay Offsite Backup Server v4 4 User s Guide 6 3 How to backup an Oracle Database Please follow the instructions below to backup your Oracle database to the Ahsay Offsite Backup Server Install Ahsay Online Backup Manager onto your computer Open Ahsay Online Backup Manager Right click Ahsay Online Backup Manager icon available in the system tray and choose Open Backup Backup and Logoff Backup and Restart Backup and Shutdown gt gt gt gt Help Stop Running Backup v Exit 14 46 Create a backup set a From the Menu Choose Backup Set gt New gt Oracle Database Backup Set File Backup Set Cotus Backin set et MSSQLBackupSet 1 MS Exchange Backup Set MS SQL Server Backup Set MySQL Backup Set Oracle Database Backup Set S LBackupSet 1 rosoft SQL Server Backup SQL Server LoginID sa Password oof Backup Schedule san Line Tool Properties etting B Encryption Log Table MSSQLBackupSet1 welcome to Online Backup Manager Quota Remaining Total 49 9G 50G Last Backup 2004 07 22 14 32 Page 65 Ahsay Offsite Backup Server v4 4 b d amp Enter a name for you
54. ail1 Exchange Server Recovery Example E Program Files AhsayOBM 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 log End Restoring transaction log SG5 Start Applying transaction log End Applying transaction log End Storage Group SG5 E Program Files AhsayOBM bin gt f Repeat the same procedure for each database to be restored to the Exchange Server g 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 98 Ahsay Offsite Backup Server v4 4 User s Guide 10 Backup Restore MySQL Server This chapter will describe in details how to use Ahsay Online Backup Manager to backup your MySQL server and how you can restore your MySQL server from the database backup files 10 1 Requirements Ahsay Online Backup Manager must be installed onto the computer run
55. ard 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 Page 94 Ahsay Offsite Backup Server v4 4 User s Guide b Select the backup type e g Database Log Files you would like to perform C Log Files C Select Off site Backup Server to start backing up your files to an Ahsay Offsite Backup Server and press the OK button C Local Hard Disk Seed Load Utility Start the backup for MSExchangeBackupSet 1 o cama d You should get something similar to the screen shot below sin Ah M Backup Set Backup View H a Backup Controller User Profile K Backup Set MSExchangeBackupSet 1 Backup Set Name MSExchangeBackupSet 1 fi Backup Schedule Type Microsoft Exchange Server Backup a sige Line Tool Properties 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 Backup MSExchange 1 071124 2004 01 31 13 53 47 Start Microsoft Exchange backup 2004 01 31 13 53 47 Start Exchange Server WIN2000SVR 2004 01 31 13 53 47 Start Service Microsoft Information Stor
56. at Jun 21 10 00 05 HKT 2003 Backup Job Statistics 1 9k bytes Backup Job Summary Backup Set BackupSet o Backup Job__ 2003 06 21 09 58 _ Backup Status Backup finished successfully Backup Time 2003 06 21 09 57 2003 06 21 09 57 Moved files Unit Number of files Total file size 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 New Files compressed Files Last Modified c Test lib New DANIEL DOC 2003 06 21 09 57 Updated Files compressed No Files Size Last Modified 1 C Test lib DANIEL DOC 9k 2003 06 21 09 57 Deleted Files compressed Files Last Modified C Test lib DANIEL_A4 BAK 1996 11 29 18 45 Moved Files compressed Files Last Modified C Test KING1 BAK gt C Test lib KING1 BAK 2003 06 05 12 35 Key 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 Normally you should see Backup finished successfully in this field If you happen to get something else please consult the attached full report for more information Page 108 Ahsay Offsite Backup Server v4 4 User s Guide Bac
57. ately 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 Powered by Ahsay Online Backup Server v4 2 Copyright c All Rights Reserved E CT le 12 4 Restore Delete Backup Files You can restore your backup files from Ahsay Offsite Backup Server using the web interface Please refer to the How to restore files section Chapter 5 3 for information on how to restore backup files from Ahsay Offsite Backup Server You can also delete your backup files from Ahsay Offsite Backup Server using the web interface To delete a file directory whole backup set simply check the checkbox next to the object you would like to delete and press the Delete button Page 113 Ahsay Offsite Backup Server v4 4 le Microsoft Intemet Explorer Backup Restore Install Software User s Guide FAQs Help Browse Restore your online backup files Home gt BackupSet 0 gt Current gt C gt Test Delete Restore All File Directory Size a KING1ANS BAK Delete Restore iik Last Modified Zipped Ratio 1996 11 29 18 42 2k 80 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
58. authentication are supported Page 39 Ahsay Offsite Backup Server v4 4 User s Guide 4 3 User Profile After the backup server authenticates you successfully Ahsay Online Backup Manager main window appears You can then use Ahsay Online Backup Manager to update your user profile Bn Online Backup Manage Backup Set Backup View H Backup Controller 2 9 User Profile CRERICE i File Backup F Backup Source fd Backup Schedule Backup Filter E Command Line Tool CF Setting B Encryption 3 Oracle9i VIN lol x User Information Login Name scherring Password me Change Display Name Scherring Change Account Information H Oraclesi VIN Quota 50M E MSSOL Serer Time Zone GmT 08 00 Contact scherring ahsay com v Contact Name Scherring Email Address scherring ahsay com Add Remove Properties Backup Log welcome to Online Backup Manager Backup Quota 50MBytes Last Backup 2003 06 13 17 20 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 Confirm New Password x Cancel To change your Display Name press the Change button next to the display name field A Change Di
59. be backed up Lotus Domino M amp Data a m O domino M Chelp M CI IBM_TECHNICAL_SUPPORT M O iNotes a m C logdir3 a O mail iM mndeams I notes ini eaLotus Domino notes ini Change directory for storing backup files C ABackup Lotus Domino Previous Next gt Cancel User s Guide Enter a temporary location to store the backup files before they are sent to an Ahsay Offsite Backup Server Set the backup schedule for Database Backup Backup Schedule Please schedule the backup time Database Backup Schedule Type Databa Transaction Log Backup Schedule Type Transaction log Weekly Weekly Friday 4 Add Remove Properties Previous Next gt Cancel 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 Page 26 Ahsay Offsite Backup Server v4 4 User s Guide h Set the encryption algorithm encryption mode and encrypting key for this backup set Encryption Setting Please setup the encryption setting of the Backup Set I Do NOT use encryption Algorithm Twofish Mode CBC Cipher Block Chaining C ECB Electronic CookBook Encrypting Key O Confirmencyptingkey itti s S S
60. bled at all If you try to issue it you will receive an error message Page 83 Ahsay Offsite Backup Server v4 4 User s Guide 8 2 Overview Ahsay Online Backup Manager will backup your Lotus Domino server Notes client by taking the following steps Run all Pre Commands of this backup set 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 for Domino server only If the backup type to run is Transaction Log Backup type a only filled log extents will be copied to the temporary directory and the Domino server is notified of their availability for reuse Run all Post Commands of this backup set Upload all files copied to the temporary directory to the Ahsay Offsite Backup Server 8 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 Ahsay Online Backup Manager Open Ahsay Online Backup Manager Right click Ahsay Online Backup Manager icon available in the system tray and choose Open Backup Backup and Logoff F Backup and Restart Backup and Shutdown
61. ces can be created for files that you use frequently F MSSGL7 BACKUPS Bo Backup device 7 Press the OK button to start restoring the master database Page 79 Ahsay Offsite Backup Server v4 4 User s Guide 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 Select De
62. ckup Backup and Logoff Backup and Restart Backup and Shutdown gt 14 46 Page 20 Ahsay Offsite Backup Server v4 4 User s Guide iii Create a backup set a From the Menu Choose Backup Set gt New gt Oracle Database Backup Set c Enter the system password the Oracle Database Server Host Name TNS Port and SID Page 21 Ahsay Offsite Backup Server v4 4 d Select the tablespace s you want to backup Backup Set x Backup Source Please select tablespaces to be backed up Oracle Database Server m Aj SYSTEM mM j OEM_REPOSITORY DARBS D AJTEMP m USERS mA InDx Temporary disk space used for storing spool files C BackuptOracleDB Change Previous Next gt Cancel e an Ahsay Offsite Backup Server f Backup Set xj Backup Schedule Please schedule the backup time Database Tablespaces Control amp Init File Archived Logs Backuj Archived Logs BackupSchedule Type Archived Logs Weekly Mc Add Remove Properties lt Previous Next gt Cancel User s Guide Enter a temporary location to store the database file s before they are sent to Set the backup schedule for database backup and archived log backup 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 22 Ahsay
63. ckup Microsoft SQL Server database s Please follow the instructions below to backup your Microsoft SQL Server databases using Ahsay Online Backup Manager i Open Ahsay Online Backup Manager Right click Ahsay Online Backup Manager icon available in the system tray and choose Open Backup Backup and Logoff Backup and Restart Backup and Shutdown b b b Help Stop Running Backup Exit 14 46 ii Create a backup set a From the Menu Choose Backup Set gt New gt MS SQL Server Backup Set File Backup Set __ Remove Lotus Backup Set et MSSQLBackupSet 1 Save MS Exchange Backup Set Exit Server Backup Set MySQL Backup Set a MSexct Oracle Database Backup Set KLS eve f y BackupSet 7 hans E E MyS LBackupSet 1 cE Sa Backup Source Password fa Backup Schedule a gommand Line Tool Properties etting B Encryption S LBackupSet1 rosoft SQL Server Backup f5 Log Table MSSQLBackupSet 1 welcome to Online Backup Manager Quota Remaining Total 49 9G 50G Last Backup 2004 07 22 14 32 Page 72 Ahsay Offsite Backup Server v4 4 User s Guide b Enter a name for your backup set r Backup Set Please type a name for this Backup Set Name MSSQLBackupSet1 Type Microsoft SQL Server Backup Microsoft SQL Server LoginID fsa Password Cancel Gi Enter the Microsoft SQL Server administrator username an
64. ckup files eaBackupimysoL Change lt Previous IE e Enter a temporary directory for storing the backup files before they are sent to an Ahsay Offsite Backup Server e g C Backup MySQL Page 101 Ahsay Offsite Backup Server v4 4 f g Set the backup schedule for Database Backup Backup Schedule Please schedule the backup time BackupSchedule Type Weekly Friday Add Remove Properties Previous 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 I Do NOT use encryption Algorithm AES g Mode CBC Cipher Block Chaining C ECB Electronic CookBook Encrypting Key pe Confirm Encrypting Key p lt Previous Cancel User s Guide 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 102 Ahsay Offsite Backup Server v4 4 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 gt b Select Off site Backup Server to start backing up your files to an Ahsay Offsite Backup Server and press the OK button OracleBackupSet 1 Lotus Notes MSSQLBackupSet1 MSExchangeBackupSet 1 BackupSet 7
65. ckup sources you will be presented with the dialog below Authentication for Windows Domain fwindows Dorain User Name fionn Password OK Cancel Ahsay Online Backup Manager need to collect your 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 Please enter your Windows username password and domain name into the fields provided and press the OK button 5 3 How to restore files You can backup your data to an Ahsay Offsite Backup Server by following instructions below i Logon to the Ahsay Offsite Backup Server web interface ii From the top menu click File Explorer iii Select the backup files you want to restore osoft Intemet Explorer Backup Restore Install Software Browse Restore your online backup files Home gt File Backup gt Current gt C Delete Restore All J File Directory Size Last Modified Zipped Ratio p IM Test 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 Powered by Ahsay Online Backup Server v4 2 Copyright c A
66. cter Contain Include Exclude all files directories with name containing a certain pattern For example You can use B to match all files with 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 documents Regular Expression Include Exclude all files directories with name matching a regular expression For example You can use B doc to match all files with name starting with a B character and ending with doc Please consult references on regular expression for more information on how to use regular expression Page 45 Ahsay Offsite Backup Server v4 4 User s Guide 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 You can apply a Exclude filter of End With type with patterns exe and dll to the directory C My Document to include all files except the program executables exe and dynamic link libraries dll below C My Document to a backup set Page 46 Ahsay Offsite Backup Server v4 4 User s Guide Command Line Tool The command line tool feature has two major compone
67. d password d Select the database s you want to backup er Backup Set xi Backup Source Please select databases to be backed up Microsoft SQL Server C 8 master DB tempdb D model C B msab C D pubs D Northwind C B abe C B vincent D amp new_model Temporary disk space used for storing spool files CABackup MSSGQLServer Change Previous Next Cancel e Enter a temporary location to store the backup files before they are sent to an Ahsay Offsite Backup Server Page 73 Ahsay Offsite Backup Server v4 4 User s Guide f Set the backup schedule for full database backup and transaction log backup ver Backup Set xi Backup Schedule Please schedule the backup time Database complete BackupSchedule Type Datab jeekly iil Transaction log BackupSchedule Type Log Weekly Monday Tu 4 Add Remove Properties Previous Next 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 x Encryption Setting Please setup the encryption setting of the Backup Set I Do NOT use encryption Algorithm SEAE Mode CBC Cipher Block Chaining C ECB Electronic CookBook Encrypting
68. e 2004 01 31 13 53 47 Start Storage Group First Storage Group 2004 01 31 13 53 47 D Start Database Mailbox Store 4 IN2000SVR 2004 01 31 13 53 47 Backing up E Program Files Exchsrvrimadbdata priv1 edb 2004 01 31 13 53 47 Backing up E Program Files Exchsrvrimadbdata priv1 stm 2004 01 31 13 53 49 amp End Database 2004 01 31 13 53 51 Start Database Public Folder Store WIN2000S R 2004 01 31 13 53 51 Backing up E Program Files Exchsrvrimdbdatalpub1 edb 2004 01 31 13 53 51 amp Backing up E Program Files Exchsrvrimdbdata pub1 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 G Backing up E Program Files Exchsrvrimdbdata EQO000B 2004 01 31 13 54 23 Backing up EAProgram Files ExchsrvrisG 2iacct stm Quota Remaining Total 48 066 50G Last Backup 2004 01 31 10 42 Page 95 Ahsay Offsite Backup Server v4 4 User s Guide 9 4 How to restore Microsoft Exchange Server 2000 2003 Please follow the instructions below to restore Microsoft Exchange Server 2000 2003 from an Ahsay 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 Restore Windows Active Directory if required If
69. e backup job Normally you should see Backup 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 107 Ahsay Offsite Backup Server v4 4 User s Guide 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 Fu il Backu p Re port Generated at S
70. e database a Download the database file to be restored from the Ahsay 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 last archived transaction log vii Restart Lotus Domino Server Page 89 Ahsay
71. e uploading backup files After uploading all backup files Microsoft SQL Server Before spooling backup files to After spooling backup files to temporary directory temporary directory i e before the first backup file is uploaded Oracle Database Before spooling backup files to After spooling backup files to Server 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 47 Ahsay Offsite Backup Server v4 4 User s Guide Settin A backup set consists of some extra parameters that provide you access to various features of the backup operation within a backup set They are listed in the following table En Online Backup Manager lol x Backup Set Backup View m Backup Controller OF CI Setting File Backup 8 User Profile Retention Policy yy File Backup Backup Source Keep deleted file s for 90 x Days F Backup Schedule 2 Backup Filter Transfer Block Size 3 mmand Line Tool 128k Bytes Setting B Encryption Symbolic Link Oraclegi VIN H Oraclesi VIN MSSQL Server Follow symbolic link Yes C No f5 L
72. ed CAAUTOEXEC BAT 2 5 Processed CAboot ini 3 5 Processed C dell img 4 5 Processed C drvnet img 5 5 Processed C drvnet2 irng Start running post commands Finished running post commands Backup Completed Successfully X Processed 3 1M 3206764 byte Start Giop vii Transport the data specified in the Destination Directory field to the offsite backup server Page 60 Ahsay Offsite Backup Server v4 4 User s Guide 5 5 How to save an extra copy of backup on local hard disk 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 vi Open Ahsay Online Backup Manager from the System Tray see previous sections for details Setup your backup set see previous sections for details Select Local Copy under your backup set from the left panel Ah line Backup Manage Backup Set Backup View Le Backup Controller Df Sj Local Copy FileBackunset t in xj F Copy to Local Hard Disk Copy to O LocaiBackup Change Dp Zip copied tle s G Yes C No ockup Filter mand Line Too yy Log Table FileGackupSet 1 Type Log Time Backup Log Welcome to Ahsay Online Backup Managert Quota Remaining Totaly 4 4201450 Last Backup 2004 05 17 11 05 Check
73. ed on your backup path To change the above setting of your backup set please select the Setting node on the left panel to invoke the setting panel on the right After you have made your changes please remember to press the Save button on the toolbar Page 48 Ahsay Offsite Backup Server v4 4 User s Guide Encryption Before your files are sent to Ahsay 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 n Online Backup Manager lol x Backup Set Backup View H g Backup Controller x 8 Encryption File Backup 3 User Profile By File Backup amp Backup Source Algorithm Twofish fd Backup Schedule Mode cBC Backup Filter Command Line Tool Encrypting Key Cf Setting IV Mask Encrypting Key 3 Sm Oracle9i VIN a Oracle8i VIN MSSAL Server Encryption Log Table BackupSet 1 Type Log Time Backup Log Backup Completed Successfully Backup Quota 50MBytes Last Backup 2003 06 13 17 20 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
74. er Reminder aroo a o a a a aa 111 Web Feat reS nnosiniinses iani asa EASES AE OE aes 112 12 1 Install Ahsay Online Backup Manager ns nnonensenssesseessseeesseesserssessseresseee 112 122 Update User Profile poscncesisarsiirn e a E saan denn 112 12 3 Request your forgotten password sessseesseesseessessseetssetesseessersseesseressees 113 12 4 Restore Delete Backup Files o ecscasies sa scoedsavaedeeleasdnsetaracevaasaceasecemeeianseavess 113 12 5 Decrypt backup files on CD DVD nssssssesssessssseesseessesssesssstesseessersseesseeessees 114 12 6 REVIEW backup ODS x seisscey esos n e a n G R EA GiS 115 12 7 4 Review storage Statistics vocr ri iei TEE a A E a E 117 Frequently Asked Quest On8icc cchecwcccsssdevevccsantapedtess Wueasageueagedeiauedacadukvghdus decsacndeenes 119 13 1 How do I uninstall Ahsay Online Backup Manager eee eeeeeeeseeeees 119 13 2 How is data privacy maintained 000 0 cece eeececesececeeececeeeeeceeeeeceteeeeneeeees 119 13 3 How do we backup Open Files cccscsccjssccssvacesdusecdcacssuensesvendeceds secsansecesss 119 13 4 What should I do if a backup error is reported in my backup report 119 13 5 How do I backup 300GB of data through the Internet oe 120 COMMOMETTOTS conie ase cas esses E E E A mae 121 Ahsay Offsite Backup Server v4 4 User s Guide 14 1 The process cannot access the file because it is being used by another PTOCESS irea aaa EEE AEE E A EEE A Ta iA A E 121 T42
75. erties Previous Next gt Cancel Page 54 Ahsay Offsite Backup Server v4 4 User s Guide f Set the encryption algorithm encryption mode and encrypting key for this backup set 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 Encryption Setting Please setup the encryption setting of the Backup Set J Do NOT use encryption Algorithm Twofish Y Mode CBC Cipher Block Chaining C ECB Electronic CookBook Encrypting Key Confirm Encrypting Key lt Previous Next Cancel ii Run Backup a Select the backup set you want to run on the left panel and press the Start Backup button on the toolbar b Select Off site Backup Server to start backing up your files to an Ahsay Offsite Backup Server Confirm Backup Start 3 x Backup to C Local Hard Disk Seed Load Utility Start the backup for File Backup 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 Page 55 Ahsay Offsite Backup Server v4 4 User s Guide Backing up a network drive Scheduled If you have selected a network mapped path as one of your ba
76. ested filename AUTO CANCEL AUTO 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 LOG 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 LO0G 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 LO0G 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 gt 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 69 Ahsay Of
77. files directories check the checkbox next to the button files directories and press the Delete Powered by Ahsay Online Backup Server v4 2 Copyright c All Rights Reserved fear 12 5 Decrypt backup files on CD DVD When you request your data stored on backup server to be delivered to you on CD or DVD you have to decrypt and uncompress your backup files uncompress your backup files please do the following i Click the CD DVD link available at the Intemet Explorer before you can use them To decrypt and top menu Click the Decrypt Files Now link available at the centre of the page 15 x Backup Restore Install Software FAQs Help Mfr Sens ta Decrypt backup files As a user of Online Backup Services you can request to store your backup files in CD R or DVD However as all backup files are zipped and encrypted you have to unzip and decrypt them using this utility before you use them Decrypt Files Now Requirements 1 make sure you have your encrypted backup files accessible on your local path 2 make sure you know the encrypting key Trust File Decrypting Applet Please click Yes on the security warning dialog to trust Online File Restorer If you click No Online File Restorer will not start Reason Additional privileges are needed to save files from the backup server to your hard disk Clicked No already Please close
78. 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 Page 52 Ahsay Offsite Backup Server v4 4 User s Guide Compress and encrypt data automatically Data are compressed and encrypted before they are uploaded to the server Not only does it reduces the storage space to keep you backup files it 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 How to backup files You can backup your data to an Ahsay Offsite Backup Server by following instructions below i Open Ahsay Online Backup Manager Right click Ahsay Online Backup Manager 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 danager ig Backup View
79. fsite Backup Server v4 4 User s Guide 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 Fixed Size Variable Size Database Buffers 269556596 bytes 453492 bytes 243269632 bytes 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 archive log filename C ORACLE ORADATA VIN ARCHIVE 1_57 DBF archive log filename C ORACLE ORADATA VIN ARCHIVE 1_58 DBF archive log filename C ORACLE ORADATA VIN ARCHIVE 1_59 DBF archive log filename C ORACLE ORADATA VIN ARCHIVE 1_60 DBF archive log filename C ORACLE ORADATA VIN ARCHIVE 1_61 DBF archive log filename C ORACLE ORADATA VIN ARCHIVE 1_62 DBF media recovery complete Finished recover at 24 JUN 03 RMAN gt alter database open resetlogs database opened thread 1 thread 1 thread 1 thread 1 thread 1 thread 1 thread 1 sequence 56 sequence 57 sequence 58 sequence 59 sequence 60 sequence 61 sequence 62 Page 70 Ahsay Offsite Backup Server v4 4 User s Gu
80. g Options button shows the extended features available Online Backup Manager Logon Login Name schering t Password tts Language English xi Backup Server G http C https Address faw BACKUP SERVER com Proxy Setting C Proy C Socks None ok Cancel Options lt Please logon to Online Backup Manager You can switch the language of the user interface by choosing the desired language available in the language drop down list The languages available include English French Traditional Chinese and Simplified Chinese For secure communication you can choose to communicate with Ahsay Offsite Backup Server in SSL Secure Socket Layer by selecting the https option The Address field shows the Ahsay Offsite Backup Server to which Ahsay Online Backup Manager will connect to authenticate your username and password You can use either a resolvable host name e g backup your domain com or an IP address e g 192 168 1 1 If the Ahsay 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 backup your domain com 8080 to connect to the server using the custom port number 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
81. gh ee M abe M acct M a mail2 xl Temporary directory for storing backup files CABackup MSExchange Change Cancel If this Exchange Server is also a domain controller of this Active Directory select the System State checkbox as well Otherwise please install Ahsay Online Backup Manager to the domain controller of this Active Directory and select the System State checkbox on that computer d Enter a temporary directory for storing the backup files before they are sent to an Ahsay Offsite Backup Server e Set the backup schedule for Database Backup Add new Lotus Backup Set x Backup Schedule Please schedule the backup time Database Backup Schedule Type Databas Transaction Log Backup Schedule Type Transaction log Weekly ekly Friday Add Remove Properties 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 Page 30 Ahsay Offsite Backup Server v4 4 User s Guide g Set the encryption algorithm encryption mode and encrypting key for this backup set Encryption Setting Please setup the encryption setting of the Backup Set I Do NOT use encryption Algorithm Twofish Mode CBC Cipher Block Chaini
82. i All database s restored successfully Page 81 Ahsay Offsite Backup Server v4 4 User s Guide 8 Backup Restore Lotus Domino Notes This chapter will describe in details how to use Ahsay Online Backup Manager 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 8 1 Requirements i Ahsay Online Backup Manager 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 Ahsay 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 C In the Use Directory on field choose the server s Domino Directory d Click Server Configuration and then click Current Server Document e Click the Transactional Logging tab f Complete these fields and then save the document Field Enter Transactional Logging Choose Enabled The default is Disabled Log path Path
83. ide 7 Backup Restore Microsoft SQL Server 7 0 2000 This chapter will describe in details how to use Ahsay Online Backup Manager 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 7 1 Requirements Ahsay Online Backup Manager 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 Ahsay Offsite Backup Server Please make sure you have sufficient space on your computer to store these data when you run the backup job 7 2 Overview Ahsay Online Backup Manager will backup your Microsoft SQL Server database s by taking the following steps Before running any backup activities Ahsay Online Backup Manager will run all Pre Commands of the backup set For each database that is to be backed up Ahsay Online Backup Manager 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 Ahsay Online Backup Manager will run all Post Commands of the backup set Upload all files copied to the temporary directory to the Ahsay Offsite Backup Server Page 71 Ahsay Offsite Backup Server v4 4 User s Guide 7 3 How to ba
84. iew i gt E Log Controller IA 3 Log Table 2003 06 19 17 57 01 109 G File Backup Type Log Time 2003 06 19 17 40 51 log GS Start 200310671917570 5 2003 06 19 17 57 01 l0g X ej j 0 TILLI HELGE Start running pre comma Finished running pre co Reading backup source f Reading backup source f Downloading server file li Downloading server file li Getting all files which hav Getting all files which hav Getting all files which hav Getting all files which hav Total New Files 10 Total Updated Files 0 Total Deleted Files 946 Total Moved Files 0 New File Uploading 100 New File Uploading 100 2003 06 19 17 57 02 2003 06 19 17 57 02 2003 06 19 17 57 02 2003 06 19 17 57 02 2003 06 19 17 57 02 2003 06 19 17 57 03 2003 06 19 17 57 03 2003 06 19 17 57 03 2003 06 19 17 57 03 2003 06 19 17 57 03 2003 06 19 17 57 03 2003 06 19 17 57 03 2003 06 19 17 57 03 2003 06 19 17 57 03 2003 06 19 17 57 05 2003 06 19 17 57 06 El Backup Log Backup Completed Successfully Backup Quota 50MBytes Last Backup 2003 06 13 17 20 Page 51 Ahsay Offsite Backup Server v4 4 User s Guide 5 Backup Restore Files This chapter describes in details how Ahsay Online Backup Manager backup your files and how you can restore your backup files from Ahsay Offsite Backup Server using your favorite browser 5 1 How files are backed up
85. ines 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 Ahsay Online Backup Manager it Online Backup Manager Miel E Backup Set Backup View i gt g Backup Controller X amp Backup Source BackupSet 30 3 User Profile D E 3 Floppy A BackupSetv30 7 E Local C e aT 0 CSE Backup Filter AT SAYA E Command Line Tool G Setting B Encryption 9 OracleBackupSet 1 4 Log Table BackupSetv30 Type Log Time Backup Log Welcome to Online Backup Manager Backup Quota 1GBytes Last Backup 2003 06 16 11 59 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 4 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 Only the checked files directories under this directory will be backed up If you add
86. kup 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 109 Ahsay Offsite Backup Server v4 4 11 4 Setting Change Report User s Guide 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 makes this changes change your password correct your setting and see ifthis happens again Ifthis happens again please contact us for further investigation If further assistance is necessary please refer to the FAQs section Source s C My Documenti Schedulefs None Filter None Retention Policy Keep deleted files for 7 days Transfer Size 256k bytes Pre Command s
87. lect Off site Backup Server to start backing up your files to an Ahsay Offsite Backup Server Confirm Backup Start x Backup to Local Hard Disk Seed Load Utility Start the backup for MSSQL BackupSet OK Cancel Page 19 Ahsay Offsite Backup Server v4 4 User s Guide 3 3 Quick Start Oracle 8i 9i Backup This chapter will give you the information on how you can backup an Oracle 8i 9i database to Ahsay Offsite Backup Server using Ahsay Online Backup Manager Requirements iv V Ahsay Online Backup Manager 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 Ahsay 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 Oracle JVM must be enabled JAVASYSPRIV role must be granted to system account Please refer to Chapter 6 Backup Restore Oracle 8i 9i for more information on these requirements How to backup Oracle 8i 9i database Please follow the instructions below to backup your Oracle database to the Ahsay Offsite Backup Server Install Ansay Online Backup Manager onto your computer Open Ahsay Online Backup Manager Right click Ahsay Online Backup Manager icon available in the system tray and choose Open Ba
88. ll Rights Reserved B 4 Page 56 Ahsay Offsite Backup Server v4 4 User s Guide Browse the backup set Current folder contains the latest copy of all backup files within a backup set yyyy MM dd HH mm folder contains the files that were removed from the Current folder at the time indicated These folders contain all your deleted files and the previous version of all your updated files Select the files directory you want to restore by checking the checkbox next to the files directories iv Restore your backup files a b Press the Restore button Select the Java Virtual Machine JVM you want to use and Press the Restore button E 215 x r backup files Microsoft Intemet Explorer Please select the Java Virtual Machine you would like to use to restore your backup files and press the Restore button below Use Microsoft Java Virtual Machine Use Sun Java Plug in 1 3 1 Restore lt you should see a Restore button here Troubleshooting 1 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 For Internet Explorer Users Please make sure the Use Java 1 x x for lt Applet gt option in Menu gt Tools gt Options gt Advance gt Java Sun is not checked If everything failed please choose the Use Sun Java Plug in 1 3 1 option ab
89. low the instruction on the installation wizard to complete installation Page 9 Ahsay Offsite Backup Server v4 4 User s Guide vi An Ahsay Online Backup Manager icon is now installed in the system tray next to your system clock To open Ahsay Online Backup Manager just right the icon and choose Open Backup Backup and Logoff Backup and Restart Backup and Shutdown Help Stop Running Backup gt Exit 14 46 2 2 Installing Ahsay Online Backup Manager on NetWare Please follow the instructions below to install Ahsay Online Backup Manager on Netware System Requirements NetWare 5 1 or above with Novell NetWare JVM 1 3 1 or above installed How to install Ahsay Online Backup Manager on NetWare vi vii Download Ahsay Online Backup Manager from http YOUR SERVER obs jsp applet obi obm netware zip or from http www ahsay com obs jsp applet obi obm netware zip Expand the zip file to SYS A SYS AhsayOBM directory should now be created Under the NetWare console run SYS AhsayOBM bin BackupManager ncf Enter the username password of your backup account Click the Options button and enter the hostname of your backup server Once logged on configure your backup set and close Ahsay Online Backup Manager Optional You can start online backup scheduler by running SYS AhsayOBM bin Scheduler ncf under the NetWare console Page 10 Ahsay Offsite Backup Server v4 4 User
90. mporary directory before they are sent to Ahsay Offsite Backup Server Please make sure you have sufficient space on your computer to store these data when you run the backup job Please refer to Chapter 9 Backup Restore Microsoft Exchange Server 2000 2003 for more information on these requirements How to backup a Microsoft Exchange Server Please follow the instructions below to backup your Microsoft Exchange Server 2000 2003 using Ahsay Online Backup Manager Open Ahsay Online Backup Manager Right click Ahsay Online Backup Manager icon available in the system tray and choose Open Backup Backup and Logoff Backup and Restart Backup and Shutdown b b gt gt Help Exit 14 46 Page 28 Ahsay Offsite Backup Server v4 4 User s Guide ii From the Menu Choose Backup Set 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 jj Backup Source fd Backup Schedule Frevious Page 29 Ahsay Offsite Backup Server v4 4 User s Guide C Select the database s to be backup xchange Backup Set x r Backup Source Please select Database to be backed up a My Computer a 7 System State E Microsoft Exchange Server 8 WIN2000SVR B m amp Microsoft Information Store 7 g First Storage Group DC 8 Mailbox Store WIN2000SVR M Public Folder Store VIN2000SVR aM
91. n directory under the installation directory of Ahsay Online Backup Manager e g C Program Files AhsayOBM bin ExchangeRestore exe to restore the exchange database s Simply run ExchangeRestore exe to print the usage Page 96 Ahsay Offsite Backup Server v4 4 User s Guide ExchangeRestore exe Usage C Program Files AhsayOBM 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 StorageGroupl 4 To restore an
92. ne GMT 08 00 HKT fs Contact 1 Name New Account Name Remove Email newaccount vour company com Add on Modules Microsoft Exchange Server Enable Microsoft SQL Server Enable Oracle Database Server Enable MySQL Database Server Enable Lotus Domino Enable Lotus Notes Enable Update Reset Zi Powered by Ahsay Offsite Backup Server v4 4 MAITT Copyright c All Rights Reserved Eb 2 Eo Done Ho S Page 8 Ahsay Offsite Backup Server v4 4 User s Guide iii Select your operating system ware Installation W Intemet Explorer x Select your Operation System Windows 95 Windows 98 ME Windows NT 7 2000 7 XP s 2003 Mac OS X v10 2 3 or later Redhat Linux 6 x Redhat Linux 7 x 8 x Other Linux Packages Sun Solaris 2 5 2 6 7 x 8 x se lt SOLARIS Cancel iv Press the Install button if you are using Windows Mac ware Installation Wizard soft Internet Explorer Install Online Backup Manager Please wait while applet is loading To install backup software press the button below Install Troubleshooting 1 Make sure you have clicked the Grant Always or Always or Grant this session or Yes button on the Security Warning dialog box If you have clicked the No button already please restart your browser and try again Cancel z Previous Step Next Step gt v Fol
93. ng 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 a Select the backup set you want to run on the left panel and press the Start Backup button b Select the backup type e g Database Log Files you would like to perform C Log Files c Select Off site Backup Server to start backing up your files to an Ahsay Offsite Backup Server and press the OK button C Local Hard Disk Seed Load Utility Start the backup for MSExchangeBackupSet 1 OK Cancel Page 31 Ahsay Offsite Backup Server v4 4 User s Guide d You should get something similar to the screen shot below Backup Set Backup View ae Backup Controller K Backup Set MSExchangeBackupSet 1 Backup Set Name MSExchangeBackupSet 1 f Backup Schedule Type Microsoft Exchange Server Backup a Bea Line Tool Properties 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 Backup MSExchange 1 071124 2004 01 31 13 53 47 G
94. ning MySQL server Data from MySQL server will be backed up to a temporary directory before they are sent to Ahsay 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 Ahsay 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 10 2 Overview Ahsay Online Backup Manager 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 Ahsay Offsite Backup Server Page 99 Ahsay Offsite Backup Server v4 4 User s Guide 10 3 How to backup MySQL server Please follow the instructions below to backup your MySQL server using Ahsay Online Backup Manager Open Ahsay Online Backup Manager Right click Ahsay Online Backup Manager icon available in the system tray and choose Open Backup Backup and Logoff Backup and Restart Backup and Shutdown
95. nts 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 Backup Set Backup View i gt o Backup Controller K Command Line Tool File Backup 7 User Profile a Pre backu y File Backup k F Backup Source fi Backup Schedule 2 Backup Filter Command No existing Command Line Tool K Working Directory 8 Encryption Add R E Oraclegi VIN a Aore Add new Pre beckup Command Line Tool x a E MSSQL Name Pre backup Command 1 Command Working Directory Browse Cancel J Log Table File Backup 4 j Tee Log Time Backup Log Welcome to Online Backup Manager Backup Quota 50MBytes Last Backup 2003 06 19 17 56 Both Pre Backup and 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 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 Type When Pre Backup Commancis run When Post Commands run File Befor
96. og Table BackupSet 1 Type Log Time Backup Log Backup Completed Successfully Backup Quota 50MBytes Last Backup 2003 06 13 17 20 Parameter Description Retention Policy During backup if Ansay Online Backup Manager 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 This setting defines how long files within the retention area will be kept on the backup server before they are deleted automatically from the server You can choose to have retained files deleted automatically after a number of days or after a certain number of backup jobs Transfer Size It defines the block size Ahsay Online Backup Manager 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 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 Follow Symbolic Link Under Unix Linux users can use symbolic link to create a simple link to a directory from another directory This setting defines whether you want Ahsay Online Backup Manager to traverse the symbolic links encounter
97. ore they are sent to Ahsay Offsite Backup Server Please make sure you have sufficient space on your computer to store these data when you run the backup job Please follow the instructions below to backup your Microsoft SQL Server databases to an Ahsay Offsite Backup Server Open Ahsay Online Backup Manager Right click Ahsay Online Backup Manager icon available in the system tray and choose Open Backup Backup and Logoff Backup and Restart I Backup and Shutdown gt Help Exit 14 46 Page 16 Ahsay Offsite Backup Server v4 4 User s Guide ii Create a backup set a From the Menu Choose Backup Set gt New gt MS SQL Server Backup Set f Backup Schedule EJ Command Line Tool Encryption b MSSQLBackupSet1 C Enter the Microsoft SQL Server administrator username and password Page 17 Ahsay Offsite Backup Server v4 4 d e f Select the database s you want to backup Backup Set x r Backup Source Please select databases to be backed up Microsoft SQL Server C B master O amp tempdb D model DC B msab D D pubs D Northwind C abe D B vincent D new_model CABackup MSS LServer Change lt Previous Next gt Temporary disk space used for storing spool files Cancel User s Guide Enter a temporary location to store the backup files before they are sent to an Ahsay Offsite Backup
98. otten Password section in the next chapter for more information on how to retrieve your forgot password report The Forgot Password Report contains the following information Sample Report Request for forgotten password Generated at SatJun 21 09 47 14 HKT 2003 FAQs 1 Why are you receiving this report Login Narne 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 106 Ahsay Offsite Backup Server v4 4 User s Guide 11 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
99. ove to restore your backup files N w Page 57 Ahsay Offsite Backup Server v4 4 C User s Guide Enter the directories to which backup files should be restored in the Restore File to textbox O up File Re 5 x Restore files to C Restore_Directory Decrypting Key ad 2003 06 20 15 45 49 Start 2003 06 20 15 45 49 Downloading restore file list 2003 06 20 15 45 49 C Restore_Directory KING1 BAK 2k bytes downloaded 2003 06 20 15 45 49 C Restore_Directory KINGIANS BAK 2k bytes downloaded 2003 06 20 15 45 50 C Restore_Directory mailapi jar 152k bytes downloaded 0 C Restore_Directory pop3 jar 16k bytes downloaded C Restore Directory Providers pdf 123k bytes downloaded Saving Providers pdf from il ahsay com Estimated Total Restore Time 0 sec Total 297k bytes 297k bytes restored Estimated Restore Time 0 sec Total 123k bytes 123k bytes restored Saving File To C Restore_Directory Providers pdf Restoring Speed 294k bytes second Cancel Enter the encrypting key which will be used to decrypt your backup files upon restoring your backup files Press the Start button Press the Start button Note 1 Online File Restorer can be started using Microsoft Java Virtual Machine or Sun Java Plug in 1 3 1 2 Timestamps of the restored files will be reset to those of the original files only if Sun Java
100. ovides you access to some additional features that are not available in Ahsay Online backup Manager This chapter describes each of these features in details 12 1 Install Ahsay Online Backup Manager Before you can use Ahsay Online Backup Manager you have to use the web interface of Ahsay Offsite Backup Server to install Ansay Online Backup Manager onto your computer Please refer to the installation section Chapter 2 for information on how to install Ansay Online Backup Manager onto your computer 12 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 4 Online Backup Management Console Microsoft Intemet Explorer 5 xi Backup Restore Install Software FAQs Help Engish Fraas Sce8 ia amp 3 User Summary Quota Data Area Retention Area Total Upload Total Restore 50M 314k 7 13k 2 328k 9 User Profile NewAccount Display Name New Testing Account Name Language English asl Time Zone GMT 08 00 Contact 1 Name New Testing Account Name remove Email user your company com 2 Name add Email Unit Compressed Size Total No of Files Key Powered by Ahsay Online Backup Server v4 2 Copyright c All Rights Reserved Bie Key Description Quo
101. r backup set new O r Backup Set Please type a name for this Backup Set Name foracieBackupset 1 Type Oracle Database Server Backup Oracle Database Server Login ID system Password Host Port 1521 User s Guide Enter the system password the Oracle Database Server Host Name TNS Port and SID Select the tablespace s you want to backup Backup Source o j Please selecttablespaces to be backed up Oracle Database Server D Bj SYSTEM M Aj OEM_REPOSITORY DARBS D JTEMP TAJ USERS DE Inpx Temporary disk space used for storing spool files CABackup OracleDB Change Previous Next gt Cancel Enter a temporary location to store the database file s before they are sent to an Ahsay Offsite Backup Server Page 66 Ahsay Offsite Backup Server v4 4 User s Guide f Set the backup schedule for database backup and archived log backup Add new Oracle Database Backup Set F xi Backup Schedule Please schedule the backup time Archived Logs BackupSchedule Type Archived Logs Weekly Mc BE N 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 se
102. re 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 accounthas Alias New Testing Account Name heen inactive for 30 days Ifthis 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 of this 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 refer to 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 Page 111 Ahsay Offsite Backup Server v4 4 User s Guide 12 Web Features Other than the features of Ahsay Online Backup Manager described in the previous chapter the web interface of Ahsay Offsite Backup Server pr
103. se Public Folder Store WIN2000SVR Start Restoring transaction log First Storage Group Restoring Log File F Temp restore tmp First Storage Group E00000B3 log Restoring Log File F Temp restore tmp First Storage Group E00000B4 log 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 97 Ahsay Offsite Backup Server v4 4 User s Guide vi 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 log Restoring Log File F Temp restore tmp SG2 E0100073 log End Restoring transaction log SG2 Start Applying transaction log End Applying transaction log End Storage Group SG2 End Exchange Server WIN2000SVR E Program Files AhsayOBM bin gt e 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 AhsayOBM bin gt ExchangeRestore DIR F Backup TEMP F Temp SERVER WIN2000SVR SERVICE Microsoft Information Store STORAGE SG5 DATABASE m
104. se 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 88 Ahsay Offsite Backup Server v4 4 User s Guide 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 Backup file C Lotus Domino Data statrep nsf recovered C Lotus Domino gt All content of all database s are now rolled forward to the last committed transaction found in the last archived transaction log d Restart Lotus Domino server vi If you just want to restore a singl
105. seeeees 75 Backup Restore Lotus Domino Notes cccccesssecesseeceeeeeceeeeeceeeeecseeeecsseeeesneeeesaes 82 Del JREGUIFEMMENES 220 utsal date eel alas atleast A 82 8 2 OVERVICW nce Sea recede eae aad at eles ee ale SMa ee 84 8 3 How to backup Lotus Domino Notes database s file s 0 eeeeeeeeeeee 84 8 4 How to restore Lotus Domino Notes database s file Ss cceseeeeees 88 Backup Restore Microsoft Exchange Server 2000 2003 eesceeeesceceereeeeteeeeees 90 9 1 RG QUITEINICTIUS laora r ae er esaat 90 9 2 OVeETVIEW iriso unwed ate ae ee Esa aa a 90 9 3 How to backup Microsoft Exchange Server 2000 2003 eeeceeeeeeeeeeees 92 9 4 How to restore Microsoft Exchange Server 2000 2003 0 0 eeeeeeeeseeeeeees 96 IBackup Restore MySQI Ser verter Git ius E E E EE ARE eae eae ERE 99 10A Re q irementse inas a saasadasayaceuasunccaieasemeanesenceadea ses 99 10 2 OVE EW n a a A A gee eee 99 10 3 How to backup MySQL Serve ceesceeesscecesececesececeeececseceeceececseeeeeeeeeeens 100 10 4 How to restore MySQL server ceescccesncecesececseececeeeeeceeeeeceeeecsteeeeeteeeees 104 Emal Reporting avs ts eenaa a a erea E E a EEE AAS OES SA 105 LIL New Us r Report oceinninincisoeo eieiei ir a E e a a ani 105 11 2 Fotot Password Reporteri mirei pira a E E es E EER 106 lI Backup JOB REPOT narnii a s EE a ER 107 ILA Setting Change Reporta saniser nen aA ehh a a ees 110 11 5 dnacive Us
106. splay Name dialog will appear Enter the new display name and press OK Display Name Scherring OK Cancel 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 Page 40 Ahsay Offsite Backup Server v4 4 User s Guide ntac Contact Name Email Address x 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 y com Properties xj sche Contact Name Scherring Email Address scherring ahsay com OK Cancel Page 41 Ahsay Offsite Backup Server v4 4 User s Guide 4 4 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
107. stem memory and in data files Backup by copying the data files while an application is running would fail to capture the application data stored in system memory in the backup job Not only is it backing up less data than what should be backed up it can also lead to data inconsistency that can finally result in backup files being unusable by the application The correct and the only right way to backup an application is to shutdown the application before running a backup job unless hot backup is supported When an application is shutdown it frees all its acquired system memory and flushes all application data from system memory to its data files The data files now contain everything needed to start an application successfully Backing up application data files when it is shutdown will guarantee data consistency and backup files recoverability You can use Pre Backup command and Post Backup command to shutdown and restart application before after a backup operation If you really want to backup your files while they are open Ahsay Online Backup Manager can work with St Bernard http www stbernard com Open File Manager to provide open file backup support Please contact us if you need more information 13 4 What should I do if a backup error is reported in my backup report i Check if this is a configuration problem e g network problem proxy setting problem ii Check error log and activity log which can be located in C Program
108. store Install Software FAQs Help English Frencas Seng tai tt Geta ay ue t sea BackupSet 0 yr ees 2003 06 21 09 58 d Job Status Backup finished successfully Detaile RE Backup Time 2003 1 57 2003 06 21 09 57 Report KEP User Account Statistics ent Console Microsoft Intemet Explorer More Information port is Backup Job Statistics New files 1 9k bytes J Backup Data Size 314k bytes Updated files 1 9k Retention Area Size Deleted files 1 4k Total Upload Size k bytes gt Moved files 1 3k bytes Backup OA RTE Unit Number of files Total file size RORI ucts 9 7M bytes Note Records for all backup jobs are kept for a period of 60 days All logs outside this period will be deleted automatically Powered by Ahsay Online Backup Server v4 2 Copyright c All Rights Reserved BAO 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 Time 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 back
109. t Add new Oracle Database Backup Set xj Encryption Setting Please setup the encryption setting of the Backup Set I Do NOT use encryption Algorithm Mode CBC Cipher Block Chaining C ECB Electronic CookBook Encrypting Key Confirm Encrypting Key lt 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 iv Run Backup a Select the backup set you want to run on the left panel and press the Start Backup button P Page 67 Ahsay Offsite Backup Server v4 4 User s Guide b Select the backup type e g Database Backup Archived Log Backup you would like to perform ckup Type OrecleBackupSet 1 C Archived Logs OK Cancel C Select Off site Backup Server to start backing up your files to an Ahsay Offsite Backup Server Confirm Backup Start x Backup to ci C Local Hard Disk Seed Load Utility Start the backup for OracleBackupSet 1 OK Cancel 6 4 How to restore an Oracle Database Please follow the instructions below to restore your Oracle 8i 9i databases from an Ahsay Offsite Backup Server Download the backup files from the Ahsay Offsite Backup Server Please refer to the Quick Start Backup File section for information on how to download backup files from Ahsay Offsite Backup Server
110. t gt Backup and Shutdown gt Help Exit 14 46 This icon is the entry point to Ahsay Online Backup Manager Right clicking the icon will show a menu that provides the following functions Menu Item What it does Open Run Ahsay Online Backup Manager 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 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 Page 38 Ahsay Offsite Backup Server v4 4 User s Guide 4 2 Logon Dialog Before you can use Ahsay Online Backup Manager you have to be authenticated by the Ahsay Offsite Backup Server first The logon dialog shown below will check if you have the right to access Ahsay Online Backup Manager by submitting the username and password you provided to the backup server i Online Backup Manager Logon Login Name scherring Password OK Cancel Please logon to Online Backup Manager Pressin
111. ta 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 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 Page 112 Ahsay Offsite Backup Server v4 4 User s Guide Contact Email Address that will be used to contact you 12 3 Request your 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 e k ent Console Microsoft Intemet Explorer 15 xj Free Trial Registration FAQs Help Mf a Benefits Password Request ebasy touse Login Name NewAccount Fully Automated or Daily backup Email Save you time and ae At a glance How to retrieve your forgotten password Backup your data i Enter either your Login Name or Email in the form automatically every above aay ii Press the Submit button Access your data E E iii You should receive your password immedi
112. terwards To perform seeding loading please do the following i Open Ahsay Online Backup Manager from the System Tray see previous sections for details ii Setup your backup set see previous sections for details iii Select the backup set you want to run on the left panel and press the Start Backup button 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 Confirm Backup Start x Backup to C Off site Backup Server Start the backup for FileBackupSet 1 OK Cancel Page 59 Ahsay Offsite Backup Server v4 4 User s Guide 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 E Seec Loaaing Directory vi You should get the message Backup Completed Successfully as shown below after all backup files are spooled to the directory you specified Backup Set FileBackupSet 1 Backup Type File Destination Directory Eein oneer Browse Collecting all files in this backup set Completed a Total Files 1 5 Process
113. tjava sql Page 63 Ahsay Offsite Backup Server v4 4 User s Guide iv JAVASYSPRIV role is granted to system account You can grant this role to system account by executing SQL gt grant J AVASYSPRIV to system 6 2 Overview Ahsay Online Backup Manager 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 all data files in each of the tablespace s selected are copied to the temporary directory specified by this backup set 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 all non default initialization parameters will be spooled to an initializing file located in the temporary directory specified by this backup set all control files will be copied to the temporary directory specified by this backup set 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 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 Ahsay Offsite Backup Server If your Oracle database is running on
114. up 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 Ahsay Online Backup Manager 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 default asp Microsoft Information Store Exchange Server stores all emails and documents inside its databases which are grouped together as storage groups inside Microsoft Information Store It is important that Microsoft Information Store is fully backup when backing your Exchange Server Page 90 Ahsay Offsite Backup Server v4 4 User s Guide 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 Management Service Exchange 2000 only Similarly if you have setup your Exchange
115. up files from hard disk Completed Local Copy New File Copying C AUTOEXEC BAT to C LocalBack Local Copy New File Copying C boot ini to C ALocalBackup C_ bo Downloading server file list Completed Local Copy New File Copying C dell img to C LocalBackup C_id Local Copy New File Copying C drvnet img to C LocalBackup C_ Local Copy New File Copying C drvnet2 img to C ALocalBackupic Local Copy Finish running local backup Getting all files which have been added Completed 2004 05 18 16 01 33 2004 05 18 16 01 33 2004 05 18 16 01 33 2004 05 18 16 01 33 2004 05 18 16 01 33 2004 05 18 16 01 33 2004 05 18 16 01 33 2004 05 18 16 01 33 2004 05 18 16 01 33 2004 05 18 16 01 33 2004 05 18 16 01 33 2004 05 18 16 01 33 2004 05 18 16 01 33 2004 05 18 16 01 34 2004 05 18 16 01 34 2004 05 18 16 01 35 2004 05 18 16 01 35 2004 05 18 16 01 35 2004 05 18 16 01 35 Backup Completed Successfully Quota Remaining Total 4 42G 5G Last Backup 2004 05 17 11 05 Page 62 Ahsay Offsite Backup Server v4 4 User s Guide 6 Backup Restore Oracle 8i 9i This chapter will describe in details how Ahsay Online Backup Manager backup your Oracle 8i 9i and how you can restore an Oracle 8i 9i database using the backup files 6 1 Requirements Ahsay Online Backup Manager must be installed onto the computer that can connect to your Oracle 8i 9i
116. up 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 116 Ahsay Offsite Backup Server v4 4 User s Guide You can open the Full Backup Report to review all information logged by a backup job by clicking the Detailed Report image on the Report panel Full Backup Report Full Backup Report Generated at Sat Jun 21 10 00 05 HKT 2003 Backup Job Summary Backup Set BackupSet 0 Backup Job Statistics Unit Number of files Total file size Backup Job 2003 06 21 09 58 Backup Status Backup finished successfull Backup Time 2003 06 21 09 57 2003 06 21 09 57 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 New Files compressed Files C Test lib New DANIEL DOC Updated Files Files Ci Test lib DANIEL
117. using a browser a Comprehensive backup report lists all files backed up Backup report will be delivered to user automatically via email when each backup job completed a Backup data are CRC validated before they are stored on server E Customizable data retention policy allows user to access files even when they have been deleted a 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 a Run any custom OS commands before after a backup job a Run on Windows MAC OS X Netware Linux Sun Solaris and all other platforms supporting a Jave2 Runtime Environment 1 3 1 a LiveUpdate allows patches to be deployed to hundreds of clients easily Page 6 Ahsay Offsite Backup Server v4 4 User s Guide 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 Requirement OS Windows 95 98 ME
118. ver v4 4 User s Guide 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 ole Microsoft Intemet Explorer 5 xj Backup Restore Install Software FAQs Help Mfr BeBe Ta F Select a month Month rvyy Mm 2003 06 7 Storage Usage Summary Date Data Area Retention Area Uploaded Size Total Storage 2003 06 01 111 6M 245 81 6M 81 olo 193 1M 326 2003 06 02 111 6M 245 81 6M 81 olo 193 1M 326 2003 06 03 34M 52 118 8M 157 59 4M 93 152 8M 209 2003 06 04 34 2M 69 118 8M 157 217k 17 153M 226 2003 06 05 34 7M 87 118 8M 157 553k 18 153 5M 244 2003 06 06 81 2M 545 118 8M 157 46 5M 458 200M 702 2003 06 07 37 4M 103 200M 702 37 4M 103 237 4M 805 2003 06 08 37 4M 103 61 2M 545 olo 118 6M 648 2003 06 09 50 3M 127 76 4M 509 12 9M 32 126 7M 636 2003 06 10 153 4M 228 222 7M 656 249 5M 248 376 2M 884 2003 06 11 157 5M 280 olo 4 1mM 52 157 5M 280 2003 06 12 161 6M 334 olo 4m s4 161 6M 334 2003 06 13 165 6M 382 olo 4m 48 165 6M 382 2003 06 14 129 1M 70 165 2M 379 128 8M 67 294 4M 449 2003 06 15 126 5M 63 167 9M 386 olo 294 4M 449 2003 06 16 126 5M 63 55 4M 283 olo 181 9M 346 2003 06 17 148 7M 290 55 4
119. vices 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 80 Ahsay Offsite Backup Server v4 4 C Select the Database radio button Restore database E xj General Options 5 Restore as database fabc fasl Restore Database Filegroups or files C From device Parameters Shom bacamo of dle S First backup to restore 1 2001 18 52 43 zi SESE T r Backup set date Size Restore from L set name 13 11 2001 1 OKb C MSSQL Cancel Help User s Guide 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 f 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 v
120. you informed with the status of your backup activities Please make sure your contact information within the backup system is correct to receive the reports described in this chapter 11 1 New User Report 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 Getting started 1 Login to our homepage 2 Follow the User s Guide to start using our backup services Further Information If further assistance is necessary please refer to the FAQs Generated at SatJun 21 09 32 36 HKT 2003 NewAccount pwd New Testing Account Name English user your company com 50M backup your company com Login Name Password Alias Language Contact Backup Quota Backup Server 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 105 Ahsay Offsite Backup Server v4 4 11 2 Forgot Password Report User s Guide 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 Forg

Ahsay Offsite Backup Server v4.4 User's Guide

Contents

Download Pdf Manuals

Related Search

Related Contents