
9
Migrating to a Dell PowerEdge R515 server from two legacy database servers
RAM, and has been optimized to reduce both power consumption
and heat dissipation.
WE SHOW YOU HOW: PREPARING FOR THE MOVE
Our accompanying performance and TCO/ROI reports show from
performance and cost perspectives why you should consolidate your
older database servers to a single Dell PowerEdge R515 and use
Hyper-V virtualization technologies with the added benefits of a
newer SQL Server 2008 R2 release. In this Guide, we address the next
question: How to accomplish this? We discuss planning issues, setting
up the Dell PowerEdge R515, the actual migration using a simple
backup/restore method, and post-migration considerations.
Evaluating your databases
As with any migration or consolidation, planning is a key element.
This is especially true when moving to a virtualized environment. You
must be aware of many specific details related to each physical server
you target for consolidation, including the maintenance window in
which you will migrate the server to its new environment, the users
the move will affect, and the configuration tasks necessary to
assimilate the databases into your consolidated environment. A more
comprehensive example survey appears in Appendix A. Information
to gather before consolidation includes the following:
Server OS version and patch level
SQL Server version and patch level
Number of logins on this SQL Server instance, and what type
of logins these are (Windows or SQL)
Current backup strategy and schedule for the databases on
this server
Replication details for this SQL instance, if any
Detailed information regarding permissions and roles
SQL Server Agent jobs on this SQL Server
Komentáře k této Příručce