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

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
287 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
1k 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?
1
vote
2answers
9k 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
4k 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
190 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
2k 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
509 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
98 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
160 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
81 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
62 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
1k 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
285 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
634 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
985 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
38 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
3k 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 ...
1
vote
2answers
8k 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
138 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
2answers
2k 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 ...
1
vote
1answer
3k 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 ...
8
votes
2answers
3k 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 ...
1
vote
2answers
440 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
3k 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
869 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
1k 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
381 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
425 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
370 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
200 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 ...
9
votes
3answers
6k 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 ...
3
votes
4answers
6k 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 ...
1
vote
1answer
225 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 ...
2
votes
7answers
4k 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
3answers
4k 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 ...
1
vote
1answer
265 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 ...
2
votes
3answers
767 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 ...
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
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 ...
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 ...
1
vote
1answer
718 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"> ...
0
votes
1answer
154 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
259 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 ...
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 ...
0
votes
1answer
66 views

Need sharepoint data related answer

How list/library data stored in sharepoint How/Where Document are saved in sharepoint Where configurations are saved in sharepoint
8
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
298 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?