Fusion Database Utility User Manual.book
Contents
1. Destination E OLI 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 NDB Backups HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 12 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual This brings up a new window where you can browse to select a destination folder for the database backup Browse For Folder Please select Destination Directory OLI FUSION E C3 data AppData catalog O export O NMDPExport C report Fl session temp 73 rpt Make New Folder OK Cancel AL Figure 21 Select Backup Location 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 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 To perform a backup of the database immediately click2. ONE LAMBDA Advancing Transplant Diagnostics Database Utility User Manual HLA Fusion Software Version 3 X X Catalog FUSPGR One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual 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 software release Therefore you may notice slight differences in the content of the actual application screens For In Vitro Diagnostic Use 21001 Kittridge Street Canoga Park CA 91303 2801 Tel 818 702 0042 Fax 818 702 6904 www onelambda com LABType LABScreen and FlowPRAQO 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 registered tradem
3. Scheduling Database Optimization cc cc cecccccssscceecesseeeceesececeeeceeceuseeeceeseceeeegecseeenseeeceegeseesegeesenensesensegeeeeeas 25 Reconfiguring a FUSION Database cccccccccccccsesseceeccseseeceeeceeseeeeceeeseeeessaaaseeeeseaaseceeessaaseeeesssaseeeessaageeeeees 26 Merging a Audit Log Dads ciuis t deseen ee trn ates Deb mui ahud dene iae A a Ei r EAEE aR ERDERA 27 Current Database Dela lls HT 28 LAN EL NNN ANON atresia ctxt aise ye cmc sine dace 29 Upgrade Prior Database Versions to HLA Fusion Database 3 0 ccceccccsecceceeeeeceeeeesecesseeeeseeeeesaaeeesaaees 29 HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X iii One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual HLA Fusion Database Utility With the HLA Fusion Database Utility you can access and select a SOL 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 Database Utility allows you to create and connect to SOL Server databases as well as perform all of the following tasks Caution Create a new database Select connect to an existing database Make a backup copy of your database or create a schedule for regular backups Restore a database Detach from and delete a database Attach to a da
4. us_english SQL_Latin _General_CP1_CIAS displayed You must look at SOL 2005 Express Edition with Advanced Services the version size and settings m of both the source and target ea rer cer pe Pe Database Mame Version Audit Log 0 a Ud source database is not too verify the version and settings match and that the size of the DBLltl restore Settings FUSION large for the target FUSION 2 Oa FUSION 2 0 sp FUSION 30 101011 Figure 32 Select Database Names for Merge HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 19 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual 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 created between the source and target databases For more information please refer to http support microsoft com kb 325335 4 Click the Merge button x s After the Merge is completed the following message is A The databases are merged successfully displayed Figure 33 Merge Completed 5 Click the OK button to return to the main Database Utility Screen H
5. 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 SQL Fusion Database SQL Server Instance Name local SQLEXPRESS SOL Version 2008 Express Edition with Advanced Services 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 Primary 1024000 MB Well Detail 1024000 MB Well Result 1024000 MB Log 1024000 MB Used 10 MB 10 MB 10 MB 28 MB approx 0 0 0 0 SQL SQL Audit Log Database Server Instance Name local SBLEXPRESS SOL Version 2005 Express Edition with Advanced Services 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 HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 28 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual Data Migration Upgrade Prior Database Versions to HLA Fusion Database 3 0 You can use this tool to upgrade a database created with a previous v
6. the optimization job is set to begin HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 25 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual 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 Database Tasks in the Fusion SQL Server Database Utility HL Server lacalSLEXPRESS Settings us_english SQL_Latin _General_CP1_ClAS SQL 2005 Express Edition with Advanced Services 2 Ensure that you re connected to the correct SQL Server Database Database Mame AMEEN File Size GB L Unlimited 1 000 0 3 Ifnot click the Browse Button in the SQL Server section to select the correct SQL Server Database Wersion 3 0 0 13925 Created on 1271 72011 Used 0 10 MB of 1024000 MB DB size 4 Choosethe database that your want to reconfigure by clicking the down arrow at Figure 42 Reconfigure a Database the right side of the Database Name field to select it a Increase the size of the datab
7. v3 X X 8 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual 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 SOL Server SUL Server lacal S HEERPRESS ls Mr eosen M9 amhas CSD 21x 2 Click the Browse button Lz next to the MDF ES file to attach field and locate the database file Rm is Mom oe you want to attach to Fusion T EC 3 Select the database mdf file and click the Open button The selected mdf file displays in the MDF file to attach field Cancel Figure 15 Choose Database to Attach HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 9 One Lambda
8. Confirm Task Deletion Sti 4 Click the Yes button to delete the This database backup job FUSION 30 deleted successfully scheduled backup If your scheduling has deleted the following message is displayed Click the OK button to return to the main Database Utility Screen Figure 27 Scheduled Backup Task Deleted To create a new backup task follow the steps for Scheduling a Backup in the prior section HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 16 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual 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 local S QLEXPRESS m Database File To Restore SOLI FUSION datastemp FUSION 30 bak m 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 2 xi Look
9. Inc HLA Fusion Software Version 3 X X Database Utility User Manual Enter a name for the database in the Attach as field MDF file to attach C Pragram Files Microsoft SQL Server S SUL m Attach as 4 Clickthe Attach button 5 Figure 16 Attach to the Database HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 10 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual 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 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 gm mH SQL Server 1 Within the Database Utility window SPL Ber lal dick Detach Database Database Ed 5 5 5 KL Figure 17 Detach a Database Detach Database SQL Server SOL Sever 2 Fromthe Database Name drop Database Database Name 0 H down list select a database and click the Detach button The following message is displayed Figure 18 Select Database to Detach Database Detach x 3 Click the OK button 3 Database successfully detached File datatched c Program Files Microsoft SOL Serve
10. LAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 20 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual 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 SHLERPRESS Settings us english SL Latin aeneral CP UI AS SOL 2005 Express Edition with Advanced Services Database Database Mame File Size GB Unlimited 1000 0 Used 2x 10 MB of 512 MB DB size Figure 34 Create Select Audit Log Database 2 Dooneofthe following e Select a database from the Database Name drop down list and click Set Or enteraunique 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 X j Database Audit Log 1 successfully created Do you want bo connect to it D e Figure 35 Audit Log Creation Confirmation 3 Ifyou 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 HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 21 One Lambda Inc HLA Fusion Soft
11. SION New FUSION UAT WDO SP3 Build 08 10 2011 15 x H LA Fu S On e Figure 40 Choosing Database to be scheduled for Optimization Database Optimize Job Name FUSIONS o e Frequency weeky E Start Time 3 30 00AM Stat Date Saturday September 08 2012 v 4 Create anew Database Optimization J ob Day of the week Name or select an existing Database I MR Optimization J ob Name from the drop Thursday M Friday Saturday down list Sunday 5 Inthenext field Schedule Optimize select User Name Bsh the frequency that you want the optimization to mm run Daily Weekly or Monthly Schedule Delete Help Close brc ELAMBDA NM E 6 Inthe Optimize Time field use the up and down arrows to select a time when the database optimization process will begin Figure 41 Selecting Optimization Schedule 7 IntheStart Date field click the down arrow and choose the first day on which you want the database optimization to run 8 Ifyou 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 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
12. abase Switch connection bo other Fusion database Attach Detach Fusion database Backup Hestare Fusion database Merge Fusion database Message Please note that same database functions such as Create Delete Backup Restore Migration Attach Detach etc requires administrator level privilege Please see your systems administrator if you need to perform these actions The maximum allowed database name is 35 characters Status Bar __ gt User Name sa Server Name I loca S OGLEXPRESS 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 HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual 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
13. ark 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 Database Utility User Manual v3 X X li One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual Table of Contents Opening the HLA Fusion Database Utility lsseeeelsssesssssesssseseesseeeennnnnenn nennen nnnm nnn nnns 2 HAT aS MOIS ETT EE 4 Creating a New DataDaSQuciestivectecidvneniiumrkbex qute bnkh duns esta tn ix bxvekbev esi nad bvesbritaskupRi EV erxi DF EM EnEn errr eps rsta iK Rs 4 Selecting and Connecting to a Database ssssesssssssssssssseseee eene nnne nennen nnn nnn n narrans 6 Attaching to a MB i219 7 c1 TRITT DOT E m 9 Deta hing fom a Database NE TI E mE E E E T 11 Creating a Database Backup File lssseseesssssesseesssssesee eene nennen nnne nnn annes nan nnns nna nnn nnn 12 Deleting a Scheduled BACKUP ccccccesccecesecceceesceeceesececeenseeeceesececeeecseeeaseseceeneeeeeeneceeneusesetsegeeetsegseeeeneess 16 Rest ring DAlaAD ASS RR EEU 17 NS OGD AA cii RE 19 Create Select an Audit Log Database ccccccccccseeecceeeseeeeeeeecaaeeeeeeessaaseceeesaaaeeeesesseaeeeeesseaseeeessaeeeeeeesaaess 21 COoamizinig a FUSIOI AUS ocala cette asec pios ego ese ed eee su abe 23
14. ase 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 HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 26 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual Merging an Audit Log Database If 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 Merge Log Database Source Database The Merge Audit Log feature of the Fusion Database SQL Server local SQLEXPRESS Te TP SN cx 3 Utility is divided into two sections The top part or atabase Name udit Log v Size Used 2 10 MB of 512 MB DB size Source Audit Log Database can be merged into the Settings us english SQL Latini General CP1 Cl AS Target Audit Log Database at the bottom m Target SQL Server local SOLEX PRESS cocco EE E 1 Inthe Source Database section click the drop Size Used 0 10 MB of 1024000 MB DB s
15. base Utility User Manual v3 X X 4 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual HLA Fusion X Provided the newly created database name xd does not already exist the system creates the J Database FUSION _1 successfully created Da you want to connect to it new database and displays the following message ow If the newly created database name already exists the Database Utility displays the following error message Te Note HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X Figure 3 Database Created Confirmation 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 ace Database Connection ue Click the OK button J Database connected successfully Figure 4 Successful Connection x d wh ing the database Database already exists Click the OK button Then 6 irali irk ele Ed edie Cas s Authentication and database name verify that the database name you entered is unique to the selected SOL Server and Figure 5 Database Creation error retry 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 maximum length of a database name must not exceed 35 characters One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual Se
16. d migration A collation encodes the rules governing the use of characters and numbers for a language or an alphabet Please do not alter the permissions i e who has the right to make certain changes to the database 1 Double dick the Database Utility icon on your computer desktop The Connect to SQL Server dialog box is displayed As Connect To SQL Server 5 x HLA Fusion SOL Server SQL Server ETIN 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 E VOR ELAMBDA 9 99 The Database Utility Main Window is displayed HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 2 One Lambda Inc Database Utility E HLA Fusion O Database Tasks v Create Fusion Database Select Connect to Fusion Database Delete Database Attach Database Detach Database Backup Database Restore Database Merge Database Create Select Audit Log Database Optimize Database Reconfigure Database Merge Audit Lag database i Current Database Details El 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 Software Version 3 X X Database Utility User Manual IO xi Create new Fusion dat
17. e prin Merge Database m Database Database Name dn Op down Create Select Audit Log Database Database Name ptimize Database Reconfigure Database Merge Audit Log database Current Database Details Data Migration Upgrade prior versions of HLA Fusion database to 3 0 FUSION 2 0 a 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 Latini General CP1 CI AS S L 2005 Express Edition with amp dvanced Services 3 Click the Optimize button Database Database Name SEEIDITEBBSEBEZBEUE 29 20 v Used 0 229 MB of unlimited DB size Step 2 of 3 Reindex Table WELL DETAIL EBHEBHHHHBEHEEHBESZEBSBEBH 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 SOL 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 SOL Express during optimization the process may fail HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 23 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility U
18. ersion 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 SOL Server lacalSHLE PRES5S Database Database Name EE Version Size Used 20 100 MB of 512 MB DB size settings us englich SQL_ Latin General CP1_ Cl AS SOL 2005 Express Edition with Advanced Services v Backup orginal database before upgrade Backup Path E Dacuments and SettingssAll LIserssspplicatian Dr atas neL amb m Figure 47 Upgrade Fusion Database 2 Select your SOL Server instance by accepting the default or by clicking the browse button l on the right side of the SQL Server field From the Database Name drop down list select the Fusion database you want to upgrade 4 Ifyou want to back up the database before it is upgraded click the Browse Button le and select a location for the backup This location will appear as the Backup Path 5 Placea check mark in the box next to Backup original database before upgrade Click the Upgrade button This makes a backup of your original database and upgrades it to the most current HLA Fusion format HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 29 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual Note that during the database upgrade SQL Server will temporarily req
19. 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 SGLEXPRESS kan Browse Button Settings us english amp sHL Latin General CP1 CLAS SUL 2005 Express Edition with Advanced Services Database D atabase Mame FUSION at Database Name field File Size GB 1 00002 Unlimited Fusion will create 4 files each with the size specified above Figure 2 Create Fusion Database Screen N Make sure the SQL Server is the correct one for the database you want to create Oo Enter a unique Name for the new database m 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 database Different collations use different comparison rules for data handling which can cause a conflict during database merges HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Data
20. in Ote HJA oenm 3 Browse to select the database R FUSION_30 bak backup file will have a bak Documents extension to restore and click the Open button Desktop My Documents My Computer LY Nm Filename FUSION 30 gt Places Files of type Backup Files bak Cancel 7 Figure 29 Select Database Backup File HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 17 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual Restore Database SOL Server SQL Server localMSOLEXPRESS lissa Database File To Restore CAOL FUSION datastemp FUSION 30 bak Restore as FUSION 3 Figure 30 Enter Database Restore Name 4 Enteraunique name for the restored database in the Restore as field 5 Click the Restore button and the x following message is displayed e v 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 from a network drive or from a backup file on your computer desktop HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 18 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual Merging Databases This function allows you to combine two databases into one regardless of their l
21. ity 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 SOLEXPRESS m Database Database Mame 2 From the Database Name drop down list select a database and click the Delete button The following prompt is displayed Figure 9 Select Database to Delete Note If you receive a message that the selected database is busy please try this action again in a few minutes You cannot delete an attached database Delete Database SOL Server SQL Server locall SOLEXPRESS m Database Database Mame 3 Click the Delete button HLA Fusion X j Delete this database 4 The following confirmation message is displayed Click the E Yes button to continue with the database deletion Figure 10 Delete Database Figure 11 Delete Confirmation HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 7 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual x 1 Database successfully deleted The Database Utility confirms the deletion Figure 12 Database Deleted HLA Fusion E xj 5 If you click No a message verifying that the database was not deleted is displayed Click the OK button to exit LD DS ODONIS ES Figure 13 Database Not Deleted HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual
22. ize Settings ux engishNSQL Latii General CPI CL AS down arrow on the right side of the Database Name field and select an existing Audit Log Database nsma Figure 43 Merge Audit Log Databases 2 Inthelower 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 Click the Merge 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 button 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 w 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 If the Audit Log Database merge was successful you ll see this i r T The databases are merged successfully message Figure 45 Merge Successful HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 27 One Lambda Inc Current Database Details HLA Fusion Software Version 3 X X Database Utility User Manual selecting Current Database Details from the menu
23. k 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 e 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 e Click the Schedule button Note You are not required to have HLA Fusion running or be logged in to run the scheduled backup task However you must have your computer on during the backup period HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 14 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual If your scheduling is confirmed the following message is displayed and you should dick OK HLA Fusion Database backup scheulde X The database backup job FUSION 30 scheduled successfuly to run an a Weekl
24. lecting 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 Inthe Database Utility window click the SQL Server Select Connect to Fusion Database SQL Sever m option Settings u3 englisP SHL Latinl 3eneral CP1 CI AS SQL 2005 Express Edition with Advanced Services Database Database Name FUSION_20 i 2 From the Database Name drop down list select a database The database version creation date Database Version 3 0 0 13925 Created on 8 8 2012 percentage used as well as current Used 0 179 MB of 1024000 MB DB size and maximum sizes of the selected database are displayed below Figure 6 Select Database 2 3 Click the Set button The following message is v Database connected successfully 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 local SOLEXPRESS Database Name FUSION 30 Database Mode I Server Standalone Figure 8 Utility Status Bar HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual Deleting a Database From the Database Util
25. ocation There are certain guidelines to follow when merging databases Both databases must be the same version of an HLA Fusion 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 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 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 settings for that database are displayed Merge Database 3 Select a database from the ucl C SY Database Name drop down aS oss al list under Target Database Database M ame New Fusion Database I7 The Version size and settings Mem n Dur E z y d for that database are Ze SEO U OF une SIZE Settings
26. r MS5Q0L 1155 QLIDATAYFUSIOM 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 HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 11 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual 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 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 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 SQL Server locall SOLEXPRESS Database Database Mame
27. ser Manual Here are a few suggestions to solve this problem 1 Reducethe 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 SOL 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 HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 24 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual 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 Optimize Database list of database tasks in the Fusion SOL Server Database Utility SQL Server locallSQLE PRESS Settings us english SL Latin General CF1 LI amp 5 5 GIL 2005 Express Edition with Advanced Services 2 Select the database you want to schedule optimization for from the Database Database Name AREN RET Name drop down list FUSION 11 29 2011 FUSION 2 0 4 FUSION 2 0 sp3 3 Click the Schedule button FUSION 30 101011 Used 0 229 MB FUSION 30_Restored FU
28. tabase Create or connect to an audit log to record user activity in HLA Fusion Merge databases Optimize databases Reconfigure databases Upgrade an HLA Fusion database to the current version Review the details of your Fusion databases Please back up your database before performing any database utility function HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 1 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual Openingthe HLA Fusion Database Utility The HLA Fusion 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 SOL 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 SOL Server using either Windows Authentication or SQL Server Authentication If you use SQL Server Authentication the Server Dialog Box displays the default database administrator user name and password for a local client server installation e tis highly recommended that you do not switch collation and regional settings between databases The collation of databases and the SOL Server play a major role during database merge an
29. the Backup button The following message confirms a successful database backup Backup Database X e i J Database FLISIOM 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 HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 13 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual HLA Fusion Database Backup Scheduler Ioj x LJ HLA Fusion e Database Backup Job Name FUsiON 30 ai A unique name for the backup job Schedule Backup weekly Lx How often the backup will run Backup Time 3 30 00 AM E Time of day the backup will begin stat Date Friday June 15 2012 First day the backup job will run T XGNE LAMBDA 00 Day of the week M Monday Tuesday Iv Wednesday L Thursday Iv Friday a Saturday ris unday User M ame i LAMBDASIThaomas Password esee asl Schedule Delete Help Close Figure 23 Database Backup Scheduler e Complete the fields in the Database Scheduler to set the backup day and time Database Backup J ob Name Enter a unique name for the backup Each scheduled backup tas
30. uire 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 SOL Express during the upgrade the process may fail Here are a few suggestions to solve this problem 1 Reducethe 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 SOL 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 HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 30
31. ware Version 3 X X Database Utility User Manual Log Database Connection X 1 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 HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 22 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual 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 f HLA Fusion 000000 Database Tasks Create Fusion Database Select Connect to Fusion Database m SQL Server Delte Database SQL Server local NSGLEXPRESS 2 Select the database you want Atach Database p Detach Database ettings Ws englis Latin Beneral LFT LI As E Backun Databas SQL 2005 Express Edition with Advanced Services ckup Database to optimize from th
32. y 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 HLAF MAN v3 x x EN 01 Rev 0 HLA Fusion Database Utility User Manual v3 X X 15 One Lambda Inc HLA Fusion Software Version 3 X X Database Utility User Manual 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 HLA Fusion Database Backup Job Name Fusion amp utolpdate IVD Reall paradeS cheduledT ask5 1 5 NOR DETEEETSYSISERE 2 Usethe drop down arrow in the Database Stat Date Pealpsrade ogonT askS 1 521 3 Backup J ob Name field to select a scheduled Day ofthe week ReaUpradeLoment ads 1521 3 backup task to delete Monday T Tuesday T Wednesday Frequency Thursday I Friday T Saturday Sunday User Name Bsmith Password leeeeeee _ Schedule Delete Hep c Note The drop down list for backup jobs may display ED bonis SME more tasks than Fusion tasks so be careful to select only Figure 25 Select Create Backup Name the Fusion database backup task you wish to delete HLA Fusion Database Backup Scheduler X 3 Click the Delete button You are asked to confirm AN eret e REM the deletion of the task Yes Ma Figure 26
Download Pdf Manuals
Related Search