Management Console: How do I migrate from SQL Express to SQL Server?

Document created by drossler Employee on May 9, 2017Last modified by jyamada on Jul 14, 2017
Version 5Show Document
  • View in full screen mode


 

  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 on the left
  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