Click here to expand

    Moving the EventLog Analyzer MSSQL Database to a Different Directory in the Same Server

    This procedure is applicable for EventLog Analyzer version 8.0 (Build 8010) onwards.

    How to find the build number?

    In the EventLog Analyzer web client, click "?" on the top right corner of the screen and click on About. You will find the build number mentioned below the build version.

    This is the build number of the currently installed EventLog Analyzer.

    Moving the EventLog Analyzer MSSQL Database to a Different Directory in the Same Server

    Moving the EventLog Analyzer MS SQL database

    1. Stop the EventLog Analyzer Server/Service.
    2. Login to SQL Server database with system administrator permissions.
    3. Find the current location of the data file and log file for the database named 'eventlog' by using the following commands:
    4. Copy to Clipboard

      use eventlog

      go

      sp_helpfile

      go

    5. Detach the database by entering the following commands:
    6. Copy to Clipboard

      use master

      go

      sp_detach_db 'eventlog'

      go

    7. Copy the data file and the log file from the current location (<MSSQL Home>\DATA\eventlog.mdf and <MSSQL Home>\DATA\eventlog_log.ldf) to the new location (<New location>\eventlog.mdf and <New Location>\eventlog_log.ldf).
    8. Re-attach the database and point to the new location by using the following commands:
    9. Copy to Clipboard

      use master

      go

      sp_attach_db 'eventlog' , '<New Location>eventlog.mdf' , '<New Location>eventlog_log.ldf'

      go

    10. Verify the changed location by using the following commands:
    11. Copy to Clipboard

      use eventlog

      go

      sp_helpfile

      go

    12. Start the Eventlog Analyzer Server/Service.

    Don't see what you're looking for?

    •  

      Visit our community

      Post your questions in the forum.

       
    •  

      Request additional resources

      Send us your requirements.

       
    •  

      Need implementation assistance?

      Try onboarding

       
    Get download link