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

9
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 ...
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
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 ...
7
votes
9answers
2k 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 ...
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 ...
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 ...
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" ...
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.
5
votes
1answer
803 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
2answers
58 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
44 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
621 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
1answer
40 views
+50

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 ...
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 ...
3
votes
1answer
209 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
3answers
327 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
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
104 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
5answers
7k 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, ...
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 ...
3
votes
2answers
88 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
475 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
102 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
1answer
76 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
136 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 ...
3
votes
1answer
3k 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: ...
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 ...
2
votes
2answers
899 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
3answers
918 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?
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 ...
2
votes
3answers
139 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
1answer
77 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
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
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 ...
2
votes
2answers
73 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
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 ...
2
votes
3answers
694 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
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 ...
2
votes
1answer
41 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
2answers
265 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 ...
2
votes
1answer
799 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
171 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 ...
2
votes
2answers
3k 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 ...
2
votes
0answers
42 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 ...
2
votes
0answers
831 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 ...
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 ...
1
vote
2answers
45 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 ...
1
vote
2answers
376 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 ...