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
373 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
2answers
26 views

How to bring down/reduce the SharePoint DB Server memory usage?

For our SharePoint 2013 application, we are using 2 Web Servers 2 APP 2 DB One of the DB server memory usage is about 78%. (Windows Server 2012 with 16 GB RAM, where sqlserver.exe takes upto 9 ...
0
votes
0answers
12 views

Database is in compatibility range and upgrade is recommended

In my farm I installed the SharePoint 2013 directly, and I didn't had any older SP system in the farm. I am not sure why i get the following error message : The following databases have versions ...
1
vote
1answer
46 views

SharePoint_Config_Log fast increase in size

the SharePoint_Config_Log size is taking a lot of space really fast i need to make stop at least make go slower. am i missing anything?
0
votes
0answers
31 views

Subscription settings: database is too old, but version is latest

The SP1 was installed and a couple other cumulatives and on monday I installed the August Cumulative Update, now the subscription setting database wont launch. I even re-created the service ...
0
votes
2answers
2k views

How to stop SQL time out issue

I keep getting "System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." 9 out of 10 times when I try to ...
0
votes
1answer
38 views

BCS Question (scenarios when data source is unreachable)

I have a few real-world (hopefully simple) BCS questions for on-premise database and SharePoint Online (O365) connected by OData web service: In the scenario where the data source is ...
0
votes
1answer
22 views

Restore content database 2013

I am trying to restore a SharePoint site with a backed up content database. I restored the backup of the content database to Sql server, then when i created the web application i entered the restored ...
0
votes
2answers
49 views

confused about database attach upgrade from 2010 to 2013

I am in the process of a test upgrade from 2010 to 2013. I have set up a new test farm and I want to start attaching databases to the test farm but I have a few questions I can't figure out. What ...
0
votes
0answers
420 views

How to change the database server in SharePoint server 2010?

I have SharePoint Server 2010 installed on Server A (all the roles are on the same machine),and now I need to add a new server B which must be the new database server, so I need to move all the ...
1
vote
2answers
795 views

SharePoint still holding a reference to Managed Meta data site columns even after deleting and cleaning database

I am facing some weird issue during the custom farm solution deployment in staging. I am receiving below error when activating the one of the features which deploys custom managed metadata fields as ...
0
votes
1answer
39 views

Is it possible to deploy a Sharepoint Foundation content database to Azure SQL Services?

We are starting a new project and to be costly effective we need to use Sharepoint Foundation 2013. We are planning to deploy both Sharepoint and Database to cloud. For Sharepoint we will use a ...
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
1answer
87 views

Does sharepoint online support external Data sources

We are looking to migrate to sharepoint online from our current on premise installation and currently have one question that is still unanswered. We use custom WebParts (which we will need if we ...
2
votes
1answer
32 views

Is reading from SP Databases supported through Open Specifications?

Microsoft has documented certain things as part of their Open Specification. This includes SharePoint, like MS-UPSSDSP (PDF) which is documented as Specifies the User Profile Social Data Stored ...
0
votes
1answer
80 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?
0
votes
0answers
22 views

Two content databases for the one SharePoint application. Can I kill one?

I have an old SharePoint 2007 Sub-Site migrated across to my SharePoint 2010 environment via the DB Attach method. I've noticed that whoever did the DB attach has brought over 2 copies of the Database ...
1
vote
1answer
602 views

Built-in database limits for Foundation 2013

When I install Sharepoint Foundation 2013 as a stand alone installation, it uses a 'built-in' database. What is the maximum database size here?
0
votes
1answer
139 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
0answers
321 views

How to clear WSS_UsageApplication content?

We've been using Sharepoint 2013. My question / problem is : The database is about 35 Gb and a shrink db on an SQL level didnt help. How to clear WSS_UsageApplication content?
0
votes
0answers
51 views

Sharepoint 2013 database maintenance

I have debugged my solution over and over again. I have installed new site collection and I have remove those. Today, central administration had message: "Missing server side dependencies." I made ...
1
vote
1answer
43 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
858 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
38 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
88 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
49 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
53 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
106 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
48 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
189 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
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 ...
1
vote
1answer
47 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
564 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
45 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
26 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
132 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
46 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
1answer
94 views
1
vote
2answers
1k 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
753 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
62 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
330 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
282 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
72 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
14k 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
8k 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 ...
1
vote
1answer
804 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
62 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 ...