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

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, ...
4
votes
1answer
718 views

How to remove “orphaned” users from a site collection?

We recently performed a domain migration where we migrated several forests and domains into a single domain. From speaking to the AD admins, this was done using a tool from Quest and it maintained SID ...
0
votes
1answer
476 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
0answers
74 views

How to get SPContentDatabase object knowing only server and database name

I would like to retrieve SPContentDatabase object that corresponds to a specified server and database name (i.e. same that is specified in SqlConnection). Specifically, I would like to retrive ...
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
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 ...
0
votes
1answer
286 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
109 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
181 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
301 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 ...
3
votes
1answer
71 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 ...
0
votes
1answer
229 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 - ...
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 ...
2
votes
2answers
2k views

Programmatically create a site collection in an existing, mounted content database

I'd like to create a site collection from a custom application page in central admin. The administrator needs the option to specify an existing, mounted content database to store the new site ...
1
vote
2answers
190 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 ...
2
votes
1answer
471 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 ...
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
1answer
53 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
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
8
votes
3answers
7k views

Restore-SPSite to the same content database

I ran Restore-SPSite on my server from a backup. I then deleted the site collection and did it again but got the following error: Restore-SPSite : The operation that you are attempting to perform ...
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
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, ...
1
vote
3answers
2k views

NullReferenceException when creating new site collection

Running a SharePoint 2010 farm. Whenever I attempt to create a new site collection I get the following error "Object reference not set to instance of an object" which is generated from a generic ...
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
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 ...
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 ...
0
votes
4answers
6k views

Restore-SPSite failure due to insufficient Content Database Space

I hope someone can help me solve this weird problem I'm facing for 4 days. I'm trying to restore the backup of Sharepoint 2010 web application. I'm using Windows Powershell command : Restore-SPSite ...
0
votes
2answers
757 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 ...
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 ...
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
1answer
661 views

Upgrade from 2007 to 2010 error on custom web parts

We have several SharePoint 2007 farms with several site collections in certain databases. The desire is to be able to migrate these 2007 site collections to our new 2010 farm envirionment. The best ...
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
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 ...
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 ...