从2008 R2迁移到SQL Server 2016 [英] Migrating from 2008 R2 to SQL Server 2016

问题描述

大家好，

我们正在将许多托管SQL 2008 R2的服务器迁移到更新的SQL 2016.我想要了解我们取消调试旧服务器时的最佳做法。

We are migrating many servers which were hosting SQL 2008 R2 to newer SQL 2016. I want to know the best practices when we de-commission the older servers.

这些是我们计划遵循的步骤：

These are the steps which we plan to follow:

• 将数据库迁移到新服务器，然后将旧数据库置于"只读"模式。
• 将登录迁移到新服务器，然后删除登录在旧服务器上。
• 迁移所有SSIS作业&维护计划到新服务器。删除旧服务器上的作业。

虽然我们确保没有与旧服务器的连接，但我们是否需要这样做在取消调试旧服务器之前的任何事情？比如，删除数据库而不是进入"只读"模式？

While we ensure that there is no connection to the old servers, do we need to do anything before de-commissioning the older servers? Like, deleting the databases rather than putting in 'read-only' mode?

我们确保旧服务器上没有数据受到了损害？

Ho do we make sure that no data on the older server gets compromised?

我有什么遗漏？

问候，

Jatin Rajkumar

Jatin Rajkumar

推荐答案

旧服务器不要删除什么，除非你确定你的生产是好的。在某些情况下，有些工作每月运行，所以在退役前等待一个月。如果出现问题，你仍然有旧的服务器，数据库只读
模式，每个对象都完好无损。

For old server do not delete anything UNLESS you are sure that your production is going good. In some cases there are jobs which run monthly so wait for a month before decommissioning. if something goes wrong you still have old server with DB in read only mode and every object intact.

对于退役，需要完整的用户和系统数据库备份，将其保存在磁带机上，保护它 并简单地格式化机器

For decommissioning take full user and system database backup, save it on tape drive, secure it  and simple format the machine

这篇关于从2008 R2迁移到SQL Server 2016的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！