However, this method is time consuming and costly. You need to restore all of your databases and in many cases need to buy a new Windows Server OS license. Then you need to restore any custom SQL Server settings and properties that you may have changed. In Place Upgrade is Much Faster. Alternatively, performing an in place upgrade is much faster as you only need to install the need SQL Server version over top of the old one. Database Mirroring, Mirror Solution, High availability solution, SQL SERVER 2008, Principal, Mirror, Witness, Auto failover, Failover solution. Theres no need to backup and restore. Some database pros say this method is safer because you know youll be running with the same settings and they dont like to change an otherwise stable system. I have performed both successfully many times in the past. In this article Ill cover the steps for performing an in place upgrade of SQL Server 2. SQL Server 2. 01. You can perform an in place upgrade to SQL Server 2. Installation Center or you can upgrade by running setup. In this article Ill guide you through the setup of migrating to SQL Server 2. Installation Center. For more information about using a configuration file you can refer to Install SQL Server 2. Using a Configuration File. The SQL Server 2. SQL Server. SQL Server 2. SP1. SQL Server 2. R2 SP2. SQL Server 2. SP3. SQL Server 2. You cannot perform an in place upgrade for older versions of SQL Server such as SQL Server 2. SQL Server 7. 0, or SQL Server 6. In addition, you cannot add features during the upgrade process. In general, you can upgrade from your current edition to of SQL Server to the equivelant or higher editions. For instance, you can upgrade from the SQL Server 2. R2 SP2 Datacenter edition the highest for that release to the SQL Server 2. Enterprise or Business Intelligence editions. Likewise, you can upgrade for the SQL Server 2. SP1 to the SQL Server 2. Standard, Enterprise, or Business Intelligences editions. The Developer Edition can only be upgraded to the Developer Edition. For a complete list of supported upgrade paths to SQL Server 2. Supported Version and Edition Upgrades. SQL Server 2. 01. Hardware Requirements. SQL Server 2. 01. The minimum processing requirement for a 3. GHz CPU, while the 6. GHz processor. Microsofts recommended minimum processor speed is 2. GHz. The minimum memory requirements for SQL Server 2. The low end SQL Server 2. Express edition requires a minimum of 5. MB while the other editions require a minimum of 1 GB or RAM. Microsofts recommended minimum RAM for the SQL Server 2. Standard edition and above is 4 GB. Disk space requirements vary depending on the features that you install. SQL Server 2. 01. GB of free disk space. SQL Server 2. 01. Operating System Requirements. SQL Server 2. 01. SQL Server 2. 01. In addition, the 3. SQL Server 2. 01. The following table lists all the supported operating systems for the principle editions of SQL Server 2. SQL Server 2. 01. Edition. 32 bit. SQL Server 2. Enterprise. Windows Server 2. R2 6. 4 bit Datacenter. Windows Server 2. R2 6. 4 bit Standard. Windows Server 2. R2 6. 4 bit Essentials. Windows Server 2. R2 6. 4 bit Foundation. Windows Server 2. Datacenter. Windows Server 2. Standard. Windows Server 2. Essentials. Windows Server 2. Foundation. Windows Server 2. R2 SP1 6. 4 bit Datacenter. Windows Server 2. R2 SP1 6. 4 bit Enterprise. Windows Server 2. R2 SP1 6. 4 bit Standard. Windows Server 2. R2 SP1 6. 4 bit Web. Windows Server 2. SP2 6. 4 bit Datacenter. Windows Server 2. SP2 6. 4 bit Enterprise. Windows Server 2. SP2 6. 4 bit Standard. Windows Server 2. SP2 6. 4 bit Web. Windows Server 2. SP2 3. 2 bit Datacenter. Windows Server 2. SP2 3. 2 bit Enterprise. Windows Server 2. SP2 3. 2 bit Standard. Windows Server 2. SP2 3. 2 bit Web. Windows Server 2. R2 6. 4 bit Datacenter. Windows Server 2. R2 6. 4 bit Standard. Windows Server 2. R2 6. 4 bit Essentials. Windows Server 2. R2 6. 4 bit Foundation. Windows Server 2. Datacenter. Windows Server 2. Standard. Windows Server 2. Essentials. Windows Server 2. Foundation. Windows Server 2. R2 SP1 6. 4 bit Datacenter. Windows Server 2. R2 SP1 6. 4 bit Enterprise. Windows Server 2. R2 SP1 6. 4 bit Standard. Windows Server 2. R2 SP1 6. 4 bit Web. Windows Server 2. SP2 6. 4 bit Datacenter. Windows Server 2. SP2 6. 4 bit Enterprise. Windows Server 2. SP2 6. 4 bit Standard. Windows Server 2. SP2 6. 4 bit Web. SQL Server 2. 01. Business Intelligence. Windows Server 2. R2 6. 4 bit Datacenter. Windows Server 2. R2 6. 4 bit Standard. Windows Server 2. R2 6. 4 bit Essentials. Windows Server 2. R2 6. 4 bit Foundation. Windows Server 2. Datacenter. Windows Server 2. Standard. Windows Server 2. Essentials. Windows Server 2. Foundation. Windows Server 2. R2 SP1 6. 4 bit Datacenter. Windows Server 2. R2 SP1 6. 4 bit Enterprise. Windows Server 2. R2 SP1 6. 4 bit Standard. Windows Server 2. R2 SP1 6. 4 bit Web. Windows Server 2. SP2 6. 4 bit Datacenter. Windows Server 2. SP2 6. 4 bit Enterprise. Windows Server 2. SP2 6. 4 bit Standard. Windows Server 2. SP2 6. 4 bit Web. Windows Server 2. SP2 3. 2 bit Datacenter. Windows Server 2. SP2 3. 2 bit Enterprise. Windows Server 2. SP2 3. 2 bit Standard. Windows Server 2. SP2 3. 2 bit Web. R2 6. 4 bit Foundation. Windows Server 2. Datacenter. Windows Server 2. Standard. Windows Server 2. Essentials. Windows Server 2. Foundation. Windows Server 2. R2 SP1 6. 4 bit Datacenter. Windows Server 2. R2 SP1 6. 4 bit Enterprise. Windows Server 2. R2 SP1 6. 4 bit Standard. Windows Server 2. R2 SP1 6. 4 bit Web. Windows Server 2. SP2 6. 4 bit Datacenter. Windows Server 2. SP2 6. 4 bit Enterprise. Windows Server 2. SP2 6. 4 bit Standard. Windows Server 2. SP2 6. 4 bit Web. SQL Server 2. 01. Standard. Windows Server 2. R2 6. 4 bit Datacenter. Windows Server 2. R2 6. 4 bit Standard. Windows Server 2. R2 6. 4 bit Essentials. Windows Server 2. R2 6. 4 bit Foundation. Windows Server 2. Datacenter. Windows Server 2. Standard. Windows Server 2. Essentials. Windows Server 2. Foundation. Windows Server 2. R2 SP1 6. 4 bit Datacenter. Can A Wireless Router Be Hacked Free. Windows Server 2. R2 SP1 6. 4 bit Enterprise. Windows Server 2. R2 SP1 6. 4 bit Standard. Windows Server 2. R2 SP1 6. 4 bit Foundation. Windows Server 2. R2 SP1 6. 4 bit Web. Windows 8. 1 3. 2 bit. Windows 8. 1 Pro 3. Windows 8. 1 Enterprise 3. Windows 8. 1 6. 4 bit. Windows 8. 1 Pro 6. Windows 8. 1 Enterprise 6. Windows 8 3. 2 bit. Windows 8 Professional 3. Windows 8 6. 4 bit. Windows 8 Professional 6. Windows 7 SP1 6. 4 bit Ultimate. Windows 7 SP1 6. 4 bit Enterprise. Windows 7 SP1 6. 4 bit Professional. Windows 7 SP1 3. 2 bit Ultimate. Windows 7 SP1 3. 2 bit Enterprise. Windows 7 SP1 3. 2 bit Professional. Windows Server 2. SP2 6. 4 bit Datacenter. Windows Server 2. SP2 6. 4 bit Enterprise. Windows Server 2. SP2 6. 4 bit Standard. Windows Server 2. SP2 6. 4 bit Foundation. Windows Server 2. SP2 6. 4 bit Web. Windows Server 2.