none
Need to reinstall SCE on different server, and use remote SQL database instead of local

    Question

  • Hi everyone,

    We have SCE 2010 running on a single server with SQL Express. We are hitting SQL Express limitations (DB size), and also hardware itself seems to be slowing down quite a bit, which makes navigating in SCE console a nightmare.

    We need to basically completely reinstall SCE 2010 on different machine and also we would like to use one of our SQL 2012 Standard servers (will be on separate server), instead of installing SQL Express again.

    Is there an article somewhere that describes the process, or maybe you guys can give us some ideas on how to do this? We would really like to keep SCE server name the same, so SCE management group name, and all agents would still point to the same SCE server name. The only thing we will be changing is SQL server name and instance - it's going to be hosted on different server.

    We tried to "move" SQL server databases following an article on this forum with detach and attach method for databases, as well as changing registry and sql table entries to point to the new SQL server, but it didn't work... maybe because we were trying to move from "local" sql install to "remote" one...

    If you guys have any ideas or can point us to right direction, we would really appreciate it. We basically want to avoid changing or uninstalling all agents from all workstations and servers if possible (hopefully by keeping server/MG group name the same)

    Thanks!


    Friday, April 05, 2013 7:28 PM

Answers

  • Hello,

    I'm afraid that the migrating cannot be done as you wish. 

    How to Migrate System Center Essentials 2010 to a New Server
    http://technet.microsoft.com/en-us/library/ff730227.aspx

    The article above clearly state that the following migration scenarios are not supported:

    • Migrating from a management server with Microsoft SQL Server 2008 Standard or Enterprise Edition installed to a new management server with SQL Server 2008 Express Edition installed, or vice versa.
    • Migrating from a management server that uses a local database to a new management server that uses a remote database, or vice versa.

    A new installation of the SCE server is the only option here.

    Thanks,


    Yog Li
    TechNet Community Support

    Monday, April 08, 2013 6:17 AM

All replies

  • Hello,

    I'm afraid that the migrating cannot be done as you wish. 

    How to Migrate System Center Essentials 2010 to a New Server
    http://technet.microsoft.com/en-us/library/ff730227.aspx

    The article above clearly state that the following migration scenarios are not supported:

    • Migrating from a management server with Microsoft SQL Server 2008 Standard or Enterprise Edition installed to a new management server with SQL Server 2008 Express Edition installed, or vice versa.
    • Migrating from a management server that uses a local database to a new management server that uses a remote database, or vice versa.

    A new installation of the SCE server is the only option here.

    Thanks,

  • Migrating from a management server with Microsoft SQL Server 2008 Standard or Enterprise Edition installed to a new management server with SQL Server 2008 Express Edition installed, or vice versa.
  • Migrating from a management server that uses a local database to a new management server that uses a remote database, or vice versa.
  • Migrating from a management server with Microsoft SQL Server 2008 Standard or Enterprise Edition installed to a new management server with SQL Server 2008 Express Edition installed, or vice versa.
  • Migrating from a management server that uses a local database to a new management server that uses a remote database, or vice versa.
  • Migrating from a management server with Microsoft SQL Server 2008 Standard or Enterprise Edition installed to a new management server with SQL Server 2008 Express Edition installed, or vice versa.
  • Migrating from a management server that uses a local database to a new management server that uses a remote database, or vice versa.

  • Yog Li
    TechNet Community Support

    Monday, April 08, 2013 6:09 AM
  • Hello,

    I'm afraid that the migrating cannot be done as you wish. 

    How to Migrate System Center Essentials 2010 to a New Server
    http://technet.microsoft.com/en-us/library/ff730227.aspx

    The article above clearly state that the following migration scenarios are not supported:

    • Migrating from a management server with Microsoft SQL Server 2008 Standard or Enterprise Edition installed to a new management server with SQL Server 2008 Express Edition installed, or vice versa.
    • Migrating from a management server that uses a local database to a new management server that uses a remote database, or vice versa.

    A new installation of the SCE server is the only option here.

    Thanks,


    Yog Li
    TechNet Community Support

    Monday, April 08, 2013 6:17 AM