You're reading from SQL Server 2019 Administrator's Guide - Second Edition

Product type Book

Published in Sep 2020

Publisher Packt

ISBN-13 9781789954326

Pages 522 pages

Edition 2nd Edition

Languages

SQL

Concepts

Database Administration

Authors (2):

Marek Chmel

Vladimír Mužný

View More author details

Table of Contents (17) Chapters

Preface

1. Section 1: Provisioning the SQL Server Environment

2. Chapter 1: Setting Up SQL Server 2019

3. Chapter 2: Keeping Your SQL Server Environment Healthy

4. Section 2: Server and Database Maintenance

5. Chapter 3: Implementing Backup and Recovery

6. Chapter 4: Securing Your SQL Server

7. Chapter 5: Working with Disaster Recovery Options

8. Chapter 6: Indexing and Performance

9. Section 3: High Availability and the Cloud with SQL Server 2019

10. Chapter 7: Planning Migration and Upgrade

11. Chapter 8: Automation – Using Tools to Manage and Monitor SQL Server 2019

12. Chapter 9: Configuring Always On High Availability Features

13. Chapter 10: In-Memory OLTP – Why and How to Use it

14. Chapter 11: Combining SQL Server 2019 with Azure

15. Chapter 12: Taming Big Data with SQL Server

16. Other Books You May Enjoy

Leave a review - let other readers know what you think

Summary

Upgrade and migration are important phases in the SQL Server operation life cycle. Each path has its own advantages and disadvantages. As we went through the chapter, you saw that careful planning of such a task is crucial, since there are numerous considerations for the new platform.

In-place upgrades offer you the option to utilize the current hardware of the virtual environment, allowing you to quickly upgrade your SQL Server to new versions. However, this option has more complex rollback if your upgrade fails. With side-by-side migration, you can really use the benefits of the new hardware platform, modern CPUs, and the latest operating system, which will allow you to build the SQL Server again, and then you just need to migrate the data between the old and new SQL Server. There are again numerous options for you, the most common being backup and attach/detach methods. There are many tools that can be used to plan the upgrade—especially SQL Server Data Migration...