2 Replies Latest reply on Jan 14, 2010 9:57 AM by amcnair

    Problem Migrating MSDE to SQL Server

      Recently our EPO 4.5 database reached 4GB which is the limit for MSDE. As a result, I can no longer login to the EPO console as the database is at capacity. The solution is to move the database to a SQL Server, which looks straight forward enough. The problem is, as I can't get logged in, I have no apparent way of changing the database settings and pointing EPO to the new server. The only way out as far as I can see is to reinstall the whole thing. Is there another way?

        • 1. Re: Problem Migrating MSDE to SQL Server
          jstanley

          The best solution here is to reduce your ePO DB size. See KB51873 for instructions shrinking the ePO DB. The instructions are written for ePO 4.0 but they are essentially the same for ePO 4.5. None of these steps require access to the ePO console.

           

          You can certainly migrate the ePO DB. Once you detach the DB from the current SQL server and restart the ePO services ePO will no longer be able to connect to the DB and should allow you to access the core/config page without prompting for a password.

          • 2. Re: Problem Migrating MSDE to SQL Server

            Thanks Jeremey, that worked great. I detached the database and then was able to access the core config page. From there it was a simple case of restoring the database in SQL 2005 and repointing EPO. Thanks again.