Jump to content

Move SQL Database


Recommended Posts

Hello, I got the server console set up currently in SQL express, however I would like to move it out and put it in our instance with the full blown version of SQL.  How can I do that?  I know how to detach and re-attach the database  but can't seem to get the console to know that the database has moved connections.

Link to post
Share on other sites

Hi!

 

Here are the steps for migrating from SQL Express to a full Database:

 

    1. Navigate to C:\Program Files (x86)\Malwarebytes Enterprise Edition\App_Data
      1. "Malwarebytes Enterprise Edition" may be "Malwarebytes Management Server."
    2. Copy (not move) the files "scdb" and "scdb_log" and place in their new location where they will be read by the new server.
      1. It is very important to COPY the database
    3. Attach the files to the new SQL Database.
    4. Log in to the Management Console.
    5. Go to the Admin Pane > Overview tab and click on "Change" under "SQL Database Setting"
    6. Enter the credentials to connect to the database you moved.  It should log you out if successful.
    7. Log in again to make sure everything is working.
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
Back to top
×
×
  • Create New...

Important Information

This site uses cookies - We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.