Discover our Clipsal Smart Home packages as seen on The Block 2018

in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    Splitting out the Transaction Log and Database Files in ION_DATA Database

    Issue
    It's a common practice to split out the mdf and the ldf files associated with the ION_Data database to improve performance and increase reliability 

    Cause 
    The database files and the log files have a different I/O patterns because transaction logs are typically sequential writes while data files are mostly random reads and writes. Separating the mdf and the ldf files on different physical drives will reduce I/O contention and hence improve performance. Moreover, placing the files on different locations but on the same physical drive will exhibit no performance gain.  It should also be noted that the PME installer only prompts for a single locaiton where both the ldf and mdf files will be deployed initially, so the steps below would be taken post install.

    Product Line
    PME 7.x / PME 8.x

    Environment
    SQL Server Management studio

    Resolution
    *Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*

    This article discusses the two methods that can be utilized to move and separate the database files.  Both of these methods will achieve the same end result if the following steps are correctly executed:

    1) The detach/reattach method:
    • Stop all the ION services from the services ( Stopping the ION Network Router service first will stop several other services at once)
    • Launch the Microsoft SQL Server management Studio and connect to the Sql server
    • Expand the databases tree, right click on the ION_Data database and then detach database as show below
        ​                             
     
    •  Move ION_Data.MDF and the ION_Data.LDF files to their prospective new location. It's advisable to copy and paste the files instead of cutting and pasting. Once the files have been successfully transferred, you can delete the files from the old location.
    • Attach the MDF file as shown below and then change the current file path of the ldf file to match your new location.
                                                                   
     
    • Execute the following SQL script to verify the new location.
                                                                   
     
    •  Restart the ION services and verify that PME's components are functioning
    2) The online/offline method
    • Stop all the ION services from the services ( Stopping the ION Network Router service first will stop several other services at once)
    • Launch the Microsoft SQL Server management Studio and connect to the Sql server
    • Set the ION_DATA database offline by running the following SQL script
                                                                  
     
    • Move ION_Data.MDF and the ION_Data.LDF files to their prospective new location
    • Execute the following script be careful with the NAME as it is case sensitive; ION_Data_Data for the mdf file and ION_Data_Log for the LDF file. The FILENAME should correspond to your new location path.
                                                   
     
    • Set the ION_DATA base online and then check for integrity by running the following scripts
                                                   
                                                  
     
    • Execute the following SQL script to verify the new location and restart the ION services
                                                       
    The SQL scripts are attached in a .txt file

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance