none
Move MSSQL Server to another Server

    Question

  • Hi, So I'm about to move a MSSQL Server to another better hardware server.
    I need to make sure I'm moving everything.
    I made a small list of what I think I need to move:
    Databases (ofcourse :))
    MSSQL Mail Settings
    MSSQL Jobs
    MSSQL Maintenance plans.
    MSSQL Users (System users)

    My question is, There is a way to export or backup those settings and then easily restore them on the new server? instead of recreating everything.
    Like, Backup entire MSSQL server settings?

    Hard disk / Operation System Clone is not an option for me.

    Sunday, April 30, 2017 3:14 PM

Answers

  • Found solution:

    http://yrushka.com/index.php/sql-server/database-recovery/sql-server-migration-from-one-server-to-another-detailed-checklist/

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/514dcabb-cb9a-4ece-a3d0-f4ae141b6e30/extract-configuration-of-another-copy-sqlserver?forum=sqlservermigration

    • Marked as answer by shlomiuni Sunday, April 30, 2017 3:32 PM
    Sunday, April 30, 2017 3:32 PM