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
1answer
155 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
31 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
54 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
37 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
20 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
28 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
42 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
34 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
26 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
31 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
15 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 ...
2
votes
2answers
48 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
40 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
31 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
44 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
28 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
88 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
25 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
521 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
62 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
31 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
27 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
25 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
82 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
36 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
133 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
263 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
134 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
297 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
33 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 ...
1
vote
0answers
15 views

Switching Content Database caused data migration

I experienced something very strange with my development machine today, and want to ask all the SharePoint experts out there. In my development environment I had a content database, this one is quite ...
0
votes
1answer
53 views

Is it possible to specify content database name while creating the Excel Service Application using powershell script?

I want to create the Excel Service Application as it is required to use the Excel Web Access Web Part. Firs I tried to create the application using sharepoint but GUI not providing facility to specify ...
1
vote
2answers
222 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 ...
0
votes
1answer
104 views

User permission from Content database

I am having copy of content database from client. Now i need to find permission level for particular user using SQL query. Is it possible?
0
votes
1answer
112 views

Point another content database from Site Collection

I am having site collection with its own content database in development and production environment. Now i am facing some issues in production side. I tried to take site backup and restore it in ...
0
votes
2answers
91 views

SharePoint performance

We have a SharePoint application which works fine in the beginning. Now it takes more time to load the page and i am getting error page manytimes. When i check on that error, i found the reason as SQL ...
0
votes
0answers
67 views

Move sharepoint list data to db table

I have sharepoint application which takes more time to load. So i planned to move data from certain list to another table in same database. Since alluserdata table in sharepoint stores data from all ...
0
votes
1answer
73 views

Access to Sharepoint DB

I have installed SharePoint Foundation 2010 Foundation in Single mode. At installation a local db service was created at .\sharepoint and I haven't got permission on the databases to create a database ...
0
votes
1answer
476 views

Are big Content DB's really that bad? [closed]

I am creating a site collection with 6 subsites holding 1 document library each. We are migrating documents from an existing platform, somewhere around 300 000. The seperate sites represent a category ...
0
votes
0answers
74 views

How to get SPContentDatabase object knowing only server and database name

I would like to retrieve SPContentDatabase object that corresponds to a specified server and database name (i.e. same that is specified in SqlConnection). Specifically, I would like to retrive ...
0
votes
1answer
286 views

What is the meaning of [DocStreams].[Partition]?

Looking inside [dbo].[DocStreams] table (which holds files stored on sites) in SharePoint 2013 content database, does anybody know what a [Partition] column is and when does it become relevant? It's a ...
1
vote
1answer
999 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 ...
1
vote
1answer
109 views

Any way to determine what web application a content database was last attached to?

We are currently doing a 2010->2013 DB migration and attaching content databases back and forth. During the course of the migration I lost some notes on which content database belonged to which web ...
2
votes
2answers
181 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 ...
0
votes
1answer
300 views

Move Site Collections Based on Content Database

I have a content DB which is growing huge and so I want to move Different Site Collections to Different Content Databases based on the Managed path that Site collection belongs to .Can some one Help ...
0
votes
1answer
228 views

SP central admin Cannot connect to the configuration database after reinstalling sql server 2008 r2

I have just re-installed SQL Server 2008 R2 in my Windows Server, but after installing the SQL Server, I am unable to open my central admin. On opening the central admin its showing me the message - ...
1
vote
2answers
190 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 ...
3
votes
1answer
71 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 ...
2
votes
1answer
468 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
53 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?