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
4k 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
77 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
151 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
148 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
70 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
119 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
69 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
51 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
601 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
187 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
354 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
511 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
1k 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
33 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
669 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
118 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
2k 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
540 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
753 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
461 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
449 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
782 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
301 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
280 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
787 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
301 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
292 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
956 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
193 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
345 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 ...
3
votes
4answers
4k views

Claim SQL server space after content deleted from SharePoint

We have a site collection with its own database where we have been testing migration of a department's shared drive content (about 40GB) via a third party tool. The test migrations went fine. Before ...
0
votes
1answer
114 views

What happens to content if you remove content's dependency?

Dependency may not be the right word here - but basically my question is regarding what happens to the data inside a sharepoint content database if that data was created, for example, by using a ...
0
votes
2answers
698 views

SharePoint 2007 -> 2010 upgrade content database size currently over 100GB

I've got a site which has a 2007 content database around 165GB at present they're running out of space on the SQL server so I'm just going to advise we move them all to a new SQL Server 2008 R2 ...
1
vote
1answer
169 views

How can I determine whether a content database is being used?

I noticed quite a few SharePoint content databases with random names (i.e. WSS_Content_30cb56f0b9eb430a8a2e3180604efd7b). I believe these were created by developers during deployment, and were never ...
0
votes
2answers
803 views

Applying wsp solution file to Sharepoint site collection programmatically

I am trying to deploy a sitecollection with a content database attached to each site collection. I was able to deploy site collections with individual content databases for each sitecollection, ...
0
votes
2answers
6k views

How do I update SP2010's database version?

I currently am in middle of migrating sharepoint 2010 site to another server. My current version of SharePoint server database says: Database Schema Versions ...
7
votes
2answers
2k views

SharePoint 2010 RBS and the 200GB content database limit

So "SharePoint Server 2010 capacity management: Software boundaries and limits" says about the 200GB limit: If you are using Remote BLOB Storage (RBS), the total volume of remote BLOB storage ...
3
votes
5answers
6k views

Content database shows no site collections

I accidentally removed one of the content databases from a web application. I mounted it back but now the content database shows zero site collections in it. I really messed up the production system, ...
2
votes
7answers
3k views

Failed to detect if this server is joined to a server farm

Hi As I said in one of my previous question, I have got a virtual Machine Image (VMWARE) for MS server 2003 with MOSS 2007 setup. Where they changed both IP and host name. Following problems I face ...
1
vote
1answer
206 views

Deleting Documents and implications on storage space

I have a need to generate documents and send them to a email address. Once the document has been sent I don't actually care about the generated document, oh and it has to be a document, formatted HTML ...
0
votes
1answer
605 views

CU October 2011 Invalid object name 'Webs'

I've runed the CU October 2011 and Sharepoint Configuration Wizard failed after executing, however the farm build version changed to: 14.0.6112.5000 as expected. In ULS i've seen error: Invalid name ...
1
vote
1answer
633 views

Restore of content db fails to restore top-level site collection

I have a backup of a content db restored to Sql server as WSS_Content_Live I have a brand new SP installation setup with AutoInstaller, so we have a port 80 web site called Portal Home. I have ...
2
votes
1answer
2k views

Office web apps does not have access to content database

I have issues with Office Web apps. After some logging search I found it's because of the service account of owa service application does not have access to the content DB. I've read somewhere that ...
2
votes
3answers
619 views

Large content database

My client has been on MOSS 2007 for nearly 3 years. We're about to do an upgrade to 2010 on their system and found their content database to be around 350Gb in total. This to me seems a bit ...