SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

3
votes
2answers
5k views

Moving Sharepoint to New Server

I am running a Sharepoint Server 2010 Stardard on a Windows 2008 R2 server. This server also has SQL Server 2008 R2 installed. I want to move the Sharepoint and SQL to 2 completely new machine. What ...
23
votes
6answers
9k views

Backup via SharePoint or backup via SQL Server?

How should I backup my 2010 SharePoint server? As I see it there are 3 choices: Full Farm backup Site collection backup SQL Server backup We're only doing backups using points 1 (occasionally) ...
3
votes
2answers
479 views

Installing RBS

OK I have posted other questions about this but no answers were given so I deleted them and thought I would try one last time before calling it a day... I am trying to install RBS for SharePoint ...
1
vote
1answer
791 views

Change SQL Server Port for existing SharePoint 2010 environment - Howto

I have a SharePoint 2010 environment configured with SQL Server 2008R2. Currently SQL Server is running on 1433. I am willing to change the existing SQL server port from 1433 to some non standard ...
2
votes
1answer
874 views

Restore Content Database to a different farm (Prod -> Beta -> Dev Servers)

My end goal is to have some code that automatically takes the Content Database backup from Production and automatically nightly restores it on Beta. Can I just do backup and restore sql commands? Or ...
1
vote
1answer
214 views

All about SharePoint licences

My question is regarding the licensing of the SharePoint, basically there was already a topic done about it, but it had just bunch of references to website which i already saw and i still didnt get my ...
1
vote
3answers
12k views

Can I use a SQL Express database for sharepoint 2010?

I'm setting up a dev system with only 2 site collections, is it possible to run an express version of SQL 2008 R2? I'm not too worried about performance, mainly that it will install and run for dev ...
0
votes
1answer
1k views

InvalidOperationException after promoting SharePoint server to domain controller

I installed SharePoint 2013 Standard on Windows Server 2012, and it was running fine until I decided to make the server a domain controller: Remove the ADCS role Remove then re-add the ADDS role ...
2
votes
2answers
257 views

Should we run SharePoint 2013 on Windows Server 2012 or 2008 R2

We are getting ready to start a project to bring up a brand new SharePoint 2013 Intranet/Extranet site and was wondering if we should be using Windows Server 2008 R2 SP1 or Windows Server 2012. I know ...
2
votes
1answer
427 views

File size too large with RBS and SharePoint 2013

since i set up my SP2013 Foundation Preview with SQL Server 2008 R2 Express i wanted to use the RemoteBlobStorage. It works seemingly fine just now. The only problem is if my files which im uploading ...
2
votes
2answers
705 views

(De)Commission SharePoint Database Servers

In our SharePoint Farm, We are running with 2 Database Servers and on which we have 20+ Databases.Now, due to some issues we would like to decommission the existing database servers and commission 2 ...
0
votes
1answer
162 views

SQL Server Agent in my Web Farm

Im trying to setup some scheduling in my SharePoint 2010 Farm, where I have 2 WFE's and 1 DB server. In attempting to setup a scheduled task, I received the error "The SQL Agent service is not ...
0
votes
2answers
2k views

Recommended SQL Server 2008 R2 instance features for Sharepoint Foundation 2010

Are there any recommended SQL Server 2008 R2 instance features for Sharepoint Foundation 2010 please? Is there any specific SQL feature that should be enabled please?