将SQL数据库从一台服务器切换到另一台服务器 [英] Switch SQL Databases from One Server to another Server

问题描述

我们有两个用于Sharepoint 2013环境的SQL Server:

We have two SQL Servers for Sharepoint 2013 Environment:

一个SQL包含配置和服务应用程序数据库

One SQL Contains Config and Service Applications DB

第二个SQL包含内容数据库

second SQL Contains Content DBs

第二个SQL出现问题，出现蓝屏并频繁重启.因此，计划执行以下操作:

We have an issue with the second SQL and receiving blue screen and frequent reboots. Hence, Planning to do the following:

选项#1

1.创建一个新的虚拟机

1. Create a new VM

2.安装相同版本的SQL Server

2. Install SQL Server of same version

3.将数据库从第二台SQL服务器备份和还原到新的SQL Server

3. Backup and Restore the Databases from the second SQL server to the new SQL Server

4.翻转服务器名称和IP地址

4. Flip the Server name and IP address

5.对应用程序进行测试，以确保一切正常.

5. Test the Application to ensure everything is working as expected.

这是推荐的方法吗?.以前有人做过吗?

is this recommended approach?..Has anyone done this before?

Sharepoint 2013会不会有任何问题.

Will there be any issues with Sharepoint 2013. 

如果这不是推荐的方法，那么我有第二种选择:

If this is not a recommended approach, I have the second option:

选项#2

1.创建一个新的虚拟机

1. Create a new VM

2.安装相同版本的SQL Server

2. Install SQL Server of same version

3.将数据库从第二台SQL Server备份和还原到新的SQL Server

3. Backup and Restore the Databases from the Second SQL Server to the new SQL Server

4.从Sharepoint CA卸载所有内容数据库

4. Dis Mount all the Content Databases from Sharepoint CA

5.从新的SQL Server挂载所有内容数据库

5. Mount all the Content Databases from the new SQL Server

6.对应用程序进行测试，以确保一切正常.

6. Test the Application to ensure everything is working as expected.

非常感谢

Venkatesan Nadimuthu

Venkatesan Nadimuthu

推荐答案

建议您使用第二种方法.这是帮助的参考.

Your second approach is recommended.  Here is a reference to help.

https://technet.microsoft.com/zh-CN/library/cc512725.aspx?f=255&MSPPError=-2147217396

https://technet.microsoft.com/en-us/library/cc512725.aspx?f=255&MSPPError=-2147217396

这篇关于将SQL数据库从一台服务器切换到另一台服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！