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

learn more… | top users | synonyms

15
votes
4answers
2k views

Any reason not to create a new content database for each site collection?

When creating a site collection in stsadm there are 2 commands I could use: createsite and createsiteinnewdb, where the latter creates a new content database for the site collection. Reading around ...
13
votes
3answers
7k views

How to split a Content Database within site

I have a very large content database & need to split it. Is it possible to split a content database within a site collection? or I need to create a new site collection?
11
votes
3answers
481 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
1answer
4k views

Splitting a Content Database into two or three?

I have a SharePoint Farm in which the main Portal Web Application uses a single WSS_Content database, which has grown a lot to about 150 GB. I know I can now put it offline and attach a new one, but ...
7
votes
3answers
4k 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 ...
6
votes
2answers
258 views

How to move SQL user database to SharePoint?

I have a SQL and a Access database which I need to import to SharePoint. These database contains information collected from my Internet site like registration info, usernames etc. Is this possible ...
6
votes
1answer
94 views

Which database will feature stapling affect?

We are testing feature stapling and need to revert to a point before the feature stapling was run. To do this do we just need to restore the content database, or do we also need to restore the ...
6
votes
2answers
2k views

The Search Service Application crawl DB default has grown to 60GB

Our Search Service Application was installed but never configured with rules. Our default Search Service Application Crawl DB has grown to 60GB. We attempted to create a new Crawl Database and ...
5
votes
5answers
21k 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.
5
votes
3answers
2k views

Integrating an external database into Sharepoint

One of my current projects involves integrating a client's database into an overall CRM system design. Part of the process was updating their legacy database and porting it over to SQL Server. That'...
5
votes
2answers
15k views

Central Administration cannot connect to configuration database

I made a script for batch uploading files, which I successfully used to upload more than 900 files (few gigs of data). Today I prepared another set of files and everything was working fine, but ...
5
votes
3answers
2k views

Sharepoint 2007 farm performance goes down?

Our sharepoint 2007 farm is not working properly and we are facing a huge performance hit, some times it throws an unexpected error too. What all are the points to check? i.e like Depth of the ...
5
votes
1answer
482 views

How to corrupt content database?

I am working on a solution using which Site Admins can check and repair corrupt DB. I need sample corrupt DB for testing. Any ideas how to corrupt content database?
5
votes
1answer
128 views

Remove and recreate all personal sites - mysites - remove them from DB without waiting ~25 days

Is there a easy way to remove (delete) all personal sites and recreate them all over again? I also want to delete them from the sql. I've tried to delete personal sites and run my site clean up job ...
4
votes
2answers
15k 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 ...
4
votes
3answers
12k views

Move database to new SQL Server

My client has asked me to move all the Database used by the SharePoint Farm to a new SQL Server Machine. I came across this article http://technet.microsoft.com/en-us/library/cc512725(v=office.14)....
4
votes
4answers
322 views

How does SharePoint handle unreliable database connections?

Background We're experiencing network issues with connections to our SQL box unexpectedly being closed. These are occurring a few times a day. Errors are being logged by the SharePoint WFEs but users ...
3
votes
2answers
2k views

How does SharePoint store versions of customised pages?

While a page is uncustomised (previously known as unghosted) it is stored on the file system, however once it is customised (previously known as ghosting) it is copied to the DB. Source 1 and Source 2 ...
3
votes
2answers
473 views

What is the use of the search database and do we really need it?

The index will be kept on the Index Server, so why do we need a Search database and what is the point of it in SharePoint 2007? I would like to understand the basic concept of SharePoint Search. ...
3
votes
3answers
353 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 ...
3
votes
2answers
170 views

What is a safe way to reconnect a server from another farm to the network?

I have VMWare image clone of our virtual Sharepoint web frontend. All the connections are the same (same farm basically), same exchange server, same sql server. I am afraid to connect this box to the ...
3
votes
1answer
128 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
3
votes
1answer
3k 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
7k views

How to know the GUID of a Database?

I follow this step by step http://technet.microsoft.com/en-us/library/ff681014.aspx for reset the User Profile Synchronization Service but I need the GUID of the synchronization database. I searched a ...
3
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 ...
3
votes
3answers
6k views

Enormous database log files - Why are they not being truncated after a SharePoint backup runs?

I've performed a full Farm backup and also a full Site Collection backup using Central Administration site but there are still several enormous database log files 4GB - SharePoint_AdminContent 53GB ...
3
votes
2answers
203 views

How can I create a web part for add update and delete operations?

I'm new to SharePoint and I'm working with web parts. I have learned how to create a basic webpart and how to deploy it...but I don't have any ideas about how to create a web part that adds updates ...
3
votes
3answers
912 views

Databases from 2 SharePoint servers on the same database server?

I've got 3 servers: - DB1 - SharePoint1 - SharePoint2 On SharePoint1 I've installed WSS, using DB1 as database. Now I want to install WSS onto SharePoint2 and use DB1 as database storage as well. ...
3
votes
2answers
55 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
2answers
80 views

How critical is it and how to monitor, measure and reduce SharePoint database fragmentation?

It is a well advertised best practice to configure maintenance plans for SQL databases forming the data layer of SharePoint deployments. How critical is it to monitor and reduce fragmentation of the ...
3
votes
2answers
83 views

Cannot access to the Central Administration. Permission problem with SharePoint_Config database

I have reviewed all posts related to my issue but nothing seems to work yet. I'm working with SHP2010 and I'm getting the classic: Cannot connect to the configuration database while trying to ...
3
votes
1answer
116 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
97 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 ...
2
votes
6answers
6k 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
3answers
3k views

How do I clean up missing server side dependencies from a “dirty” installation?

After a rather hasty (unavoidable) migration/reconfiguration of a SP 2010 Foundation box, I am left with an error in CA regarding a number of missing Features, SetupFiles, and WebParts. I redeployed ...
2
votes
2answers
2k views

Sample/Demo Database for SharePoint 2010

I'm looking for a sample/demo database for SharePoint 2010 in order to be able to demo SharePoint. Does anyone know of such a thing? Ideally it should have already created and populated lists and ...
2
votes
3answers
6k views

Move databases to another server

I have tried moving all databases to another server, but I forgot to change the default database server in Central Administration. From Googling it, I found out that stsadm or psconfig could help me ...
2
votes
5answers
5k views

Guidance on renaming the multitude of databases generated by SharePoint 2010

SharePoint 2010 appears to continue SharePoint 2007's tradition of automatically creating horribly named SQL Databases. Like many companies we have multiple farms and developer workstations connecting ...
2
votes
2answers
2k views

Increase number of content database for one site collection

I am using SharePoint 2013. Is there any way to create more than one content database for one site collection? Is there a way to increase the size limit of a content database using RBS or any ...
2
votes
2answers
609 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 <...
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
5answers
2k views

Migrating content from one content database to another

We have a content database on our live moss server. It contains one site collection with several sub-sites. I'm using the stsadm export command to produce a cmp file, then moving this to our test ...
2
votes
2answers
852 views

How do I access data in SQL via Sharepoint 2013?

I'm not a SharePoint developer, but I have developed some small ASP/VB.net web pages. Basically, prior to using SharePoint, I have developed a basic portal that pulls data (VB.Net) and sends it to ...
2
votes
1answer
45 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 ...
2
votes
2answers
154 views

Get default db instance

I'm writing web service which will be part of my sharepoint solution. This service will save and read some data from custom db which will reside on the same mssql instance as sharepoint. I'd like my ...
2
votes
2answers
916 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
62 views

unable to backup our sharepoint content database “Backup Database is terminating abnormally”

I want to backup our live Content Database, now i went to "Central aministration>>Backup>>perform backup",, but i could it find our content database. so i try running the following command on the ...
2
votes
1answer
33 views

How to populate Excel 2013 sheets in SP2013 library with data from Access database on SP2013?

I'm new to Sharepoint. I may not use the right terminology and sound like an idiot. Please be kind. (I'm a former JEE developer. I understand the basic concepts. Just not sure how to translate them ...
2
votes
1answer
1k 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?
2
votes
1answer
195 views

Storage Location of Installed Features

Are features installed on a site stored in any of the databases? I know the assemblies installed to the GAC from a .wsp are not, however are the features themselves stored in a database?