SQL Server is a relational database server used in SharePoint

learn more… | top users | synonyms

21
votes
6answers
8k 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
391 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
5answers
269 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
1answer
197 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 ...
4
votes
4answers
3k 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
3answers
7k 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
4answers
10k 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 ...
4
votes
1answer
2k 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
4answers
981 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
4k 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
440 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
195 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
4k 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
237 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
45 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
267 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
2k 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
81 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
860 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
102 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
702 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
565 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
537 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
651 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
2answers
116 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
129 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
156 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
3k 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
811 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
685 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
2answers
1k 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
814 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
1answer
118 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
45 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 ...
2
votes
2answers
636 views

Migrating Windows Sharepoint Services 3.0 from Windows 2003 x86 / MSEE to Windows 2008 R2 x64 / SQL Server 2008

I am having a helluva time with this one. I am attempting to migrate a 5 year old VM running Windows 2003 Windows Sharepoint Services 3.0 that was deployed as a standalone (thus to MSEE) to a ...
2
votes
2answers
249 views

Should we have thousands of sleeping database connections from the Crawler server?

Our IT Manager has brought up a situation where it looks like we have about 5000+ sleeping connections from the Crawl Server to our SQL Server. This seems like quite a bit and it's been slowly ...
2
votes
1answer
1k views

Tutorial to move WSS 3.0 DBs from Windows Internal to SQL 2005 Instance

I have found or have been told about a few ways to move WSS 3.0 databases from the Windows Internal Database to SQL Server 2005. As I read them, however, I find I have more questions. Two I found ...
2
votes
1answer
412 views

What permission does my search service account need for external database searches?

The farm admin for my SharePoint site has a different Default Search Service Account login than the one I am using to create my external content types (which is my personal log in). When I am trying ...
2
votes
2answers
251 views

Database migration problem

We have recently migrated our MOSS databases from MS SQL Express 2005 to MS SQL 2008 both intances running on the same Windows 2003 server. After "successful" migration we switched the 2005 server ...
2
votes
1answer
443 views

Why does Reporting Services in SharePoint integration mode require a minimal install of SharePoint?

I have a two machine set-up, with MOSS 2007 installed on one server (Machine A), and SQL Server 2008 installed on the other (Machine B). In order to run SS Reporting Services in SharePoint ...
2
votes
0answers
32 views

Usage and Health Data Collection using SQL Authentication

I'm having an issue with trying to set my Usage and Health Data Collection to use SQL Authentication. I have tried setting my database credentials to SQL Authentication using both Powershell and ...
2
votes
0answers
54 views

SharePoint Onine List as Datasource to Excel Services / Business Intelligence in SPO

Trying to join 2 SharePoint Custom Lists sources into an excel Services Graph. If so, any BI option for formating list data on an SPO page? Possible now under SPO 2013 A3 license? Confused about ...
2
votes
1answer
393 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 ...
1
vote
2answers
11k views

database size would exceed your licensed limit of 4096 MB per database

We are using sharepoint server 2007 and if i create any files and folders the sharepoint site is throwing some error "Exception from HRESULT: 0x80040E14" and i checked event viewer.here also some ...
1
vote
2answers
2k views

How can I tell SP installation of an existing SQL server

I wish to install SharePoint 2010 standard server but to "show" it the location of an existing SQL server, rather than have the prerquisites installation install its own sql version on the same ...
1
vote
2answers
483 views

Update a list via SQL with MOSS2007?

How can I go about applying an update statement to a on MOSS2007 deployment? Essentially I'd like to write something similar to the following across it: update <list_name> set ...