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
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 ...
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 ...
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. ...
3
votes
1answer
105 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
1answer
48 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 ...
0
votes
0answers
77 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?
0
votes
2answers
102 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 ...
4
votes
1answer
626 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 ...
2
votes
1answer
42 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
45 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
141 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
74 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
341 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: ...
1
vote
1answer
2k views

“a duplicate content type '<content type name>' has been found” error message

I have just upgraded customer environment to SharePoint 2010. I have been having minor issues with content types of which some I managed to resolve except the following one: We have a SharePoint 2010 ...
0
votes
1answer
523 views

Migrating document libraries from SharePoint 2007 to SharePoint 2010

I need help in my migration process. First I have a test environment which is configured for SharePoint 2010 and I need to migrate a web application from SharePoint Server 2007 to SharePoint 2010 ...
0
votes
1answer
600 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
897 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
641 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 ...
1
vote
0answers
17 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 ...
1
vote
3answers
2k views

Restoring a Document Library's content from a backup?

I have a sharepoint server backup and a database backup of the SQL2008 server which holds the sharepoint database. Some infopath forms were deleted from the document library and I would like to ...
0
votes
1answer
67 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 ...
0
votes
2answers
777 views

SharePoint 2007 -> 2010 upgrade content database size currently over 100GB

I've got a site which has a 2007 content database around 165GB at present they're running out of space on the SQL server so I'm just going to advise we move them all to a new SQL Server 2008 R2 ...
0
votes
1answer
237 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?
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.
0
votes
1answer
176 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
121 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
77 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
139 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 ...
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, ...
5
votes
1answer
811 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 ...
1
vote
1answer
892 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
2answers
1k views

Applying wsp solution file to Sharepoint site collection programmatically

I am trying to deploy a sitecollection with a content database attached to each site collection. I was able to deploy site collections with individual content databases for each sitecollection, ...
0
votes
1answer
702 views

CU October 2011 Invalid object name 'Webs'

I've runed the CU October 2011 and Sharepoint Configuration Wizard failed after executing, however the farm build version changed to: 14.0.6112.5000 as expected. In ULS i've seen error: Invalid name ...
0
votes
1answer
502 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
186 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
267 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 ...
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 ...
0
votes
1answer
332 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 - ...
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 ...
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
235 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
806 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?
0
votes
2answers
6k 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
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 ...
0
votes
1answer
166 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
1k 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
404 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 ...