Attach MDF and LDF files to SQL Server Management Studio

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!

    • Related Articles

    • Restore SOHODOX DBs using SQL Server Management Studio

      To restore the DBs using SQL Server Management Studio follow the steps below: Open 'SQL Server 2014 (or any) Management Studio'. On the 'Connect to Server' window, change 'Authentication' to 'SQL Server Authentication'. Please enter your MS SQL ...

    • Backup SOHODOX DBs using SQL Server Management Studio

      To backup the DBs using SQL Server Management Studio follow the steps below: Open 'SQL Server 2014 (or any) Management Studio'. On the 'Connect to Server' window, change 'Authentication' to 'SQL Server Authentication' Please enter your MS SQL ...

    • Convert your existing SQL Express Sohodox DB to SQL Server Standard/Enterprise Sohodox DB

      Note: The below instructions will only work if… You have an existing installation of SQL Server Standard or Enterprise (if you are unsure, drop an email to support@sohodox.com) You have purchased the SQL Server upgrade module. You have the new ...

    • Configure Sohodox to point to an existing SQL Server DB

      To to this... Press the Windows + R button. The Run dialog will be launched. In the Open: textbox, type the following command… "C:\Program Files (x86)\Sohodox Desktop\Sohodox.exe" /reconfiguremssqlmainDB /dbname=MainDB_sdx (Assuming Sohodox is ...

    • SQL: 001 : SQL Server does not exist or access denied

      Error Message: ErrorCode: 61443 Message: Failed to connect to database 'MainDB_sdx'. (ErrNo:-2147467259 Details:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.) Cause: The error indicates that SOHODOX is unable to ...