Changing SQL Server
-
sexta-feira, 22 de junho de 2012 13:38
What is the procedure to change the SQL Server DB Server on a running SP 2010 Farm
Currently we are running SP 2010 Enterprise SP1 and SQL Server 2008 R2. It just configured and started working on the contents. We need to change the DB Server to SQL Server Enterprise 2012 version. We have only one front end server and one DB server.
Can we disconnect the server by running the Config Wizard from Central Admin and reconfigure with new DB Server details?
Todas as Respostas
-
sexta-feira, 22 de junho de 2012 14:06Moderador
- Sugerido como Resposta Fadi Abdulwahab sábado, 23 de junho de 2012 08:04
- Marcado como Resposta Rock Wang– MSFT sexta-feira, 29 de junho de 2012 07:03
-
sexta-feira, 22 de junho de 2012 14:06Usuário que responde
Unfortunately it's not quite that simple, but here's a complete writeup of moving from one server to another. Unless you are using SQL aliasing, this is the process.
I trust that answers your question...
Thanks
C
http://www.cjvandyk.com/blog | LinkedIn | Facebook | Twitter | Quix Utilities for SharePoint | Codeplex- Marcado como Resposta Rock Wang– MSFT sexta-feira, 29 de junho de 2012 07:03
-
sábado, 23 de junho de 2012 05:04
Will try this.
We are not using SQL aliasing.
Unfortunately it's not quite that simple, but here's a complete writeup of moving from one server to another. Unless you are using SQL aliasing, this is the process.
I trust that answers your question...
Thanks
C
http://www.cjvandyk.com/blog | LinkedIn | Facebook | Twitter | Quix Utilities for SharePoint | Codeplex -
sábado, 23 de junho de 2012 18:27
If you did want to use a SQL alias, this blog post explains how to do it, http://www.toddklindt.com/sqlalias. The screenshots are for SharePoint 2007, but the steps are all the same.
tk
SharePoint MVP My blog My SharePoint 2010 Admin book: Professional SharePoint 2010 Administration
- Marcado como Resposta Rock Wang– MSFT sexta-feira, 29 de junho de 2012 07:04
.png)
