A Content Database is an SQL Server database where the content of a SharePoint intranet (extranet, public web) is stored.

learn more… | top users | synonyms

0
votes
2answers
112 views

SharePoint performance

We have a SharePoint application which works fine in the beginning. Now it takes more time to load the page and i am getting error page manytimes. When i check on that error, i found the reason as SQL ...
0
votes
0answers
76 views

Move sharepoint list data to db table

I have sharepoint application which takes more time to load. So i planned to move data from certain list to another table in same database. Since alluserdata table in sharepoint stores data from all ...
0
votes
1answer
115 views

Access to Sharepoint DB

I have installed SharePoint Foundation 2010 Foundation in Single mode. At installation a local db service was created at .\sharepoint and I haven't got permission on the databases to create a database ...
1
vote
1answer
748 views

Are big Content DB's really that bad? [closed]

I am creating a site collection with 6 subsites holding 1 document library each. We are migrating documents from an existing platform, somewhere around 300 000. The seperate sites represent a category ...
0
votes
1answer
417 views

What is the meaning of [DocStreams].[Partition]?

Looking inside [dbo].[DocStreams] table (which holds files stored on sites) in SharePoint 2013 content database, does anybody know what a [Partition] column is and when does it become relevant? It's a ...
1
vote
1answer
1k views

Splitting large size content database

One site collection has large size content database Want to split large size content database into smaller pieces to make each lower than 80 GB. I saw on reply which seems to be realistic. any other ...
1
vote
1answer
156 views

Any way to determine what web application a content database was last attached to?

We are currently doing a 2010->2013 DB migration and attaching content databases back and forth. During the course of the migration I lost some notes on which content database belonged to which web ...
2
votes
2answers
248 views

Remove mysite links from migrated site collection sharepoint 2010

I have migrated a content database to a different server and attached it to a fresh web application. Now my issue is whenever it points to old site where users had created their own site. i don't want ...
0
votes
1answer
388 views

Move Site Collections Based on Content Database

I have a content DB which is growing huge and so I want to move Different Site Collections to Different Content Databases based on the Managed path that Site collection belongs to .Can some one Help ...
0
votes
1answer
284 views

SP central admin Cannot connect to the configuration database after reinstalling sql server 2008 r2

I have just re-installed SQL Server 2008 R2 in my Windows Server, but after installing the SQL Server, I am unable to open my central admin. On opening the central admin its showing me the message - ...
1
vote
2answers
214 views

SharePoint 2010 - To use content database or not to use

SP newbie here. I need to build a SharePoint 2010 application to track customer support cases. This will be the first time we've used SP, and I can set it up how I please. The built-in template for ...
3
votes
1answer
76 views

Architecting a department site with 2 TB+ of data

We are looking at the possibility of migrating 2TB+ worth of data from our network driving into SharePoint for a department site. For this question I'm assuming all data is valid and has the ability ...
2
votes
1answer
689 views

SharePoint 2010 - moving databases to new server & RBS

Our SQL cluster has some issues and techs are now building another cluster where we will have to migrate our SharePoint 2010 farm. I found technet article describing process of moving SharePoint ...
0
votes
1answer
55 views

Removing old content databases cleanly

I have created and deleted a web application without specifying to remove the content database. What is the cleanest way for me to delete the content database?
0
votes
2answers
5k views

SharePoint configuration and content databases

Can 2 servers in SharePoint farm have their own SQL server database? Or they must share database? because when I was installing second server in farm it said that servers must share config database. ...
3
votes
1answer
94 views

Sharepoint 2010 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 ...
0
votes
1answer
159 views

Creating a file programmatically that has a specific ID

Is this remotely possible? I am trying to correct some orphaned entries (specifically webparts) in the content database's AllWebparts table (they have PageUrlIDs but no corresponding entries in the ...
2
votes
2answers
159 views

Cannot find pages that have instances of missing webpart

I am trying to fix some missing server side dependencies on an SP2010 farm and am having trouble with missing webparts. There are two problems specifically. 1) Of the pages I can find (two pages ...
0
votes
3answers
1k views

How to Remotely Access SharePoint Database

I haven't used SharePoint a great deal, but I have worked with other database systems. If I have a table in a SharePoint site, how can I connect to it and issue a database query in a similar fashion ...
1
vote
1answer
75 views

Content DB not getting any permissions on web application created through central admin

I tried to create a Web Application using Central Admin. It created web app without displaying any error, I can browse site too after creating site collection and that, but content db got no ...
3
votes
1answer
132 views

Checking if the content database is in read-only using javascript?

Hi I'm pretty new to SharePoint and javascript. I am trying to check if the content database is read-only, and if it is then preform a function eg. if ...
2
votes
2answers
72 views

Web site looks different after content db addition to a different farm

I backed up a content db from our production MOSS 2007 farm and then I added to an existing web application to the recovery wss 3.0 farm. However after doing it, the root site from the new db's site ...
0
votes
1answer
55 views

Pre Requesties for wss-kb981043-fullfile-x86-glb.exe

I updated my Machine with MOSS service pack 2 and trying to install wss-kb981043-fullfile-x86-glb.exe but it's giving error, not sure what am I missing however I am getting different exception ...
0
votes
0answers
681 views

Error while attaching content db to a different server

I got back up of content db from a demo server and trying to attach it to a newly created web application in my personal copy of same demo server but not up to date. however I am getting this error, ...
0
votes
1answer
218 views

Site Columns and Content Type missing

My task is the create a replication of a live site collection on a pre production server after the move none of the site collection Content type or site columns are listed. So far I have copied the ...
1
vote
1answer
409 views

restoring content databases and retaining permissions

I have a production Sharepoint web app that contains several content databases serving a group of site collections. There are some critical files in a group of document libraries and lists, so ...
1
vote
2answers
1k views

Content Database Is Not Listing In SQL Management Studio

I have created a new SP web application and the content database name which I have given is WSS_Content_Test. Application created successfully(I checked out and found IIS Website and App pool is ...
1
vote
2answers
640 views

Mysite fails after changed content database?

I have a test environment which has a different URL and a different database server than the production environment. I’ve taken a backup of the production content database of mysite and attached it to ...
1
vote
1answer
2k views

“a duplicate content type '<content type name>' has been found” error message

I have just upgraded customer environment to SharePoint 2010. I have been having minor issues with content types of which some I managed to resolve except the following one: We have a SharePoint 2010 ...
2
votes
1answer
2k views

“No connectivity with the server” for files in only one content DB?

SharePoint 2010 / SQL Server 2008 R2 One of my users reported a problem opening files yesterday. Upon opening a file she would receive this string of error messages: Clicking "Retry Open" leads to: ...
1
vote
0answers
35 views

Geting added or deleted users from SPContentDatabase

I am trying to get changes from a content database. Below is the code I have used to get the changes, but I get zero results. How to make it work? SPChangeQuery query = new SPChangeQuery(false, ...
2
votes
0answers
767 views

Create a new Central Administration Content Database

Currently the Content Database for my Central Administration site has exploded to over 50GB, and expands to over 100GB everynight (leaving 50GB of free space). After much investigating I have ...
0
votes
1answer
124 views

Content Database size for SharePoint 2010

I am trying to Detach an existing content db from my sql server by deleting its .mdf, .ldf files and while I am trying to add new content db (which I got from other server) whose size is 50 GB my sql ...
2
votes
2answers
3k views

How to Restore Same Site Backup in Same Content DB to create another site collection in the same web application?

I have a site backup and i want to create two site collection from that backup in one web application.when i try to restore second site collection on same web application it restrict me to do so.As ...
4
votes
1answer
585 views

Can't restore backup of content database using stsadm after migration to SQL 2008 R2

WSS 3.0 on Server 2003 within a Domain. I set the server up 3.5 years ago along with a test setup. It's the first and only SharePoint install. I recently had to migrate the content database from ...
0
votes
2answers
971 views

Run timer job on a single content database using SPJobLockType.Job

I have developed a custom timer job, inheriting from SPJobDefinition. It currently runs on two content databases, and I would like it to run on only one. I have created this timer job using the ...
0
votes
1answer
546 views

New-SPContentDatabase creates database with guid instead of name

I am quite new to Sharepoint and I have a question that has been bugging me for a few days now. I have a powershell script that is setting up some site collections in a Sharepoint webapplication I ...
1
vote
1answer
2k views

Copy content database from production to development environment

I have a production SharePoint 2010 server with multiple site collections and sometimes I would like to copy the content from the site collections into my development environment so that I can test my ...
1
vote
1answer
574 views

Host Named Site Collections with own Content DB, and problems (Top Nav Bar, and force to log on always)

This is the scenario: I. All Site Collections have thier own Content Database II. Site Collection A is Root Site Collection (created directly under Web Application = has exact same url as Web ...
1
vote
3answers
2k views

Restoring a Document Library's content from a backup?

I have a sharepoint server backup and a database backup of the SQL2008 server which holds the sharepoint database. Some infopath forms were deleted from the document library and I would like to ...
2
votes
2answers
970 views

Copying a Content Database to another Farm?

I have a Sharepoint Farm and I want a clone of it, under a different hostname (Preprod vs. prod). We setup the Preprod farm from scratch, with new Web Applications. We then restored a backup of the ...
1
vote
2answers
349 views

What is the Best Method to Store 100s of Thousands of Files in SharePoint 2010?

My question is: What is the best method for storing thousands of files (or millions) in SharePoint? Every file's size is about: 5 MB * 1000000 = 5 TB I need the best method for that that does ...
2
votes
2answers
2k views

Mount-SPContentDatabase error

I have recieved a copied database from a live farm and am trying to restore this database to my development environment. I have created a new web application and site collection and have restored the ...
1
vote
2answers
310 views

Record Center and Content Database Infrastructure

I've ask yesterday about Document Libraries limits and the only thing that we have certain is that Microsoft recommends Content Databases <= 200gb. I'm facing a situation here where I'm setting ...
2
votes
2answers
859 views

Should I regularly backup and shrink my content databases through SQL?

I've been contending with hard disk space on my SharePoint 2010 (with SQL 2008) environment for a while and I've just recently found out a few things that I think might help. Should I be regularly ...
1
vote
0answers
321 views

Database Statistics Timer Job got hangs on initialized state

Env: MOSS 2007 SP2 64 bit architecture, 4 wfe and1 app server, wins server 2003, Sql 2005 . I have a site collection in web app which is reached 50 GB. Due to this, the Site collection is not ...
1
vote
1answer
313 views

Is it possible to run Content Deployment incrementally using code?

I am running some Content Deployment jobs using the code but the jobs are not run incrementally, instead they are run by exporting all the objects. Is it possible to run them incrementally using the ...
1
vote
2answers
1k views

Where is the data from content editor web parts stored?

I'm in the process of developing a few page layouts. I can map certain TextEditor's and RichHTMLEditor's fairly simply - and the concept of the data found in these controls being saved to a field is ...
3
votes
1answer
195 views

Remote BLOB Storage and Sharepoint 2010

I have a SharePoint Server 2010 documents library. Library's size - 20 Gb. Size increases each year by 1-2 GB. It stores files ranging in size from 1 to 50 MB. Files rarely change. Should I use the ...
0
votes
1answer
381 views

How to store documents/images/video on a different server in sharepoint 2010

Currently I'm using SharePoint 2010. The sites and sub-sites are stored on the C drive. Since, this SharePoint site is going to have a large amount of documents, images, and videos I would like to ...