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

11
votes
4answers
12k 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 ...
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 ...
8
votes
9answers
7k views

Content database size vs site collection size

We have one rather large content database in our environment. In this content database, a single site collection resides. In Central Admin, this site collection lists as being 464699 MB big. Since ...
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 ...
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 ...
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 ...
7
votes
5answers
12k 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, ...
6
votes
2answers
6k 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" ...
5
votes
5answers
18k 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.
5
votes
1answer
1k 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 ...
4
votes
4answers
7k 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 ...
4
votes
2answers
106 views

Single Site Collection growing above 200 GB limit

What is the recommended approach when a single site collection (on a Content Database) is growing above the 200 GB limit? All files are stored in the same site collection, within different sites and ...
4
votes
1answer
46 views

Are SharePoint sitepages related to performance problems?

SharePoint stores customized site pages in the content database. So, suppose there are 1000's of pages which are created and modified by users (say by adding webpart), some are created and modified ...
4
votes
1answer
122 views

Does writing a custom RBS provider force one to put SharePoint into unsupported state?

It is well known that modifying a content database directly by running direct SQL queries results in an unsupported SharePoint state. However, it is possible to develop custom RBS providers. Note that ...
4
votes
1answer
780 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 ...
4
votes
0answers
686 views

The UPDATE permission was denied on the object 'AllListsAux', database 'spContent', schema 'dbo'

Insufficient SQL database permissions for user 'Name: NT AUTHORITY\IUSR SID: S-1-5-17 ImpersonationLevel: Impersonation' in database 'spContent' on SQL Server instance '###' The UPDATE permission was ...
4
votes
1answer
4k 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: ...
3
votes
3answers
2k views

How to delete an unused content db in SharePoint

Error: Databases required upgrade or not supported : The following databases require upgrade because their versions are older than the backwards compatible range: ...
3
votes
3answers
1k 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?
3
votes
1answer
258 views

Is accessing SharePoint content Database in code advisable?

I want to know if it is a correct thing to access SharePoint content database in code i.e (using custom SQL queries)? If not can anyone provide me with an explanation why shouldn't it be done?
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 ...
3
votes
1answer
119 views

How to check whether Content Database is read-only or not?

How to check whether Content Database is read-only or not using client context ? we can easily get using server object model but how to do this with Client Object Model
3
votes
1answer
204 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 ...
3
votes
2answers
186 views

Issue Mounting SharePoint 2010 content database in 2013

I'm in the middle of an upgrade from 2010 to 2013, and I'm running into an issue when attempting to upgrade one of my content databases using PowerShell. The content databases attached to my other web ...
3
votes
2answers
687 views

SharePoint 2010 - Automatically create a new content database when a size is reached

I've been asked a question today regarding the automatic creation of a new content database when the current one reaches a certain size limit. Does anyone know if this is possible? Possibly with a ...
3
votes
1answer
172 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 ...
3
votes
3answers
64 views

How much space in the DB will be saved by using RBS?

We are doing a migration from SP 2010 to 2013. We are going site by site (moving content databases to a new server). Some of the content databases are over 200GB, from what I can see mainly due to ...
3
votes
1answer
80 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 ...
3
votes
1answer
179 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
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 ...
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 ...
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 ...
2
votes
2answers
175 views

copy a SP 2010 site collection from prod to dev

We are trying to copy a SP 2010 site collection from our prod environment to dev. The site collection has it's own content db. Is it possible to just make a backup of the prod content db, restore it ...
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 ...
2
votes
3answers
337 views

SP 2010 Modifying the “Last Modified By” column in SQL Management Studio

Let me preface by saying that I have read this page by Microsoft: http://support.microsoft.com/kb/841057/en-us I have not understood it completely which is why I am here, We are currently in a tough ...
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 ...
2
votes
2answers
75 views

Microsoft.SharePoint.Publishing.InvalidPageLayoutException after moving site collection

I have two web application: http://old.corp.com http://new.corp.com I had a site collection on http://old.corp.com/path/1. The site collection was in a dedicated content database and is based on a ...
2
votes
1answer
167 views

Change web application's content database

Is it possible to configure my existing SharePoint 2010/2013 web application to point to a new/existing content database residing on another database server? If yes then how could I do it.
2
votes
1answer
134 views

Migrating SharePoint Content database from 2010 to 2013

Source Environment: 1.) SharePoint 2010 2.) 1 site collection 3.) 8 sites in that site collection. The requirement i have is to move the site collection along with all the data from 2010 to 2013. ...
2
votes
1answer
3k 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
1answer
35 views

Conditions in which SP Content DB gets locked

Apart from Content Database backup, what are the other conditions in which a SharePoint Content Database may get automatically locked?
2
votes
2answers
182 views

Unable to restore PRODUCTION content database to DEV content database farm

I am trying to refresh my dev farm content database with a copy of the production farm content database, but I have been unsuccessful so far. I used the following procedure: 1) stopped the ...
2
votes
2answers
83 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 ...
2
votes
2answers
2k 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 ...
2
votes
3answers
790 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 ...
2
votes
5answers
6k 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 ...
2
votes
1answer
260 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 ...
2
votes
2answers
115 views

Access denied while creating content database from event receiver

I have created one timer job which will add SharePoint content database. When I am running timer job manually from central admin, Content database is being created successfully. Now I have one list ...
2
votes
1answer
108 views

Can a content database upgrade be stopped and resumed?

When you run the SharePoint management shell cmdlet Upgrade-SPSite -VersionUpgrade to upgrade a 2010 database to 2013 it can take a really long time, sometimes days. Suppose you experience a power ...
2
votes
3answers
3k 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 ...