How can I move my database to a different SQL Server? - Dell OpenManage Essentials - Systems Management - Dell Community
Systems Management Forums

How can I move my database to a different SQL Server?

Systems Management

Systems Management
Dell Systems Management Solutions: Dell OpenManage, iDRAC, Repository Manager, Microsoft SCCM, Chassis Managment Controller, and more

How can I move my database to a different SQL Server?

  • I have OME installed using one of our SQL servers.  We need to get rid of that server so I need to move the database to a different SQL server.  Is it as simple as having our DBA move the database and then just editing something in OME to point to the new location or is there a more involved process I'd need to follow?

    Thanks.

  • Hi, thanks for the query.

    After moving the database (remove from source and restore at target), when you launch OME for the first time, it will ask for database reconfiguration. You need to provide new SQL server and instance details with credentials to finish the process. No other edits required.

    Always good to keep a backup copied. Also, good to keep following white paper handy for any database related tasks / operations needed with OME:

    http://en.community.dell.com/techcenter/extras/m/white_papers/20441772

    Thanks,

    Shivendra