TABLE OF CONTENTS
Table of contents .................................................................................. 2
Executive summary ............................................................................... 3
Why consider migrating to SQL Server 2008 R2 on a Dell
PowerEdge R515? ..................................................................... 4
Features of the new Dell PowerEdge R515 .............................. 4
Features of Microsoft Windows Server 2008 R2 and Microsoft
SQL Server 2008 R2 ................................................................... 5
Consolidation with Dell technology simplifies and adds features ........ 6
The power of consolidation ...................................................... 6
We show you how: Preparing for the move ......................................... 9
Evaluating your databases ........................................................ 9
Configuring your internal storage ........................................... 10
Installing Windows Server 2008 R2 and enabling the Hyper-V
role .......................................................................................... 11
Creating your virtual machines ............................................... 12
Installing SQL Server 2008 R2 on your virtual machines ........ 13
We show you how: Making the move ................................................ 16
Upgrade Advisor makes it easy ............................................... 16
Side-by-side migration ............................................................ 19
We show you how: After the move .................................................... 23
Logins and dependencies ........................................................ 23
Summing it all up ................................................................................ 26
Appendix A – Example database survey ............................................. 27
Appendix B – Preparing the storage ................................................... 29
Appendix C – Installing windows and enabling Hyper-V .................... 30
Appendix D – Creating virtual machines ............................................. 32
Appendix E – Installing SQL Server 2008 R2 ....................................... 34
Appendix F – Installing Upgrade Advisor ............................................ 36
Appendix G – Migrating databases ..................................................... 38
Backing up a SQL Server 2000 database ................................. 38
Backing up a SQL Server 2005 database ................................. 39
Restoring a database to SQL Server 2008 R2 .......................... 40
Appendix H – Transferring Windows logins ........................................ 42
Appendix I – Transferring SQL Server logins ....................................... 43
Mapping transferred logins to database users ....................... 43
About Principled Technologies ........................................................... 45
Comentários a estes Manuais