You maintain several databases on a 32-bit Microsoft SQL Server 2005 instance on a Windows Server
2008 R2 64-bit server.
You need to migrate the databases to a 64-bit SQL Server 2012 instance on the same server. You also
need to ensure that the new Transact-SQL functionality in SQL Server 2012 can be used in the
database after the migration.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A.
Perform a side-by-side installation of a 32-bit SQL Server 2012 instance.
B.
Perform a side-by-side installation of a 64-bit SQL Server 2012 instance.
C.
Perform an in-place upgrade to 64-bit SQL Server 2012.
D.
Detach the database from the old instance and attach it to the new instance.
E.
Change the compatibility level of the database.
Explanation:
Use detach and attach operations to upgrade a SQL Server 2005, SQL Server 2008 or SQL Server
2008 R2 database in SQL Server 2012. After being attached to SQL Server 2012, the database is
available immediately and is automatically upgraded.
This can’t be right. It’s C and E. It says migrate it to a new instance on the same server. If you do a side by side, it will end up on a different server, the one next to it. It’s C and E.
0
0
No the answers are correct. B, D, E.
C is wrong. A migrate is not an upgrade.
1
0
https://msdn.microsoft.com/en-CA/library/ms187858.aspx
0
0
Henry…you can not upgrade 32bit to 64 bit. C is wrong
0
0
Unsupported Scenarios
Cross-version instances of SQL Server 2012 are not supported. Version numbers of the Database Engine, Analysis Services, and Reporting Services components must be the same in an instance of SQL Server 2012.
Cross-platform upgrade is not supported. You cannot upgrade a 32-bit instance of SQL Server to native 64-bit using SQL Server Setup. However, you can back up or detach databases from a 32-bit instance of SQL Server, and then restore or attach them to a new instance of SQL Server (64-bit) if the databases are not published in replication. You must re-create any logins and other user objects in master, msdb, and model system databases.
You cannot add new features during the upgrade of your existing instance of SQL Server. After you upgrade an instance of SQL Server to SQL Server 2012, you can add features by using the SQL Server 2012 Setup. For more information, see Add Features to an Instance of SQL Server 2012 (Setup).
Failover Clusters are not supported in the WOW mode. If you currently have SQL Server 2005, or SQL Server 2008, or SQL Server 2008 R2 failover clusters on the 32-bit subsystem (WOW64), upgrade of the failover cluster to SQL Server 2012 is not supported
Upgrade from SQL Server 2005 Evaluation, SQL Server 2008 Evaluation, and SQL Server 2008 R2 Evaluation to SQL Server 2012 is not supported.
https://msdn.microsoft.com/en-us/library/ms143393(v=sql.110).aspx
0
0