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

    How to Downgrade from SQL Server Enterprise Edition to Standard Edition

    Issue
    How to Downgrade from SQL Server Enterprise Edition to Standard Edition

    Product Line
    SQL Server 2012, SQL Server 2014 and SQL Server 2008 R2
    Power Monitoring Expert (PME) 7.2.x
    Power Monitoring Expert (PME) 8.x

    Environment
    Microsoft SQL Server

    Cause
    SQL Server that was installed is Enterprise Edition. Enterprise Edition features are not required plus don't want to pay for the additional licensing. Need to downgrade to SQL Standard Edition.

    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.* 

    1) Create Database Backups of ION_Data, ION_Network, ApplicationModules.
    2) Check the current version of SQL and build number. To view this information launch SQL Management Studio and execute the following command: SELECT @@Version
    3) Execute the following script in new query to determine location of database files:

           SELECT name, physical_name AS current_file_location
           FROM sys.master_files

     
    4) Create copies (mdf and ldf files) of the system database master, model and msdb. The location of these files can be obtained from the previous step. To make copies of the files, Shutdown the SQL Server service and copy the files to another location as these will be used later.
    5) Uninstall SQL Server from Control Panel the following components:
        - SQL Instance
        - SQL Server Integrations Services
        - SQL Server Analysis Service
        - SQL Reporting Services
        - SQL Data Tools if installed
    6) SQL Server Management Studio, Client Tools and Connectivity do not require to be uninstalled as they are Shared Components.
    7) Reboot the server after uninstall is complete. When server comes back after the reboot navigate to the SQL database file location found in step 3 and confirm the system databases do not exist. The copies made in step 4 will be used once we have installed SQL Standard Edition.
    8) Install SQL Standard Edition making sure the Instance name remains the same and the Data directories point to the same location as in step 3.
    9) When SQL Server is installed, open SQL Management Studio and confirm the new installed instance version using command in step 3.
    10) If there are any patches to be applied to the SQL server then complete before continuing.
    11) Shutdown the SQL Service and copy the System Database from step 4 to the correct location and replace the files created by the new installation.
    12) Start SQL Service and verify PME operation.

     

    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