Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SharePoint 2013  databses

Posted on 2013-12-16
5
Medium Priority
?
429 Views
Last Modified: 2014-01-02
How do you change the SharePoint database servers in 2013?

For example I have two SQL 2008 R2 Servers named Sever 1 and Server 2 and I need to change the SharePoint database server from Server 1 to Server 2.
0
Comment
Question by:Cincy_1691
  • 2
4 Comments
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 39723434
Hi,
do you also want to move the existing databases?
If yes, then here is a complete step-by-step article from the MSDN documentation:
http://technet.microsoft.com/en-us/library/cc512725.aspx

HTH
Rainer
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 39725941
Note: This wasn't supported in SharePoint 2010 and older and is new to 2013.  Backup everything before you try it and be sure to execute every step.  Once a SharePoint installation is broken it's brutal to fix.
0
 

Accepted Solution

by:
Cincy_1691 earned 0 total points
ID: 39744258
Instead of moving the databases, it was easier to preform a farm restore. All is well and working as expected.
0
 

Author Closing Comment

by:Cincy_1691
ID: 39750948
Restoring the farm worked to fit our needs.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question