• DBA

    Microsoft SQL Server upgrade plan and steps

    SQL server upgrade is going lower version of SQL to higher version – the latest version. It can be a minor upgrade i.e. service pack patch apply or major upgrade from one version to another ex: 2016 to 2017. Types: We can perform this in the existing system that is called In-place upgrade. This requires more downtime and better roll back/fall back plan. Since, if anything happens take more time to restore previous state, but quickest one, just taking a backup of everything, mean all and start installation wizard upgrade option. We can install new latest SQL version and copy everything to the new server that is called side by…