Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SharePoint 2013 - Split Site Collections between different SQL Servers - (not a single site collection)

Posted on 2014-03-21
2
Medium Priority
?
459 Views
Last Modified: 2014-03-23
I have a requirement to be able to create site collections (from the same Web App) between not only different content databases (which I know how to do), but to also be able to spread the web app as well as site collections over different SQL servers, (without using SQL alias or clustering or any type of name consolidation.) In other words, when a site collection is created be able to say this one goes to server1\sqlinstance and this one goes to server2\sqlinstance, all within the same web app.

I can imagine it being possible, but again I can also imagine it being not possible, and I am leaning that direction. If any one has any concrete information, a tech net article would be great, please let me know.

Thanks
0
Comment
Question by:Walter Curtis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 2000 total points
ID: 39948934
I went through this article and it seems to have everything you need to move a site collection to another database server added to a farm.

http://technet.microsoft.com/en-us/library/cc262781(v=office.15).aspx

Note: You can't split the collection data between servers.  I doubt Microsoft would ever support that
0
 
LVL 20

Author Closing Comment

by:Walter Curtis
ID: 39949201
Thanks very much for the information. That is what I was looking for.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

610 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