Home

Fusion Research Database Utility User Manual v3_0

1. Data Migration Upgrade prior versions of HLA Fusion database to 3 0 A list of various database tasks which can be performed with the Fusion Database Utility HLA Fusion Research Version 3 0 Database Utility Guide B x Create new Fusion database Switch connection to other Fusion database Attach Detach Fusion database Backup Restore Fusion database Merge Fusion database Message Please note that some database functions such as Create Delete Backup Restore Migration Attach Detach etc requires administrator level privilege Please see your systems administrator if pou need to perform these actions The maximum allowed database name is 35 characters Status Bar je User Name sa Server Name HlocalSQLE PRESS Database Name FUSION 3 0 Database Mode Server Standalone Figure 1 HLA Fusion Database Utility Main Window The status bar at the bottom of the Fusion Database Utility main window displays the Active User Server Name Database Name and the Database Mode i e Fusion and the database are on the same computer or the database resides on an external server e The User Name field will say Not Set if you are using Windows Authentication e A Help button is available on every Database Utility window or press the F1 key e Click the signs on the far left to display or hide related database utility menu options HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Gui
2. HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 6 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Deleting a Database From the Database Utility window you can delete an existing database from the server 1 Within the Database Utility window click Delete Database Delete Database SOL Server SQL Server locall SQLEXPRESS Database Dabas OOS R 2 From the Database Name drop down list select a database and click the Delete button The following prompt is displayed FUSION 30 101011 Figure 9 Select Database to Delete Note If you receive a message that the selected database is busy please try this action again in afew minutes You cannot delete an attached database Delete Database SOL Server SQL Server locall SOLEXPRESS m Database Database Name S ESTO ien Y 3 Click the Delete button HLA Fusion x 2 Delete this database e Figure 10 Delete Database Figure 11 Delete Confirmation 4 The following confirmation message is displayed Click the Yes button to continue with the database deletion HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide HLA Fusion x The Database Utility confirms the deletion l Database successfully deleted Figure 12 Database Deleted HLA Fusion x s Database UAT n
3. ONE LAMBDA Advancing Transplant Diagnostics User Manual Database Utility HLA Fusion Research Software Version 3 0 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide All of One Lambda software products are designed to assist personnel experienced in HLA analysis by suggesting typing results However any clinical or diagnostic results must be carefully reviewed by a person qualified in HLA typing to assure correctness This software may be used to aid in suggesting results but should not be used as the sole method for determining reportable results This software is meant as a laboratory aid not as a source of definitive results The software design does not mitigate hazards associated with the software The laboratory director or technologist trained in histocompatibility testing is required to review all data to detect any problems with the software Please note that this document was prepared in advance of the HLA Fusion Research software release Therefore you may notice slight differences in the content of the actual application screens For Research Use Only Not for use in diagnostic procedures 21001 Kittridge Street Canoga Park CA 91303 2801 Tel 818 702 0042 Fax 818 702 6904 www onelambda com LABType LABScreen and FlowPRA are registered trademarks of One Lambda Inc HLA Fusion LCT LAT Micro SSP and LABScan 100 are trademarks of One Lambda Inc Luminex is a register
4. Sunday User Hame f LAMBDA Thomas Password esssssss Schedule Delete Help Close T XGNE LAMBDA Figure 23 Database Backup Scheduler Complete the fields in the Database Scheduler to set the backup day and time Database Backup Job Name Enter a unique name for the backup Each scheduled backup task requires a unique name Schedule Backup Use the drop down arrow to select the backup frequency Daily Weekly or Monthly Backup Time Use the up down arrows to set the time at which to start the scheduled backup Please note that the length of time required to back up a database is proportional to its size the larger the database the longer it takes to back it up Start Date Click the drop down arrow and select the date on which you want the scheduled backup process to begin Days of the week If you selected a frequency of weekly or monthly select the check box for the day s of the week for which you would like to schedule backups This option is grayed out if the specified frequency is Daily Enter your Windows password in the Password field You must enter your Windows password to ensure you have the correct privileges to back up the database as specified Click the Schedule button You are not required to have HLA Fusion Research running or be logged in to run the scheduled backup task However you must have your computer on during the backup period HF MAN v3 x x EN 01 Rev 0 HLA Fusion Resear
5. database Different collations use different comparison rules for data handling which can cause a conflict during database merges HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 4 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide HLA Fusion x Provided the newly created database name Database FUSION _1 successfully created Do you want bo connect to it does not already exist the system creates the new database and displays the following no message Figure 3 Database Created Confirmation 5 Click Yes to connect to it Click No if you do not wish to connect to it at this time If you click Yes a connection confirmation message is displayed 6 Click the OK button x J Database connected successfully lf the newly created database name already exists the Database Utility displays the following error message Figure 4 Successful Connection 7 Click the OK button Then x ve rify th at th e d atabase 6 An error occurred when creating the database Database already exists Please recheck the server name userid and password if using SQL Server Authentication and database name name you entered is unique to the selected SQL Server and retry Figure 5 Database Creation error Note The Fusion Database Utility creates a User ID named FUSION_USER within the database at the time of creation Please do not alter the status of this user The
6. and click the Schedule button 10 The Fusion Database Utility will display a message indicating that the Database Optimization job has been successfully scheduled Note The computer or server on which the Fusion Database resides must be turned on at the same time the optimization job is set to begin HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 25 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Reconfiguring a Fusion Database Reconfiguring a Fusion Database allows you to increase the size of an existing database Note If you are using Microsoft SQL Express and you selected Unlimited as the database size when the database was initially created the size of your database can not be increased because it is already at the maximum size allowed by Microsoft SQL Express To reconfigure and increase the size of an existing Fusion Database please do the following 1 Select Reconfigure Database from the list of f SOL Server Database Tasks in the Fusion Database SOL Server locansaLERPREss o A Utility Settings us_english SOL_Latin _GeneraLCP1_CI_AS SQL 2005 Express Edition with Advanced Services 2 Ensure that you re connected to the correct SQL Server Database Database Mame AME tra me ball BE lee File Size GB L Unlimited 1 000 0 3 If not click the Browse Button in the SQL Server section to select the correct SQL Server Database Version 3 0 0 13
7. default database administrator user name and password for a local client server installation e It is highly recommended that you do not switch collation and regional settings between databases The collation of databases and the SQL Server play a major role during database merge and migration A collation encodes the rules governing the use of characters and numbers for a language or an alphabet e Please do not alter the permissions i e who has the right to make certain changes to the database 1 Double click the Database Utility icon on your computer desktop TEEN The Connect to SQL Server dialog box is displayed Connect To SQL Server mw Lip Xf HLA Fusion SOL Server SOL Server 2 Make sure your SQL Server information is correct and click the OK button Connect Using C Windows authentication SQL Server authentication Login Name Your Login Name or JL ew Je 7 SONE LAMBDA HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 2 One Lambda Inc The Database Utility Main Window is displayed Database Utility l i 0000000 HLA Fusion O Database Tasks Create Fusion Database Select Connect to Fusion Database Delete Database Attach Database Detach Database Backup Database Restore Database Merge Database CreateS elect Audit Log Database Optimize Database Reconfigure Database Merge Audit Log database i Curent Database Details
8. maximum length of a database name must not exceed 35 characters HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 5 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Selecting and Connecting to a Database From the Database Utility Window you can choose to connect to a database that already exists on the selected server The subsequent analysis with HLA Fusion will use the selected database 1 In the Database Utility window click the SQL Server SaL Server ocase es Select Connect to Fusion Database option Settings Ws_englizh SQL_Latin _General_CP1_CI_AS SOL 2005 Express Edition with Advanced Services Database eee sion 30 Fa 2 From the Database Name drop down list select a database The database version creation date percentage used Database Version 310 013925 Created on 8 9 2012 as well as current and maximum sizes of Used 0 179 MB of 1024000 MB DE size the selected database are displayed below Figure 6 Select Database xi J Database connected successfully 3 Click the Set button The following message is displayed Figure 7 Database Connected 4 Click the OK button The database you selected is now listed in the Database Name field in the Status Bar at the bottom of the Database Utility window User Name sa Server Name flocalSQLE PRESS Database Name FUSION 30 Database Mode Server Standalone Figure 8 Utility Status Bar
9. 925 Created or 12 1 2011 Used 02 10 MB of 1024000 MB DB size 4 Choose the database that your want to reconfigure by clicking the down arrow at the right side of the Database Name field to select it Figure 42 Reconfigure a Database a Increase the size of the database by typing a new size or by clicking the up and down arrows in the field just below the Database Name b Or increase the database size to its allowable maximum size by placing an arrow in the Unlimited size box provided for this purpose 5 Click the Set button 6 The Fusion Database Utility will display a message that the database reconfiguration was successful HF MAN Vv3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 26 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Merging an Audit Log Database lf you ve merged two Fusion Databases together you may also want to merge the associated Audit Log Databases The process is similar to merging Fusion Databases together Note It s always best to backup databases before merging them together Within the Fusion Database Utility select Merge Audit Log Database Werge Log Database a The Merge Audit Log feature of the Fusion Database Utility is Database Name auctLog SSCS divided into two sections The top part or Source Audit Log Soe ue aE ban Leea PI EAS Database can be merged into the Target Audit Log Database at the bottom Tar
10. New Folder button and create a special folder for your database backups The backed up files are stored with a bak file extension 5 Do one of the following to either back up the database immediately or schedule for another day s and time e To perform a backup of the database immediately click the Backup button The following message confirms a successful database backup Backup Database x Lu i 1 J Database FUSION 30 successfully backed up Click the OK button to exit Figure 22 Database Backup Confirmation Note The length of time required to back up a database is proportional to its size the larger the database the longer it takes to back it up e To schedule backup s for a future date and time or on an automated schedule click Schedule Backup The backup scheduler is displayed HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 13 One Lambda Inc Note HLA Fusion Research Version 3 0 Database Utility Guide HLA Fusion Database Backup Scheduler ioj x HLA Fusion amp Database Backup Job Name FUSION 30 gf A unique name for the backup job Schedule Backup Weekly _ How often the backup will run Backup Time 3 30 00 AM lt i Time of day the backup will begin ee Friday June 15 2012 First day the backup job will run Day of the week a Monday Tuesday al Wednesday Thursday al Friday Saturday
11. SOLEXPRESS ssl Database File To Restore C SOLI FUSION SdatatempFUSION 30 bak ssl Figure 28 Prepare to Restore Backup 2 Click on the browse button L next to File To Restore text box This brings up the File Selection window 3 Browse to select the database backup file will have a bak extension to restore and click the Open button Please select database file to restore l 2 x Look in temp gt OQ Tega r FUSION_30 bak My Recent Documents Desktop My Documents My Computer My Network File name FUSION_30 X Places Files of type Backup Files bak ai Cancel Figure 29 Select Database Backup File HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 17 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Restore Database SQL Server SQL Server locall SGLEXPRESS m 4 Enter a unique name for the restored Database File To Restore EMOLI FUSION data temp FUSION 30bak database in the Restore as field Restore az FUSION 30 Figure 30 Enter Database Restore Name x 5 Click the Restore button and the following message is displayed _l Database FUSION _30_Restored successfully restored Figure 31 Database Restore Successful 6 Click OK The database is restored using the specified backup file Note SQL Server does not allow you to restore databases from certain locations such as
12. _0 27 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Current Database Details Selecting Current Database Details from the menu on the left side of the Database Utility brings up a detailed listing of the most important information concerning your Fusion databases Current Database Details m Fusion Database SQL Server Instance Name local SQGLEXPRESS SOL Version 2008 Express Edition with Advanced Services SQL Name FUSION 3 0 Version 3 0 0 13925 Created on 9 13 2012 Settings us_english SQL_Latin _General_CP1_CI_AS File Total Used approx Primary 1024000 MB 10 MB 0 Well Detail 1024000 MB 10 MB Well Result 1024000 MB 10 MB Log 1024000 MB 28 MB m Audit Log Database SQL Server Instance Name local SQGLEXPRESS SOL Version 2005 Express Edition with Advanced Services SQL Name Audit Log 1 Settings us_english SQL_Latin _General_CP1_CI_AS Used 10 MB approximately 0 of 1024000 MB available file space Figure 46 Database Details The top part of this screen deals with the main Fusion database while the bottom section is devoted to the Audit Log database If the percentage of a database file exceeds 90 it may be time to Optimize and or Reconfigure to free up more space HF MAN Vv3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 28 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Data Migration Upgrade Prior Database Ver
13. abase Utility Guide 7 Note that during the database upgrade SQL Server will temporarily require additional hard drive Space to complete the process If the additional hard drive space is not available or your database exceeds the size limitations of SQL Express during the upgrade the process may fail Here are a few suggestions to solve this problem 1 Reduce the size of the database by moving sessions from the current database to another database 2 If you re using SQL Server 2005 Express which has a four gigabyte size limitation consider upgrading to SQL Server 2008 Express R2 which allows a larger ten gigabyte database size 3 Purchase the full version of MS SQL Server which offers a nearly unlimited database size HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 30
14. atabase LP tempt UAT Puata im Users Log 3 Select the database mdf file and click the Open button The selected mdf file displays in the MDF file to attach field Filet of type MOF lies erdi y Figure 15 Choose Database to Attach HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 9 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Enter a name for the database in the Attach as field MDF file to attach C Program Files Microsoft SOL ServersMSSGL m Attach az FUSION 3 0 Figure 16 Attach to the Database 4 Click the Attach button HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 10 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Detaching from a Database If you wish to move a database file mdf to another location for disk space considerations or other reasons you must first detach it from Fusion Then you can relocate it and link to its new location see Attaching to a Database Or you may no longer want to have HLA Fusion Research Software linked to a particular database but you do not want to delete it yet Note You cannot detach a database which is currently in use Detach Database SOL Server 1 Within the Database Utility window click SQL Server al Detach Database Database Database Name Figure 17 Detach a Database SQL Server SOL S
15. ch Database Utility Guide v3_0 14 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide If your scheduling is confirmed the following message is displayed and you should click OK HLA Fusion Database backup scheulde x The database backup job FUSION 30 scheduled successfuly to run on a Weekly basis Figure 24 Scheduled Backup Confirmation Note The directory you specified for the scheduled backups will contain the database backup file mdf as well as a log file that documents the backup job status HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 15 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Deleting a Scheduled Backup Take the following steps to delete a scheduled backup job 1 Click Schedule Backup The backup scheduler is displayed HLA Fusion Database Backup Scheduler i 15 x HLA Fusion Database Backup Job Name Frequency Reall i RealUpgradeS cheduledT askS 1 5 Start Time Reall poradeLogon askS 1 5 21 2 2 Use the drop down arrow in the Database Backup o REEE RlealUpgradeLogonT askS 1 5 21 3 Job Name field to select a scheduled backup task to Day of the week ReallpgradeLogontT ask5 1 5 21 3 T Monday T Tuesday T Wednesday delete T Thursday I Friday T Saturday T Sunday UserName Bsmith Password leseeeee Schedule Delete Help Close Do LAMBDA OOOO Figure 25 Select Create Backu
16. de v3_0 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Database Tasks The Database Tasks listed on the left side of the Main Window offer various means to configure manage and maintain a Fusion database These functions are described in the following sections Creating a New Database Note A new database can be created only on the computer or server on which the SQL Server program resides 1 On the left side of the Database Utility window click Create Fusion Database Create Fusion Database SQL Server SQL Server flocal SGQLESPRESS Settings us_english SQL Latin General CP1_ CLAS SQL 2005 Express Edition with Advanced Services Database Database Name FUSION File Size GB 1 000024 Unlimited Fusion will create 4 files each with the size specihed above Figure 2 Create Fusion Database Screen 2 Make sure the SQL Server is the correct one for the database you want to create 3 Enter a unique Name for the new database 4 Choose the maximum database size and click Create Note With SQL 2005 Express and SQL 2008 Express placing a check mark in the box next to Unlimited will create a database in the maximum allowable size of four gigabytes For a purchased full version of SQL Server the maximum database size is one terabyte Ensure that you have adequate storage space for a database of this size Please ensure that you maintain consistent collations of your Fusion SQL Server
17. dit Log 1 successfully created Bo vou want bo connect to it eT Figure 35 Audit Log Creation Confirmation 3 If you want to connect to the audit log database now click Yes Otherwise click No If you choose to connect a message displays to confirm the connection HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 21 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Log Database Connection x _l Audit Log Database connected successfully Figure 36 Audit Log Connection Lab Supervisors can access the Audit Log from the HLA Fusion Home page by clicking Reports on the Fusion toolbar At the Reports screen select Miscellaneous followed by Audit Trail Log Miscellaneous My Favorite Tools Database Information Batch Data File Summary MMOP Code Serological Equivalent Typing Query Audit Trail Log Figure 37 Access Audit Trail Log HF MAN Vv3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 22 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Optimizing a Fusion Database Optimizing a Fusion Database on a regular basis speeds up the analysis process by compacting wasted Space automatically repairing errors and optimizing data storage To optimize a Fusion Database do the following Open the HLA Fusion Database Utility 1 Select Optimize Database from the Database Tasks Menu Database Utility HLA Fu
18. eated between the source and target databases For more information please refer to http support microsoft com kb 325335 4 Click the Merge button HLA Fusion x 1 The databases are merged successfully After the Merge is completed the following message is displayed Figure 33 Merge Completed 5 Click the OK button to return to the main Database Utility Screen HF MAN Vv3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 20 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Create Select an Audit Log Database This function allows you to create a database as an Audit Log to record all user activity in HLA Fusion Software 1 Within the Database Utility window click Create Select Audit Log Database Create Select Audit Log Database SQL Server SQL Server local MSQLEXPARESS Settings Ws_english 5QL_Latin _GeneralCP1_Cl_As SOL 2005 Express Edition with Advanced Services Database Database Name f File Size GB Unlimited 1000 0 Used 24 10 MB of 512 MB DE size Figure 34 Create Select Audit Log Database 2 Do one of the following e Select a database from the Database Name drop down list and click Set e Or enter a unique Database Name in the Database Name field and click New Database A message is displayed confirming audit log database creation and asking whether you want to connect to it HLA Fusion xj q P Database Au
19. ed trademark of Luminex Corporation Windows is a registered trademark of Microsoft Corporation Copyright 2012 One Lambda Inc All rights reserved March 2012 HLAF MAN V3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 ii One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Table of Contents Opening the HLA Fusion Database Utility 2 0 0 0 cecccccccssseceeeeeeeseeeeeceeseeeeeeseessceeeeeeeeeeesseeeaeeeessaeaeeeeeesaaeeeeeeeas 2 Paapa o TA eo ssc cere cess acne E en sece cau sgene Gaciesacees seauseqescoscasenegacegosesaceaeuadse ee steed que esuesemeceeees 4 Creating a New ID AA ASS aereciacc een ticsactsnes araemedicanaccnnenananedinetiavanthoaeea6s 2acaneniarsesnticgsa tenn de esetoademmeteianedeseavedsaed aur earans 4 Selecting and CONNECTING tO a DALTADASE oe eee eceecccceeeeeceseeeceeeeceneeeeeseeteeeeetenececeuececeneceeeneetaeseetseeeetaeeensness 6 PAN re 216 188 Ae e2 09 DataNDa E aes mn es eT ne eee ee ee ee eee 9 D taching from a Database seis cecevsvananwesausinedanainodadinacaiecdai bncsa sktayaadiewandadenantiadunielinasqiiaeries Satwinndedinaanncbeanandeumenadsatnts 11 Deleting a Scheduled BACKUP ccccccesececeseeeceseetceseetensceteececeeeeceneeeseseeteaseetenseeteneeetsesenegeetsageetsageeensness 16 FISSIONING aul ald Se osna ennn stinni ai ia ariii O Aira ain T Ai 17 Merging DataDa GS eieren nienn ear AEO TEREE EEEE aNEKSi 19 Create Select an Audit Log Databa
20. ete the process If the additional hard drive space is not available or your database exceeds the size limitations of SQL Express during optimization the process may fail Here are a few suggestions to solve this problem HF MAN Vv3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 23 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide 1 Reduce the size of the database by moving sessions from the current database to another database 2 If you re using SQL Server 2005 Express which has a four gigabyte size limitation consider upgrading to SQL Server 2008 Express R2 which allows a larger ten gigabyte database size 3 Purchase the full version of MS SQL Server which offers a nearly unlimited database size A database can be optimized automatically in the same way that a database can be backed up on a pre set schedule HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 24 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Scheduling Database Optimization Setting the Fusion Database Utility to automatically perform database optimization is accomplished in exactly the same way as scheduling an automatic database backup 1 Select Optimize Database from the list Homma of database tasks in the Fusion Database SOL Server Uti ity SQL Server local SQLE PRESS Settings us_english 3QL_Latin _General_CP1_Cl_As SQL 2005 Express Edition w
21. ever m Database 2 From the Database Name drop Deters en I ki down list select a database and click the Detach button The following message is displayed Figure 18 Select Database to Detach x f I Database successfully detached 3 Click the OK button s JJ File datakched c Program Files Microsoft SOL Servern MSSL 1 MS5OLiD47 4 FUSION New mdf Figure 19 Database is Detached Note A detached database mdf file is located in the directory where the Fusion instance of SQL was installed e g the default is C Program Files Microsoft SQL Server MSSQL1 MSSQL Data HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 11 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Creating a Database Backup File It is recommended that you create regular frequent backups of your HLA Fusion database s If some event occurs that corrupts a database or makes it inaccessible having a backup copy of the database allows you to restore all data up through the date of the most recent backup Use the Schedule Backup feature to set up automated regular backups of a specified database any day or time and as often as desired For information on restoring a database with a backup copy see The backed up database must be saved to the local drive of the server or the computer on which you are creating the backup copy The filename of the backup file is the name of the database with a bak
22. extension Note You can use a shared or network mapped drive to store backups if the SQL agent Is given the appropriate permissions to that directory For more information please refer to http support microsoft com 1 Within the Database Utility window click Backup Database Backup Database SOL Server SOL Server locall SOLEXPRESS m Database Database Mame Destination CAOL FUSION data temp m Backup File Figure 20 Backup a Database 2 From the Database Name drop down list select a database 3 Click the Browse button L next to the Destination field Note Make sure you select a destination directory that is on the selected SQL Server Do not choose your desktop as the location for backups It is recommended that you create a special folder for these on the C drive e g C DB Backups HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 12 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Browse For Folder Please select Destination Directory a 56 This brings up a new window where you can browse to select a A dts destination folder for the database backup A r O export O NMDPExport B report E O session 5 temp rpt Make New Folder OK Cancel A Figure 21 Select Backup 4 Indicate a database backup file name in the Backup File field by default it is the database name You may also click the Make
23. from a network drive or from a backup file on your computer desktop HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 18 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Merging Databases This function allows you to combine two databases into one regardless of their location There are certain guidelines to follow when merging databases Both databases must be the same version of an HLA Fusion Research database Both databases should be backed up before performing a database merge The source database information is copied into the target database When merging into an existing HLA Fusion Research database ensure that destination database size is big enough to store the source database if you are merging into an existing database By existing database we mean that it has lab and user information at minimum The source database lab data will be copied if it is missing from the target database When merging into a new HLA Fusion Research database first create a new database using the Create Database function and make the size large enough to accommodate the source database Note that Donor Group Names Patient ID s Test Types and Test Dates will not be merged if this information already exists in the Target Database 1 Within the Database Utility window click Merge Database 2 Select a database from the Database Name drop down list under Source Database The version size and
24. ge SQL Server local SQLEXPRESS Database Name audtlog1 O YS Size Used 0 10 MB of 1024000 MB DB size Settings us_engish SQL_Latin _General_CP1_C _AS 1 In the Source Database section click the drop down arrow on the right side of the Database Name field and select an existing Audit Log Database name Figure 43 Merge Audit Log Databases 2 Inthe lower Target Database section use the drop down arrow to select the existing Audit Log Database into which the Source Audit Log Database will be merged Merge Databases x 3 G ick th e Me rge b utto n Please back up your database local SQLEXPRESS Audit Log 1 before performing the merge Backups can be used to restore the current Fusion database in the event the merge process does not complete successfully NOTE This database merge will be halted if HLA Fusion detects a discrepancy in the data or corrupt data in the source database This is to prevent access or reporting errors Do you want to continue with this merge Figure 44 Backup Reminder The HLA Fusion Database Utility displays a reminder that databases should always be backed up before performing a merge 4 Click the Yes button to continue with the merge HLA Fusion x lf the Audit Log Database merge was successful you ll see this e l The databases are merged successfully message Figure 45 Merge Successful HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3
25. he following tasks e Create a new database e Select connect to an existing database e Make a backup copy of your database or create a schedule for regular backups e Restore a database e Detach from and delete a database e Attach to a database e Create or connect to an audit log to record user activity in HLA Fusion Research e Merge databases e Optimize databases e Reconfigure databases e Upgrade an HLA Fusion Research database to the current version e Review the details of your Fusion databases Caution Please back up your database before performing any database utility function HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 1 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Opening the HLA Fusion Database Utility The HLA Fusion Research Database Utility allows you to connect to any SQL Server on your computer or the network depending on your permissions and your organization s security policies To use any of the Fusion Database Utilities you must first connect to a SQL Server With the exception of connecting to a database the database tasks can be executed only on the server or on the computer on which the database resides The following are guidelines for using the Fusion Database Utility e You can connect to the SQL Server using either Windows Authentication or SQL Server Authentication If you use SQL Server Authentication the Server Dialog Box displays the
26. ith Advanced Services 2 Select the database you want to schedule optimization for from the Database Name SES INI iy pe ele Database Name drop down list FUSION 11 29 2011 3 Click the Schedule button Used 0 229 MB d FUSION_30_Restored WD SP3 Build 08 10 2011 AmE E L A Fu sion amp Figure 40 Choosing Database to be scheduled for Database Optimize Job Name FUSION O H Frequency fweekb F 4 Create a new Database Optimization Job Name or Start Time 3 30 00AM select an existing Database Optimization Job ait Date Saturday September 08 2012 Start Date Saturday September 08 2012 Name from the drop down list Day of the week M Monday Mi Tuesday I Wednesday 5 In the next field Schedule Optimize select the Thursday M Friday T Saturday frequency that you want the optimization to run Dieas Daily Weekly or Monthly User Name Esmin 6 In the Optimize Time field use the up and down Password esses e arrows to select a time when the database Schedule Delete Help Close optimization Process will begin Do EAMBDA 00 Figure 41 Selecting Optimization Schedule 7 Inthe Start Date field click the down arrow and choose the first day on which you want the database optimization to run 8 If you selected Weekly in the Schedule Optimize field select the day or days you want the database optimization to run in the Day of the Week section 9 Enter your User Name and Password
27. ot deleted 5 If you click No a message verifying that the database was not deleted is displayed Click the OK button to exit Figure 13 Database Not Deleted HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 8 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Attaching to a Database You may use the Attach and Detach Database options together when you want to move a database to another location and then link to that new location Here is the sequence to follow if you want to do this e Detach the database see Detaching a Database for more information e Move the database mdf file which contains the database to the desired location on another server e Attach the database using the steps below to specify the new location of the moved database You can use Attach database to link to any Fusion database mdf file However the database mdf file you are attaching must reside on the selected server Note It is recommended that you back up the database before using the Attach feature 1 Within the Database Utility window click Attach Database Attach Database SQL Server SQL Server local MSQLEXPARESS zal MDF fieto tech ed Figure 14 Attach a Database Please secicct database file to attach Zh 2 Click the Browse button next to the MDF file to attach field and locate the database file you want to attach to Fusion i New Fusion D
28. p Name Note The drop down list for backup jobs may display more tasks than Fusion tasks so be careful to select only the Fusion database backup task you wish to delete 3 Click the Delete button You are asked to confirm the deletion of the task Figure 26 Confirm Task Deletion E This database backup job FUSION 30 deleted successfully 4 Click the Yes button to delete the scheduled backup If your scheduling has deleted the following message is displayed Click the OK button to return to the main Database Utility Figure 27 Scheduled Backup Task Deleted Screen To create a new backup task follow the steps for Scheduling a Backup in the prior section HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 16 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Restoring a Database You can use database backups to restore replace a database The backup database copy contains all HLA Fusion data up through the date of the backup creation You can restore a database backup to any existing or new database except for the current database If you wish to restore a database backup for the current database use the Merge Database feature Restoring a database can only be performed on the server or the computer where the backup database file resides 1 Within the Database Utility window click Restore Database Restore Database SOL Server SQL Server locall
29. se cccccccccssssccecccesseeeeecseeseceeecseeseeeeeseesseeeeeeeaaseeeesseaaeeeeesseaseeessssageeeees 21 Opt mizing FUSION Database si ccesssccecetstconcdnasenecssatbveccearoesdedsveeaceveteueds tedcqevdsacecotsienecontneyecesdtecdcertsereeaensecedes 23 Scheduling Database Optimization cccccccccccccssseceeceeeseeeeeceeeeceeesaeaauceesseaaeceeesseaseceessseaeeeesssaageeeeessaagess 25 FeCOMMNGUGING 2 FUSION DATA ASS asengar TE 26 Merging an Audit Log Database ccecccccccsseeecceeceeeeeceeeeaaeeeeeeeeeeaseeeeesseaeeceeesaeaeeeessaeaeeeeeesaeaseeeessaaseeeneneaas 27 Current Database Details riicesescecctacvenwetsaceactivccus nosenee nondsweddanen ccnibaroxetnceuaediendecub ascneceevnenexsbesewndshceegbnonesectnes 28 DAEA O eare aee EE E E E A 29 Upgrade Prior Database Versions to HLA Fusion Database 3 0 ccccccseececeseeeteseeeceseeeeeseeteeseeteneeetsneeens 29 HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 lil One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide HLA Fusion Database Utility With the HLA Fusion Research Database Utility you can access and select a SQL Server database from any location within your system network connected to your computer provided the database configuration has been set up for remote access The HLA Fusion Research Database Utility allows you to create and connect to SQL Server databases as well as perform all of t
30. settings for that database are displayed 3 Select a database from the Y Database Name drop down list Source Database SQL Server under Target Database The Database Name New Fusion Database F version size and settings for that Version 3 0 0 13925 Created on 11 7 2011 database are displayed You must Size Used 0 10 MB of unlimited DB size look at the version size and T arget SOL Server m verify the version and settings Ir Database Name Version Audit Log Settings U4s_english SQL_Latin _ General CP1_CI_AS SQL 2005 Express Edition with Advanced Services settings of both the source and target database before merging to match and that the size of the call ene source database is not too large fa OBUtL restore for the target Settings FUSION FUSION 2 Oa ae FUSION 30 101011 Figure 32 Select Database Names for Merge HF MAN v3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 19 One Lambda Inc HLA Fusion Research Version 3 0 Database Utility Guide Note HLA Fusion checks the MesfEquivalent and MesfNormal columns in the well data table for NaN or infinity values and replaces these with a null or empty space These columns have been found to contain inconsistent data in earlier versions of One Lambda software Occasionally a database merge may fail due to an incompatibility of collation data handling rules established when the database is cr
31. sion eeeeee E Database Tasks Optimize Database Create Fusion Database ial sais Select Connect to Fusion Database SOL Server pani aa SQL Server local SQLEXPRESS A E r lish SQL_Latin _General_CP1_Cl_AS 2 S e e ct t h e d at a b as e yo u wa nt to rear ene i SOL 2005 E xpress Edition ah aede ervices ACKU alabase optimize from the Database Name eames ae erge Database atabase Create Select Audit Log Database Database Name ba drop down Hi Optimize Database Reconfigure Database Merge Audit Log database Current Database Details Data Migration Upgrade prior versions of HLA Fusion database to 3 0 User Name sa Server Name local SQLEXPRESS Database Name FUSION 3 0 Database Mode Server Standalone Figure 38 Select Database to Optimize Optimize Database SQL Server SQL Server local SQLEXPRESS Settings us_english SQL_Latin _General_CP1_CI_AS SQL 2005 Express Edition with Advanced Services Database Database Name SIEGE RG Used 0 229 MB of unlimited DB size Step 2 of 3 Reindex Table WELL_DETAIL HBSSEGRORRRRRRERRE Ee 3 Click the Optimize button Figure 39 Database Being Optimized When the database optimization is completed you ll see a message indicating that the process was completed successfully Note that during optimization SQL Server will temporarily require additional hard drive space to compl
32. sions to HLA Fusion Database 3 0 You can use this tool to upgrade a database created with a previous version of HLA Fusion to HLA Fusion version 3 0 1 Within the Database Utility window select Data Migration and click Upgrade prior versions to HLA Fusion database 3 0 Upgrade HLA Fusion Database SOL Server SQL Server flocal SQLEXPRESS Database Database Name Version Size Used 20 100 MB of 512 MB DE size Settings us_english SQL_Latin General CP1_ CAS SOL 2005 Express Edition with Advanced Services Backup original database before upgrade Backup Path C Qocuments and Settings All Users4pplication Data OneLamb Figure 47 Upgrade Fusion Database 2 Select your SQL Server instance by accepting the default or by clicking the browse button lel on the right side of the SQL Server field 3 From the Database Name drop down list select the Fusion database you want to upgrade 4 If you want to back up the database before it is upgraded click the Browse Button l and select a location for the backup This location will appear as the Backup Path 5 Place a check mark in the box next to Backup original database before upgrade 6 Click the Upgrade button This makes a backup of your original database and upgrades it to the most current HLA Fusion format HF MAN Vv3 x x EN 01 Rev 0 HLA Fusion Research Database Utility Guide v3_0 29 One Lambda Inc HLA Fusion Research Version 3 0 Dat

Fusion Research Database Utility User Manual v3_0

Contents

Download Pdf Manuals

Related Search

Related Contents