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
1answer
18 views

Database Update Status “ Needs Upgrade” Sp2013

I am in the process of upgrading sp2013 farm to SP1 upgrade soon. To prep for that i was going though datbase status page in central admin and saw the following: With that info on hand i was ...
1
vote
2answers
27 views

RBS Sharepoint 2013

I Enabled RBS on our SharePoint farm using the tech net article (http://technet.microsoft.com/en-us/library/ee748631(v=office.15).aspx) and i was able to successfully test the RBS for one content ...
1
vote
1answer
20 views

What is diffrence between SPContentDatabaseSequence and SPContentDatabaseSequence2

When i am inside Mange Content Database settings page inside my farm, i see 3 different Schema Version for my content db as follows: I understand the first listing that is ...
1
vote
1answer
16 views

SharePoint 2010 Visual Upgrade Required Pre-SharePoint 2013 Upgrade?

When upgrading to SharePoint 2013, should the SharePoint 2010 content database have all site collections using the 2010 Visual Upgrade? We currently have a few sites that are still running on the 2007 ...
1
vote
0answers
17 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
42 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 ...
0
votes
2answers
50 views

Use a single content database on two web applications

Can we use a single content database on two web applications in SharePoint 2007? I created a new application and a site collection. I want to use my old (existing) content database on the new web ...
1
vote
1answer
20 views

How do I restore a WSS3 Site with just the Content DB?

I am dealing with a system crash where I had a WSS3 site in a DMZ with a SQL2005 server remote (inside the Domain). The Web Server and the SQL server both were taken out is a system failure. I was ...
1
vote
2answers
18 views

Distribution of SiteCollections

I have the following scenario: 1 Content database 1 Webapplication with 28 Sitecollections The Size of this content database is about 100 GB. So I want to distribute newly created ...
0
votes
1answer
25 views

stuck on a database attach

I have a 2013 test box that I am working on trying to attach a content DB from our 2010 farm. I have mounted the WSS_Content database on the new server. I have made a web app and a site collection ...
0
votes
1answer
17 views

How are additional fields stored in a lookup column?

When creating a lookup column it is possible to select additional fields. Does SharePoint store the values of these additional fields in the "child" list, or is a database join performed every time a ...
1
vote
0answers
12 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 SQL queries results in an unsupported state. However, it is possible to develop custom RBS providers. Note that when an item is ...
0
votes
1answer
42 views

Local farm is not accessible, cmdlets with featuredependencyid are not registered

So after moving all my databases to the new SQL server I run this on my SharePoint central admin box, http://technet.microsoft.com/en-us/library/cc512725(v=office.15).aspx#Man Everything goes through ...
0
votes
2answers
39 views

How can I know in which content database my site collection is stored?

I have a farm and I see in sql many content databases. I have some site collection and would like to find something in the userinfo table in the sql database. But in which content database do I need ...
0
votes
1answer
24 views

addcontentdb command missed something

So I have built a new sql 2012 server and SharePoint 2013 server. I have added the new SharePoint server to the farm and made it the default central admin site. I have moved all the content ...
0
votes
1answer
88 views

SharePoint content database DocStreams table very large

We recently migrated our SharePoint 2007 instance to 2013 using a migration tool. I noticed the disk space for 2013's database partition (300GB) on our SQL Server was running low. I ran a SQL report ...
0
votes
1answer
37 views

SharePoint Content Databases with PowerShell

Is there a way to get the current maximun number of site collections from a current database, and then be able to increase this by 1. I want to do this specifically in PowerShell for SharePoint. ...
0
votes
0answers
21 views

Two content databases for the one SharePoint application. Can I kill one?

I have an old SharePoint 2007 Sub-Site migrated across to my SharePoint 2010 environment via the DB Attach method. I've noticed that whoever did the DB attach has brought over 2 copies of the Database ...
0
votes
2answers
250 views

2010 Moving Content DB to new Domain - Problem with Users

I am restoring a content database to a new farm in a new domain. I have used the Move-SPUser command to map as many users over that exist in the new domain. I've used the delete orphan script to ...
0
votes
1answer
33 views

ContentDatabase exceeds storage limit

I have a SharePoint Site with only one existing contentdatabase. In this site are severa sitecollections. At the moment I am not far away that I reach the limit of 200GB for this database. My ...
3
votes
1answer
204 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?
0
votes
1answer
132 views

Documents / Library missing after migrating My Site to the new Content Database

I've moved some My Sites to new content database with the powershell cmdlet Move-SPSite. However, after moving them, it appears documents were "lost" on some of them (most of sites is just fine). When ...
1
vote
1answer
64 views

I want to know where are the timer jobs, webparts and user controls saved?

Are they saved in the content db or Layouts folder?
0
votes
1answer
88 views

Where are List View definitions stored?

Where can I find the raw definition within the Content database of a View on one of my Lists. I've found the list in AllLists and the View, I think, in AllDocs. But from there the trail is cold. I ...
0
votes
2answers
33 views

Pre installing solution doesn't solve the issue with the pre attach test

I want to attach a database to a newly created web application. I have a database which is correct. I execute the PowerShell script: Test-SPContentDatabase -Name ContentDB -WebApplication ...
0
votes
1answer
44 views

Does the entire web app or the entire site collection reside in a content db?

MSDN article paragraph: All sites in a site collection are stored together in the same SQL database. Keep extremely active sites in separate site collections. Because all content in a ...
0
votes
0answers
237 views

Error on Upgrade to sharepoint 2013

I'm trying to upgrade a webApp from 2007 to 2013. Following this tutorial: Tutorial The migration process to 2010 works perfectly . But When I try to do the same process to 2013, it breaks on 30% ...
1
vote
2answers
291 views

New-SPContentDatabase vs Mount-SPContentDatabase

We pre-create our SharePoint content databases in SQL, so we can distribute database files among disks and tune some parameters on the SQL Server side. Then we convert the SQL databases into ...
0
votes
1answer
39 views

Can I detach/move a DB by just stopping the site rather than fully shutting down IIS on the WS

On my SharePoint 2010 Farm and Web Server. I have a number of Different sites. Prod SharePoint, MySite, a separate ContentType Hub, and an attached DB of a 2007 Site. I want to move the Content DB of ...
0
votes
1answer
72 views

Single web application or mulitple?

I am very new compare to experts here. I have read several articles and discuss forums. However I am worry there are some potential risk I cannot foresee. Could you give me some suggestion on the wb ...
0
votes
0answers
20 views

ECM best practices

How to handle multi-terrabyte content in SharePoint? Which is the best approach for handling this scenario a) Creating multi site collection and with separate content db b) Externalizing the content ...
3
votes
2answers
82 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 ...
4
votes
2answers
55 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 ...
0
votes
1answer
41 views

SharePoint Content DB

In SharePoint 2010 and 2013 when does the content DB get created? Is it after you create web application or is it after you create site collection? In SP2013, since each site collection can have its ...
2
votes
1answer
72 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. ...
0
votes
1answer
38 views

Backup/Restore which content database?

I have seen a few posts about backing and restoring SharePoint content databases from both Central Admin and using PowerShell. My question is relatively simple I hope..... There are a number of ...
3
votes
1answer
103 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
0
votes
0answers
65 views

Where is stored the country property from user profile?

In which database can i find the country property from user profile in sharepoint 2010?
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 ...
0
votes
2answers
95 views

How to manage text modules (boilerplates) with Sharepoint?

I want to manage boilerplates/text modules in SharePoint. Text modules are content snippets, which may appear on multiple sites, but are only stored once. When the source is changed, all references ...
2
votes
1answer
38 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 ...
0
votes
0answers
42 views

InfoPath forms and some services do not work after database restoration!

Last they some of my SharePoint server databases stuck in restoring state. After I solved those databases issue. Now some of my SharePoint features do not work. For example Infopath forms can not be ...
0
votes
0answers
26 views

Sharepoint 2010 databases are in restoring state

I have a single server in my SharePoint 2010 server farm. Today some of users complained about that some of Infopath forms can not be opened. When I checked the SOL Server Management Studio I saw that ...
2
votes
3answers
130 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 ...
0
votes
1answer
70 views

Re-upgrading the same content database SharePoint 2013 upgrade

I have a question more than an issue, I have a scenario where I perform a database attach content DB migration and this works out OK, then the site goes into a period of UAT and after a week or so ...
3
votes
3answers
280 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: ...
0
votes
1answer
539 views

Orphan Site Reported After Running Test-SPContentDatabase

I'm upgrading from 2010 to 2013 and when I ran the Test-SPContentDatabase (on destination WFE server pointing at original content DB) command I got the following error relating to an orphan site: ...
1
vote
2answers
710 views

moving content db for a site collection to another db server

Is it possible to move a content database from one db server to another db server? I read an an article stating it's not possible you can move contend db within the same database server. Can anyone ...
1
vote
1answer
560 views

Sub site with own content database

We have one site collection with many sub sites in one content database. Now we wanna "split" the content into more content databases. Is it possible to "move" the sub sites into a new content ...
1
vote
2answers
36 views

How to migrate SP07 content to SP13 for our end users

I work for a law firm and we are going to be upgrading to SP13 next year, we are looking for an effective/efficient way to move our end user's content from 07 to 13. Has anyone done this recently or ...