A usually large collection of data organized especially for rapid search and retrieval (as by a computer).

learn more… | top users | synonyms

0
votes
1answer
249 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
1answer
53 views

BCS Question (changing data source of a web service)

We are going to be building a Web Service (on-premise) to connect our data to SharePoint online (o365) using BCS and OData. If we migrate our database from one location (in Oracle) to another (e.g. ...
1
vote
3answers
1k views

SettingsServiceDB “Database is too old and upgrade is required”

I have ran this command after an update PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures all databases are updated except BdcServiceDatabase, ...
0
votes
1answer
51 views

Playing with SP Database, will it break SP directly?

I am ready about SharePoint databases and what could happen if someone messes with them, all I've seen is that they can affect the upgrade of SharePoint because messing with them could change the ...
1
vote
1answer
122 views

Infopath Form does not work in Sharepoint

I have a form that has 3 Data Connections. Main Data Source (Active Directory) Secundary Data Source (SOAP Web Service) Secundary Data Soruce (SQL Database) I fetch data from AD, from a Web Service ...
1
vote
1answer
86 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
1answer
68 views

SharePoint 2010 Form Integration with iPad App

This might be an odd question and honestly I don't know if it is possible or not. I have a client that is wanting an iPad App form which we developed to be synced/integrated with a SharePoint 2010 ...
3
votes
1answer
111 views

How to check whether Content Database is read-only or not?

How to check whether Content Database is read-only or not using client context ? we can easily get using server object model but how to do this with Client Object Model
0
votes
1answer
71 views

WSS_Web Analytics Service Application database not found error

I have received the following error for a while: A critical incident has occurred where a database was not found on server . Event ID: 3760 Event Description: SQL Database 'WSS_Web Analytics ...
0
votes
3answers
284 views

What is best way manage SharePoint webpart access to database?

I have my custom webpart, which have access to database. I need to configure data source, catalog, username and password, which allows webpart a access database. I don't want that users can see, what ...
2
votes
1answer
46 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 ...
1
vote
1answer
60 views

Is it Possible for data to flow thusly?: Infopath form to Access database to Sharepoint list

We have a department that could solve their issue with a post-it. Instead, they would like a form where people could enter data, and the data would pass to an Access DB, which would be tied a SP 2010 ...
1
vote
1answer
633 views

how to add data connections in infopath codebehind

I'm trying to add multiple data connections to an infopath form in the codebehind. I see that I can connect to a db file , but not straight to sql server. Is this possible? Thanks,
0
votes
0answers
57 views

InfoPath forms and some services do not work after database restoration!

Last they some of my SharePoint server databases stuck in restoring state. After I solved those databases issue. Now some of my SharePoint features do not work. For example Infopath forms can not be ...
0
votes
0answers
28 views

Sharepoint 2010 databases are in restoring state

I have a single server in my SharePoint 2010 server farm. Today some of users complained about that some of Infopath forms can not be opened. When I checked the SOL Server Management Studio I saw that ...
3
votes
3answers
231 views

Sharepoint 2010 Configuring Database Connections without using alias

After migrating all SharePoint databases to a new SQL Server, how can I configure SharePoint to to reference the new SQL Server without using an Alias? The reason we need to avoid using an Alias is ...
0
votes
1answer
2k views

Why SharePoint is not considering 'dbo.AuditData' table while calculating the site-collection size?

We have a heavy used site collection with a 30GB quota limit on the content DB - WSS_WebApp_Content1, I have verified the 'dbo.AuditData' table and found that it has 1.4c records and is 35 GB in size. ...
3
votes
2answers
49 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 ...
1
vote
2answers
2k views

New-SPconfigurationDatabase: Invalid Address on single SP2010 install

Can anyone please help me with this as I'm sure im missing something small. I am installing SP2010 on a Win7 Prof machine. All components on one machine. SQL2008R2 installed and all the features are ...
0
votes
1answer
1k views

another object in this farm already contains the same id

I want to create a debugging web application and another one for UAT. The two applications should use identical content databases. I made a backup from our live content database and did a restore ...
0
votes
1answer
84 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
448 views

Access Database-linked forms not working after Server Reboot

Our server went down & when I rebooted, all is working on site except Access Database-linked forms are not working. It is showing following error: > Preparing Site ... Someone has recently ...
2
votes
1answer
646 views

How to query Oracle db to display table/view?

Using SharePoint 2010, how can you connect to Oracle db to query a view and display the table in SharePoint?
0
votes
2answers
108 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 ...
5
votes
5answers
16k views

List of databases used for a sharepoint 2010 farm?

How to find the list of databases are used by a SharePoint 2010 Farm, including content databases, service application databases and configuration database.
1
vote
3answers
9k views

Moving the Sharepoint 2010 configuration Database to a new DB server..?

We were using the database server "OldDBServer" and have copied all the databases on the new database server "NewDBServer". Now, all the reference (like CA admin content DB, content DBs & Service ...
1
vote
6answers
4k views

Emptying site collection recycle bin doesn't make content DB smaller?

I deleted everything from a site collection recycle bin and remote into the SQL server the content database is located and the sucker didn't get smaller. I had about a good 2 or 3 gigs of files in the ...
2
votes
1answer
2k views

Unable to upgrade WSS_Search_ServerName database

I have got the following error in SharePoint 2010 Central Admin: The following databases require upgrade because their versions are older than the backwards compatible range: ...
3
votes
1answer
77 views

Are documents in SP2010 saved directly to MS SQL Database

When I Upload a document e.g. Word or Excel documents to a document list. Are the files saved directly binary to an SQL database? If yes, could someone give me a url by MS, where I can find further ...
1
vote
0answers
198 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 ...
2
votes
2answers
3k views

accessing database through sharepoint using a service account (windows account)

I am having an issue with connecting to the database for KHouse through sharepoint. I have run through several workarounds to get it to work, but to no avail. We are using several pages that retrieve ...
1
vote
3answers
658 views

How to force standalone install?

On out-of-the-box Windows Server 2012, I installed SharePoint 2013. I was not asked any database question, and SharePoint was working fine. Then I made the server a domain controller and decided to ...
0
votes
2answers
274 views

Updating a backend database from a Sharepoint site?

Okay I'm looking to set up a web based service that for the most part is only used to display data to a number of users. Now initially I'd decided to make something using Sharepoint (2003) as the ...
1
vote
0answers
44 views

What is a SPPersistedUpgradableObject and the IUpgradable interface mean?

SPPersistedUpgradableObject is a SPPersistedObject that implements the IUpgradable interface. The MSDN is seriously lacks any documentation other than it: Provides members for managing an ...
1
vote
3answers
329 views

What are the implications of using a shared/default SQL Server instance vs a dedicated/named one for SP2010 DB Role?

I have a database server that hosts multiple minor databases not related to SharePoint and I want to utilize this server for a SP2010 environment database role. What are the implications of ...
1
vote
0answers
20 views

Re-using SQL instance for multiple farms

During a transition phase of indeterminate length, I will be hosting the databases for a SP2012 farm and an unrelated SP2013 farm on the same physical hardware. I know that the guidance for mixing SP ...
1
vote
2answers
877 views

IBM DB2 database connect to Sharepoint

We have an IBM DB2 database which stores our documents as BLOBS in binary format. I've read about Remote Blob Storage(RBS) and FILESTREAM but I'm still puzzled if its possible to hook up our IBM DB2 ...
2
votes
2answers
751 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
0answers
440 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
3answers
7k views

SharePoint 2010 - Database Schema

I´m searching for informations about the SharePoint 2010 Database. Are there infomations about the different tables/views etc.? I don´t found any documents about the SharePoint 2010 Databases on msdn ...
0
votes
2answers
6k views

Databases require upgrade or not supported

My search stopped automatically crawling on Feb 28. I can still start it manually and it works but it doesn't work automatically. When I went to Central Administration, I saw the following error: ...
0
votes
1answer
1k 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
1k views

Sharepoint site stopped working. Database “needs upgrading”. Upgrade fails

One of my Sharepoint 2010 Site Collections has stopped functioning this morning and presents the following in the browser. Server error: http://go.microsoft.com/fwlink?LinkID=177673 When I look ...
1
vote
0answers
26 views

Editing a Dataview from a joined list

I think I want to do something simple, but it seems maybe I am not doing it the way you are supposed to. I need to use Sharepoint Designer 2007 to create a website, code behind is highly likely to be ...
0
votes
0answers
113 views

Customising parameters in SqlDataSource

I am very new to Sharepoint and ASP and all of this so I suspect my question is really simple but I am confused. I am using Sharepoint Designer 2007 and am not allowed to use code behind. The task ...
7
votes
3answers
3k views

“SharePoint is not a database!” article of 2009 - does it still apply for SP 2010 and 2013?

I'm talking about this blog post by Chris Woodill. He mentions the following advantages of modeling data via SQL programming instead of SharePoint's lists: Primary And foreign keys: one of the most ...
0
votes
1answer
59 views

Implementing a Custom ASPX Page That Uses a Custom Database

I know how to create custom ASPX pages and a deployment package, but I need to implement a custom ASPX page in SharePoint 2010 which uses its own custom database. Please advise me how to do this.
0
votes
0answers
365 views

Database Attach Upgrade - Warnings and Errors

After running the database attach upgrade and getting the site collection running. SharePoint is advising about some problems. 1- Databases running in compatibility range, upgrade recommended. The ...
1
vote
2answers
264 views

error when start new project in visual studio 2010

I am a new administrator to a SharePoint farm and I want to start developing *web-part*s for our sites. In our company we have installed SharePoint 2010 on Windows Server 2008 R2. And we have ...