Attach MDF and LDF files to SQL Server Management Studio

            If you are using SQL Express Edition, please download the SQL Server Management Studio from the link below...

             Please download the file 'MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe' (For a 64 bit version of Windows)

             1. Attaching MDF and LDF files to SQL Server....

             Each SOHODOX DB will have 4 files. Lets assume you want to attach the MainDB_sdx. You should have the following files...

            • MainDB_sdx.mdf
            • MainDB_sdx_log.ldf
            • MainDB_sdx_cache.mdf
            • MainDB_sdx_cache_log.ldf

            These files are usually located and need to be placed in the 'C:\Program Files\Microsoft SQL Server\MSSQL12.(Your Instance Name)\MSSQL\DATA' folder.

            To attach the MDF and LDF File...
            1. Open SQL Server Management Studio. Connect to the server using the SQL credentials. (Make sure you login with SQL Server Authentication)
            2. Go to object explorer of the database engine instance. Right click on the Databases node and select Attach option.
            3. The Attach databases dialog will appear.
            4. Click on Add button.
            5. Select the .mdf file and click on OK Button. The below section will show the related mdf and ldf file details.
            6. Click the OK button.

            Once done, you will need to point SOHODOX to the SQL DB...

             Please open the command prompt and run the command below...

            "C:\Program Files (x86)\Sohodox Desktop\Sohodox.exe" /reconfiguremssqlmaindb /dbname=MainDB_sdx

            In the dialog which pops up, specify the SQL Server location and login credentials for the new installation.

            Now open Sohodox again.

            The DB will open.

            That's it!

            Updated: 03 Mar 2019 03:29 PM
            Help us to make this article better
            0 0