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

learn more… | top users | synonyms

14
votes
4answers
1k 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 ...
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 ...
11
votes
3answers
4k 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?
7
votes
3answers
2k 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 ...
7
votes
1answer
2k 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 ...
6
votes
1answer
91 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 ...
5
votes
3answers
1k 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. ...
5
votes
2answers
241 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 ...
5
votes
2answers
1k 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
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
438 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?
4
votes
5answers
13k 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.
4
votes
4answers
311 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 ...
4
votes
2answers
7k 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 ...
4
votes
2answers
11k 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 ...
3
votes
2answers
1k 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
460 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
115 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
156 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
101 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
3answers
4k 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
1answer
3k 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
194 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
727 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
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
2answers
70 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
1answer
45 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
59 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
3answers
2k 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
5k 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
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
1answer
30 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
132 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
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
1answer
206 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
122 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?
2
votes
2answers
72 views

SP2010 Display data from a database with List controls

What would be the best/easiest way to retrieve data from a database (Customer info) and display it on a custom page but with the controls of a list: like sort, filter, views and search in the list? ...
2
votes
1answer
242 views

MOSS 2007 to Sharepoint 2010 migration

Steps followed for Migration: Backup up of production database Create New Web Application on SP 2010 farm. Restore Production Database on SP 2010 Farm. Create Solution in SP 2010 with Name Space ...
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
94 views

Running code that creates a TimerJobDefinition outside of Central Admin

I have run into a problem several times now where I have developed a custom timer job, and I want my site collection administrators to manage the schedule of this job with a custom application page ...
2
votes
1answer
44 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
2k 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 ...
2
votes
2answers
2k views

Unable to complete this operation. Please contact your administrator

We are using one API SharepointImporter Tool to upload documents to a SharePoint Site. When we are uploading one archive file we are getting the following problem. Error: Unable to complete this ...
2
votes
2answers
632 views

Restoring SSP Databases from SP1 to SP2 server farm

Has anyone restored Shared Services Databases from SP1 Server Farm to a new SP2 Server farm? I don't want to lose user related information link My Links etc. I followed the DB attach method as ...
2
votes
1answer
293 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 ...
1
vote
6answers
3k 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
2answers
249 views

Need to access a database…what is the best/proper/recommended way

Here is the setup. I have a SQL Server database that i need to query. I want to display the information in a Telerik/Devexpress chart control on either an application or site page. Here is what i ...