To install from a network share, move to the root folder on the share, and then double-click Setup.exe. Insert the SQL Server installation media, and from the root folder, double-click Setup.exe. Make sure that Replication is current and then stop Replication.įor detailed steps for performing a rolling upgrade in a replicated environment, see Upgrade Replicated Databases. Upgrade might fail if local applications are connected to the instance being upgraded. Quit all applications, including all services that have SQL Server dependencies. If you upgrade master servers before target servers, SQL Server Agent will not be able to connect to master instances of SQL Server. When upgrading instances of SQL Server where SQL Server Agent is enlisted in MSX/TSX relationships, upgrade target servers before you upgrade master servers. Stored procedures processed at startup time might block the upgrade process.

This is important for restoring a database, as system logon information resides in master.ĭisable all startup stored procedures, as the upgrade process will stop and start services on the SQL Server instance being upgraded.

For disk space that is required by SQL Server components, see Hardware and Software Requirements for Installing SQL Server.Įnsure that existing SQL Server system databases - master, model, msdb, and tempdb - are configured to autogrow, and ensure that they have sufficient hard disk space.Įnsure that all database servers have logon information in the master database.

Run the appropriate Database Console Commands (DBCC) on databases to be upgraded to ensure that they are in a consistent state.Įstimate the disk space that is required to upgrade SQL Server components, in addition to user databases. If you are upgrading the Database Engine, review Plan and Test the Database Engine Upgrade Plan and then perform the following tasks, as appropriate for your environment:īack up all SQL Server database files from the instance to be upgraded, so that you can restore them, if it is required. For more information about how to add features to an upgraded instance of SQL Server after the upgrade operation is complete, see Add Features to an Instance of SQL Server (Setup). Be aware that you cannot change the features to be upgraded, and you cannot add features during the upgrade operation.

Install avery wizard