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

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
1k 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
382 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
322 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
907 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
344 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
323 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
196 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
407 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
5k 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
117 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
783 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
199 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
1k 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
7k 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 ...
8
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
8k 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
232 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
714 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
725 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
701 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 ...
6
votes
3answers
5k views

Content DB Split - Sub-site into Site collection is the only way? And How?

Our sharepoint database is large ~180GB. I want to split it up into smaller database from the disaster recovery point of view & also that it can be easily moved across servers. The problem is that ...
8
votes
2answers
2k views

The best practice for moving content database between two farms

I have two farms both running SharePoint 2010 and SQL Server 2008 R2, basically something like a development environment and a production environment. I have a site running on web app - port 80 and it ...
1
vote
3answers
3k views

Content Database showing 0 (zero) site collection after content database attach

I have two server farms, Server farm 1 and Server farm 2. Server farm 2 runs SharePoint 2010 Enterprise with SQL Server 2008 R2 Enterprise and Server 1 runs SharePoint 2010 Enterprise with SQL Server ...
10
votes
3answers
9k 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 ...
3
votes
5answers
2k views

Why can't I create site collections in some CDBs?

I currently have my SharePoint 2010 server set up with twelve content databases. In each is or should be one site collection at the moment, but as I went through to set up each one five of them gave ...
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 ...
5
votes
1answer
819 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 ...
1
vote
1answer
632 views

Changing the user account of the SharePoint applicaton pool returns the error “Cannot connect to the configuration database”

I am trying to debug an issue regarding the proxy setting in web.config. Currentley it is set to: <system.net> <defaultProxy enabled="true" useDefaultCredentials="true"> ...
1
vote
2answers
2k views

Database Attache Upgrade Fail?

I ran the mount-spcontentdatabase and it failed. The test-SPContent Database didn't produce anything in the log that would fail the upgrade. Also, the error report didn't have anything that would ...
0
votes
1answer
534 views

Migrating document libraries from SharePoint 2007 to SharePoint 2010

I need help in my migration process. First I have a test environment which is configured for SharePoint 2010 and I need to migrate a web application from SharePoint Server 2007 to SharePoint 2010 ...
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
1answer
789 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
5answers
5k views

The web application at [url] could not be found

Any ideas on the error below? This happens when I try to search for content on my WSS 3.0 site. ERROR " The web application at [url] could not be found. Verify that you have typed the url ...
1
vote
1answer
1k views

How to design for large content databases?

Although single content databases of upto 200GB is possible in Sharepoint 2010, administering and managing such a db would be a nightmare. What would you suggest for options in a case where there is ...
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 ...
7
votes
1answer
3k 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 ...
0
votes
2answers
264 views

Which database holds documents?

I am wondering which database holds documents? I know that the documents are held as BLOBS in the database itself, but I can't seem to figure out what database that is?
0
votes
4answers
8k 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 ...
5
votes
5answers
14k 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.
2
votes
1answer
244 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 ...
0
votes
1answer
151 views

Completely empty content database

Anyone come across the following issue? WSS3 installation using WID, the content database for the site was empty. All of the tables were there but each table was empty, AllUserData, Sites, etc. Allll ...
2
votes
1answer
642 views

404 Error after Deleting Content Database (With no Site Collections)?

After detaching a database in SharePoint then subsequently deleting in SQL Server I have been getting 404 Errors at my root site collection default.aspx page, and a few other random site collections ...
2
votes
3answers
935 views

Where do you deploy scripts that are loaded in a masterpage?

Do you deploy the script files to "_layouts" or the content database? If "_layouts," do you use a <ScriptLink> tag or a <script> tag?
6
votes
2answers
5k views

Deleting an orphaned content database

I had accidentally deleted a content database "CDB-A"(not important) without doing a detach. I also added a new content database "CDB-B" to the web application. SP 2010 seems to hang on to "CDB-A" ...
1
vote
1answer
2k views

Mounting two similar content databases

I have two content databases: Cdb_A (in Server_A) and Cdb_B := Cdb_A + (a lot of content changes) in Server_B. Im trying to host both in the Server_A but on different webapps. My Webapp_A is attached ...