0
votes
1answer
46 views

SharePoint Foundation 2010 with SQL Server 2008 R2 SP2 - compatibility?

I have to upgrade SharePoint Foundation 2010 databases SQL Server 2008 R2 to SP2. If SharePoint Foundation 2010 is full compatibility with SQL Server 2008 R2 SP2?
1
vote
1answer
35 views

Can multiple MS-Access 2007 front ends be linked to an SQL Server 2008 backend on Sharepoint?

I have several computers at different locations, each with their own copy of an MS-Access 2007 front end. Each copy links to an SQL-Server 2008 back end on a server. I would like to migrate the back ...
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 ...
0
votes
1answer
58 views

SharePoint DB Server - CPU usage 1 to 5%. RAM is almost 100% at all the time [closed]

On the SQL server box. I bumped the RAM to 24 GB and allocated 20GB for SQL Server. Now the performance looks like attached print shot. I see there is barely 1 GB RAM available and only 31 Free. Is ...
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 ...
0
votes
2answers
65 views

Which database my current SharePoint server is using

I was told by the DB adminsitrator that the current SharePoint server on staging is connected to database named SV002\SPS, but when i create a new application the database server name will ...
0
votes
1answer
316 views

Sharepoint 2010 Data Sources with Windows Authentication

This is two part questions: Does SharePoint 2010 support Trusted_Connection(Integrated Security=Yes;) when connecting to SQL Servers 2008/2012 for retrieving custom list? If it does how can I set it ...
1
vote
0answers
151 views

Using InfoPath inBrowser forms, create reports from captured data, and present those reports back in SharePoint

I'm using SharePoint 2010 and I have access to InfoPath and BCS services. I’m looking to use InfoPath forms that are accessed IN-BROWSER through SharePoint to capture data, and use that data to ...
0
votes
1answer
115 views

Which versions of sharepoint support sqlserver read commited snapshot isolation?

I have been unable to find out if Sharepoint 2010 or 2013 (or even 2007) are able to take advantage of this MSSQL feature to improve the performance of the database operations invoked by Sharepoint ...
1
vote
2answers
1k views

Workflows and SQL Server Databases

Is it possible to create a workflow that is started by activity in a SQL Server database that is outside of SharePoint? Using a WebPart to put and modify data in a database isn't a problem. ...
0
votes
0answers
316 views

RBS with SharePoint 2010 and SQL Express 2008 / 2012.

My client has about 100GB of files loaded on a File Server. Initially the plan was to upload everything to SharePoint and bring everything under one hood. They have SharePoint Foundation 2010 and SQL ...
0
votes
1answer
777 views

Databases for Sharepoint Foundation 2013

I recently installed Sharepoint 2013 onto a test server to look at the possibilities of upgrading our 2010 instance. After the installation, I noticed that far more DBs were created on my SQL Server. ...
0
votes
1answer
927 views

How to Create Analysis service Data Source for SharePoint Dashboard designer?

We don't have data warehouse, we want to add Reports in SharePoint dashboard designer from SharePoint list as data-source, but Reports accepts only analysis service as Data source. So can anyone ...
1
vote
2answers
484 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 ...
0
votes
1answer
638 views

SharePoint Farm SQL Server tempdb/Crawl DB disk configuration

We've identified I/O latency on SQL Server portion of our farm. We see tempdb and CrawlDB are biggest offenders. We have 2 extra Raid 1 disks available to us. Let's call them X: and Z:. The ...
11
votes
3answers
392 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 ...
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 ...
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 ...
2
votes
2answers
652 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 ...
1
vote
2answers
115 views

Extra database server in farm

Recently I was looking at Central Admin > Operations > Servers in Farm and noticed an extra database server. It is the same name as the actual database server with "-Common" appended to the end. This ...
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 ...