SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

24
votes
6answers
10k 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) ...
11
votes
3answers
449 views

SharePoint database maintenance for the non-DBA

Question ported from Serverfault as it is specific to database maintenance for SharePoint administrators: For SharePoint administrators, SQL Server is often a black box that is installed as a ...
8
votes
9answers
6k views

Content database size vs site collection size

We have one rather large content database in our environment. In this content database, a single site collection resides. In Central Admin, this site collection lists as being 464699 MB big. Since ...
8
votes
5answers
422 views

Should I use lots of SharePoint Lists or a SQL Database to store the data for my new bespoke application?

I am working on a project to create a new bespoke intranet website for around 50 users. The data volumes are relatively small, but in order to model the data I need to store (about the 100 or so ...
7
votes
5answers
5k views

SQL Server 2005 vs SQL Server 2008 on SharePoint 2010

I'm writing a recommendation for an upgrade scenario from SharePoint 2007 to SP2010. Customer is currently running x64 SQL Server 2005 SP3 on Windows 2003 Server. Does anyone have pros/cons for ...
6
votes
4answers
1k views

Reusing and parameterising BCS External Content Types

I recently posted a query here that asked about the best way of connecting to an external SQL store. I got some great responses back but need a little more info, specifically around External Content ...
5
votes
4answers
13k views

Cannot connect to the configuration database

During usage yesterday my SharePoint services locked up the entire server and forced me to end process SharePoint tasks and stop SharePoint services. The problem was attributed to Office Web Apps, so ...
5
votes
1answer
281 views

Do SQL Full Backups of Content Databases interfere with SharePoint differential backups using backup-sofarm

I've recently switched our SharePoint 2010 backups from using stsadm to the PowerShell backup-spfarm technique but just have a bit of a worry about differential backups. Essentially we're running ...
5
votes
1answer
295 views

Sharepoint 2013 and SQL Server 2012 Service Pack 2

I've tried to research this, but I'm not seeing anything relevant to installing Service Pack 2 for SQL Server 2012. Our DBA's want to apply this to out SharePoint 2012 SQL Server, but I can't find ...
4
votes
4answers
4k views

Why is SharePoint_Shell_Access permission required to run SharePoint powershell?

So we're setting up a SharePoint farm and it seems our admin accounts require access SharePoint_Shell_Access role on SQL. http://technet.microsoft.com/en-us/library/ee806878.aspx ...
4
votes
1answer
53 views

Is it a good practice to have 2 SQL Severs for a SharePoint site?

Is it a good practice to have 2 SQL Severs for a SharePoint site? If yes, can you recommend me link(s) for how to add it?
4
votes
3answers
8k views

How do I populate a SharePoint list from a SQL table?

I would like to know the best way to get data from a SQL view into a temporary SharePoint list from within SharePoint.
4
votes
1answer
3k views

Form for user to input data and submit to run sql command

We're looking for an quick and easy way for an HR person to enter data into a couple fields and then have them click submit and have it execute some SQL Update query on the database. We don't need to ...
4
votes
2answers
2k views

Execution of code as Application Pool account

Here is what I'm currently trying to do - 1.Create a new instance of a timer job from a web part 2.Add a new site collection to the current web application again from a web part Each time the code ...
3
votes
2answers
10k views

“Invalid License Data. Reinstall is required” error when installing SharePoint 2013 after Sql Server 2012 on the same machine

I've already installed SQL Server 2012 on my machine. Then I tried to run the SharePoint 2013 Foundation installer but I received the following error before I even reached the splash screen menu: ...
3
votes
4answers
1k views

What is the recommended way to query data on a Sharepoint site?

Say if I need to retrieve list items for batch processing, how would I be recommended to retrieve the data? Maybe Powershell or a SQL Server query?
3
votes
4answers
6k views

Claim SQL server space after content deleted from SharePoint

We have a site collection with its own database where we have been testing migration of a department's shared drive content (about 40GB) via a third party tool. The test migrations went fine. Before ...
3
votes
2answers
517 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 ...
3
votes
1answer
4k views

Find a farm's database server and instance in PowerShell

How can I find the SQL server name AND instance where my databases are stored using PowerShell? Assuming I am not using an alias and can't check cliconfg. In servers in farm, I can see the server ...
3
votes
1answer
200 views

Remote BLOB Storage and Sharepoint 2010

I have a SharePoint Server 2010 documents library. Library's size - 20 Gb. Size increases each year by 1-2 GB. It stores files ranging in size from 1 to 50 MB. Files rarely change. Should I use the ...
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 ...
3
votes
1answer
245 views

Which version of SQL Server Express gets installed with Search Server Express 2010?

What exact version of SQL Server Express 2008 gets automatically installed via the standalone setup of SSE 2010? Is it just SQL Server Express 2008, SQL Server Express 2008 R2 or a special kind of ...
3
votes
2answers
50 views

Migrated 2010 Databases, but some DBs can no longer be pointed to due to alias

Here's our scenario. We successfully migrated our SharePoint 2010 Foundation databases to another server using this method and this article. The key point is that we set up an alias from our existing ...
3
votes
1answer
414 views

Extracting browser-compatible InfoPath 2013 form submission data into a SQL Server 2008 Database as well as a SharePoint 2013 list

We are looking at using InfoPath 2013 to capture simple sets of data without the need the need for writing custom applications. However, we still need the information to be stored in a SQL Server 2008 ...
3
votes
1answer
5k views

Sharepoint 2013 - SQL Server connection stopped working shortly after database server rename

We have an issue that has been solved, but I am trying to find an explanation. Our Sharepoint 2013 was working fine connected to a SQL 2012/Windows 2012 machine via a SQL Server Alias. We had to ...
3
votes
1answer
95 views

SP2010: What happens when starting several Content deployment jobs at the same time?

what happens if I start several content deployment jobs synchronously in different site collections by ContentDeploymentJob.Run()? Are the jobs definitely executed one after another? Thanks!
2
votes
2answers
1k views

Should I regularly backup and shrink my content databases through SQL?

I've been contending with hard disk space on my SharePoint 2010 (with SQL 2008) environment for a while and I've just recently found out a few things that I think might help. Should I be regularly ...
2
votes
2answers
1k views

Changing to SQL alias after installing MOSS

Our network admin installed MOSS using the SQL Server address instead of using the SQL alias. How can we change this after the fact? We tried using a simple stsadm commmand to change server name but ...
2
votes
2answers
456 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
2answers
845 views

Cannot update DB record from SP timer job

I am trying to create a timer job that will read a list of new customers from a SQL server db, create a site for the customer and then update the table with the site's id. I have no trouble reading ...
2
votes
2answers
572 views

What MOSS issues can I expect with default SQL Server collation?

SharePoint installation guidance specifies that SQL Server collation should be set to Latin1_General_CI_AS_KS_WS (case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive). However, ...
2
votes
1answer
761 views

Problem with PowerShell script in Tasks Sheduler Windows Server 2008 R2 - SharePoint Shell Access?

I have a problem with PowerShell script in Tasks Sheduler in Windows Server 2008 R2. I try to run Sheduler Tasks which run batch file which run PowerShell script to Backup Farm and while I choose "Run ...
2
votes
2answers
479 views

Migrate Sharepoint 2007 to 2010

So right now there's a SharePoint 2007 site filled with data. I have to migrate EVERYTHING properly from the SharePoint 2007 site to a new server that has SharePoint 2010 and Windows Server 2008 ...
2
votes
2answers
764 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 ...
2
votes
1answer
24 views

SharePoint - reporting data from SQL

We have got a time tracker website in ASP.NET which is used by employees to record their daily time and work. The data is huge (about 10 years of data and ongoing) and stored in the SQL database. We ...
2
votes
5answers
121 views

Creating SQL Alias after configuring SharePoint 2013 farm

I am trying to configure sql alias in SharePoint farm. I have followed various articles about configuring it through cliconfg.exe and it looks fine. I have rebooted server and all the services. When ...
2
votes
2answers
748 views

Is it suggested to restart SQL servers regularly?

In my experience, all Microsoft products need to be restarted regularly to keep the memory allocation healthy. But I always think it is an unofficial practice until I see this article: ...
2
votes
1answer
474 views

Timestamp in Sharepoint external content type not matching value in SQL table

I have an external content type in SharePoint 2010 pulling data from a SQL 2008R2 DB using BCS. All the data comes back fine but the Time stamp column is off by 2 hours when I compare the values ...
2
votes
1answer
232 views

Installing SharePoint 2013 on local Domain

I'm trying to install SharePoint 2013 for our company. We already have a Domain Controller running on a separate Windows Server 2003. I am creating a separate server (Windows Server 2008 R2 x64) to ...
2
votes
1answer
4k views

Create reports from SharePoint lists

We currently have SharePoint 2010 Standard with SQL Server 2008 R2 Enterprise, and Visual Studio 2010 Ultimate for development. As I understand it, to be able to create reports from SharePoint lists I ...
2
votes
2answers
1k views

Move database without creating alias

when we started with Sharepoint we installed everything on a sqlserver that was used for non-sharepoint activities to. Now however we decided to seperate those from each other. Management decided that ...
2
votes
1answer
762 views

Two Server Sharepoint Farm Topology

I'm working on creating a product for Sharepoint and have set up a server farm consisting of two machines running Server 2008 R2. I want to set up SQL2008 on one Machine, and SharePoint 2010 on the ...
2
votes
1answer
461 views

Use REST to sum a column?

I want to retrieve items from a SharePoint list using REST, and then sum one of the columns. I'm brand new to REST, and didn't see a way to do this on MSDN. Is it possible to sum a column in a REST ...
2
votes
2answers
2k views

Import a SQL Server table into a SharePoint list to use in InfoPath

I need put the SQL table (with over 20000 records) into a SharePoint list, and use it in InfoPath.
2
votes
1answer
980 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 ...
2
votes
2answers
19 views

Sharepoint databases status in SQL Server

We have a SharePoint oriented environment where all the content and config databases are hosted on SQL Server. My question is there some way from SQL Server end to find out if the content databases ...
2
votes
1answer
129 views

SharePoint 2013 + Reporting Services + Kerberos

How to configure SharePoint 2013 with Reporting Services for delegations if I get data for Reporting Service from other SQL server that ShqrePoint database? I found below blog but I'm not sure about ...
2
votes
1answer
30 views

How to fill up values from sql into a newform.aspx

I have a list that has fields like, name, position, year of birth. This information is stored in a database (read only). When a user opens list's form (an OOTB form) , I want to go to the database, ...
2
votes
1answer
390 views

Claim Based authentication on SharePoint 2013 and “Integrated Security”

I have a problem with a SharePoint 2010 application that now runs on SharePoint 2013. The application has been converted and seems to have no problem "from a code" point of view. The problem comes ...
2
votes
1answer
48 views

What exactly does it mean that storing “large blobs in the database reduces performance”?

To someone who knows database internals this may be an easy question, but can someone explain in a clear way why storing large blobs (say 400 MB movies) in the database is supposed to decrease ...