Migrate Management Console from SQL Express to SQL Server

Document created by drossler Employee on May 9, 2017Last modified by jyamada on Jan 23, 2019
Version 7Show Document
  • View in full screen mode


 

SQL Express to SQL Server migration

  1. Click Start > All Programs > Malwarebytes Management Server > Data Backup and Restoration.
    Note: Malwarebytes Management Server may be listed as Malwarebytes Enterprise Edition on older versions.

  2. Create a new backup of the database on your Management Server.

  3. Copy the backup folder to your SQL Server.

  4. Inside the backup folder, locate the SCDB.mdf and .ldf files.

  5. Copy these files to the folder C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA
    Note: This folder may vary depending on your installation path.

  6. On the new SQL Server, log in to SQL Management Studio.

  7. Attach the SCDB.MDF file.

  8. Once attached, rename the database from C:\Program Files... to SCDB.

  9. On your existing Management Server, log in to the Management Console.

  10. Click the Admin Pane.

  11. On the Overview tab, under SQL Database Setting, click Change.

  12. Enter the address, instance name, and user information (sysadmin role preferred) for the SQL server.

  13. The Management Console should disconnect, and then you should be able to log in again.

Attachments

    Outcomes