You are the database administrator of your company. The network contains a server named SQL1 that has the32-bit version of SQL Server 2005 Express edition installed.
SQL1 hosts an application that backs up databasesstored on SQL1 . You want to install a default instance of SQL Server 2008 on SQL1 .
You discover that theapplication uses the DUMP statement that is no longer supported by SQL Server 2008.
You want to upgrade SQL1 to SQL Server 2008.
Which editions of SQL Server 2008 can you use to upgrade SQL1 ? (Each correct answer represents a part of thecorrect solution. Choose two.)
A.
SQL Server 2008 Standard
B.
SQL Server 2008 Enterprise
C.
SQL Server 2008 Express
D.
SQL Server 2008 Express Advanced
Explanation:
Only SQL Server 2008 Express and SQL Server 2008 Express Advanced can be used to upgrade a 32-bitversion of SQL Server 2005 Express edition to SQL Server 2008. Before upgrading your SQL server, you shouldconsider backward compatibility for applications that are installed on the SQL server. This is useful when youwant to identify and use applications that are not supported by SQL Server 2008. If your SQL server contains anapplication that contains features that are no longer supported by SQL Server 2008, such as the DUMP commandin this scenario, you should either modify your application or consider installing SQL Server 2008 as a namedinstance. Installing SQL Server 2008 as a named instance will allow the default instance to remain as the olderversion of SQL Server to support the deprecated features. If you upgrade an earlier version of SQL Server to SQLServer 2008, the previous instance of SQL Server will be overwritten and will not be available on the computerafter the upgrade. SQL Server 2008 Standard and SQL Server 2008 Enterprise cannot be used to upgrade a 32-bit version of SQLServer 2005 Express edition to SQL Server 2008.
Objective:
Installing and Configuring SQL Server 2008Sub-Objective:
Install SQL Server 2008 and related services.References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Getting Started > Initial Installation > Upgrading to SQLServer 2008 > Version and Edition Upgrades MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Deployment > Upgrade > Considerationsfor Upgrading the Database Engine MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Getting Started > Initial Installation > SQL Server Setup UserInterface Reference > Instance Configuration