![]() ![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |