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

8
votes
1answer
1k 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: ...
1
vote
1answer
102 views

SharePoint 2010 Content DB rapidly increasing in Size

SharePoint Health Analyzer rule detected the unused free space in WSS_Content Database, so to free up the space I had to shrink the Database. Before shrinking, the size of content DB was 259 GB. After ...
1
vote
1answer
35 views

personalize this page - DB location

I am currently using the "personalize this page" feature for a web part page. I've had users make changes to their personal page although I can't locate this information in the content database. ...
1
vote
1answer
247 views

Create new site collection in existing web application with different existing content DB

I have a SharePoint 2010 root level site collection SC1 in web application WEBAPP1. I want to create copy of that site collection in same web application WEBAPP1. Apart from Import/Export, ...
1
vote
1answer
46 views

Export SharePoint 2010 SP2 site to SP1 SharePoint server

After patching our Test environment of SharePoint 2010 to Service Pack 2, Our project leader told me there is a website that need to go to production. Production is still in SP1. He planned with me to ...
1
vote
1answer
131 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 ...
0
votes
1answer
41 views

What is the difference between Data Migration and Data Archiving

What is the difference between Data Migration and Data Archiving? We have a Sharepoint application for document archiving, and its database size is nearly 1 TB. So I have a plan to reduce the size of ...
0
votes
1answer
227 views

Content database “Version” in table != (get-spfarm).buildversion

How is this possible? The Content database with the version 15.0.4719 was generated with this server, of version 4569. I only noticed it because I tried taking a backup and mounting it to another ...
0
votes
1answer
88 views

How InfoPath data is stored in database?

How InfoPath data is stored in database? Is it XML or some other format? Can I import excel data to an existing InfoPath web template?
0
votes
1answer
30 views

site collections visibility problem

I have a SharePoint 2010 site that I believe is using the included SQL version instead of the 2008 R2 that I had installed so my DB size limit appears to be 4gb. I have created a second content DB ...
0
votes
1answer
338 views

Powershell PS1 clone SP permissions Exception

I have found this nice PS1 that clone permissions from a SPUser To Other. When give inputs Many things goes wrong but I have non idea what. Has Anybody any idea about this issue? PS ...
0
votes
1answer
559 views

What data is stored in the Sharepoint 2010 content database?

What is stored in the content database. It it only list & library data or absolutely everything. e.g. site collection info, sub sites, pages, images, libraries, web parts, schemas etc. Thanks
0
votes
1answer
39 views

Migration Sharepoint foundation 2010 to 2013 issue on mount db content

I'm face an issue. I've a sharepoint 2010 Foundation and installed a sharepoint Foundation 2013. I've created a web app on SP 2013 and restored the wss_content from SP 2010 on my server for 2013. ...
0
votes
1answer
427 views

Sharepoint 2010 to 2013 upgrade problem

We ran into the problem when upgrading SharePoint portal with custom solution from 2010 to 2013 version using database attach procedure. Problem is that after mounting content database to SharePoint ...
2
votes
0answers
20 views

Sharepoint to WordPress migration - Public Site

What are my options for export content of public site from SharePoint db into usable form for WordPress? I found some tools, but i would rather hear expirienced advice from someone who already done ...
2
votes
0answers
2k 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 ...
1
vote
0answers
15 views

Extract Workflow column value from AllUserData table

I have a SP 2010 content database and I am trying to extract list data from it. I cannot successfully restore the content database to a SP farm, that's why I am trying to directly retrieve the data ...
1
vote
0answers
19 views

Multiple content databases and Multiple search agents

So I have one big database which is over 1 TB now, and also this is my content database which is connected to SharePoint 2010. Although full and incremental crawl go well and search works(also i am ...
1
vote
0answers
35 views

Options for moving large amount of documents to library

I am working on migrating documents from our RDBMS (Oracle) to a given SharePoint 2013 library (1 site collection, 1 content database). The total size of the documents to be migrated is over 400GB ...
1
vote
0answers
38 views

New-SPContentDatabase : String or binary data would be truncated

When creating new database manually in PowerShell using command New-SPContentDatabase -Name $ContentDatabase -WebApplication $WebApplicationName it works fine, but recently it has started to fail ...
1
vote
0answers
790 views

Upgrade Required SharePoint_Config

When I go to "Manage Servers in Farm" from Central Admin, I see a red alert that says "Upgrade Required" against web front end. When I run the stsadm command stsadm.exe -o localupgradestatus , I ...
1
vote
0answers
42 views

Sharepoint 2010 Adjusting lists limits to recomendations

I have huge list, which has too much fields of same type (e.g., Date and Time fields limit in list is 8, of that type I have way more). If those those limits are exceeded, list item data will be saved ...
1
vote
0answers
868 views

Content databases not automatically upgraded by Mount-SPContentdatabase

We have been told that a good process for accelerating the process of upgrading a farm (say installing a Service Pack) is: Detach all content databases. Install the Service Pack or Cumulative ...
1
vote
0answers
20 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
0answers
43 views

Geting added or deleted users from SPContentDatabase

I am trying to get changes from a content database. Below is the code I have used to get the changes, but I get zero results. How to make it work? SPChangeQuery query = new SPChangeQuery(false, ...
1
vote
0answers
475 views

Database Statistics Timer Job got hangs on initialized state

Env: MOSS 2007 SP2 64 bit architecture, 4 wfe and1 app server, wins server 2003, Sql 2005 . I have a site collection in web app which is reached 50 GB. Due to this, the Site collection is not ...
0
votes
0answers
17 views

“An error was encountered while retrieving the user profile” in sharepoint Log DB

We have 70 thousands+ user profiles in our user profile service application. when i search some profile in manage user profile page, i can easily find the profile without any errors. But when i see ...
0
votes
0answers
26 views

404 FILE NOT FOUND: After Restoring Content DB

I have taken backup of content DB of one web application from production database server and restored to my development database server. content DB restored successfully. Content DBs have exactly same ...
0
votes
0answers
46 views

Error retrieving a list from unattached content database

I'm trying to retrieve a library from an unattached content database. Unfortunately after selecting the site collection and library I get the following error: [2/23/2016 5:00:31 PM] Start Time: ...
0
votes
0answers
45 views

Unable to open document from Drop off library in SharePoint 2010

Unable to view documents from drop of library it showing error message When I open pdf documents from a web application, I found below error in uls logs ...
0
votes
0answers
18 views

Content Server goes error constantly

Here is the case: on SharePoint 2010 a content database is attached. But, it constantly gives error. Every time I have to click on it and press OK, and it changes to Started status. But it gets back ...
0
votes
0answers
16 views

How to retrieve all the links within all SharePoint 2010 Pages with a specific domaine

Basically what I'm trying to do is retrieve all the urls with specific domain within the all SharePoint pages. Is there a simple way of doing it ? I tried to retrieve the list from the database ...
0
votes
0answers
31 views

“Object reference not set to an instance of an object. ” when creating site collection

When I try to create a site collection, I get the error Object reference not set to an instance of an object. I've done some digging, and have found an answer here. However, I followed the steps, and ...
0
votes
0answers
119 views

Move content database SharePoint 2010 404 error

I get a 404 page not found error after I run a mount-spcontentdatabase command. I have Production SharePoint 2010 farm with application server, Front end and application server installed on windows ...
0
votes
0answers
32 views

SharePoint 2010 performance blocking issue at particular time

After some changes, deployed this week, SharePoint 2010 can't operate properly, throwing Timeout error for any action. It appears at a particular time - 9pm. All actions, which affect database fail ...
0
votes
0answers
25 views

Database Attach, all content missing

I am doing a database attach upgrade from 2007 -> 2010 -> 2013 I exported all the site collections and theyre all fine except for one. After running the following commands the new site collection is ...
0
votes
0answers
53 views

The webpage cannot be found after creating new site collection

I created a new content database and then created a site collection. When I try and access that newly created site collection, I get 'The webpage cannot be found' page. I am able to create new site ...
0
votes
0answers
56 views

Site Collection does not exist in database. Site collection will not be moved

I am trying to move the site collection http://<webapp>/dealers/1020 from content database WSS_Content_2 to WSS_Content_7 I run the command: Move-SPSite http://<webapp>/dealers/1020 ...
0
votes
0answers
17 views

incresing size sharepoint config database

sharepoint config databse size:227.25 MB space avilable:6.12 MB Now my sharepoint site become slow is this is issue . if this is issue how to increase size of the sharepoint config db
0
votes
0answers
33 views

STSADM.EXE -o restore options

I'm moving some moss databases from one database server to a new one. I've been following the steps outlined in this technet On step 13. Restore an SSP to the new location. I'm coming across some ...
0
votes
0answers
38 views

Sharepoint 2013 content DB restore issue

I'm trying to restore a content DB from a test server to prod. Followed the steps documented in the link : ...
0
votes
0answers
252 views

404 error when doing restore content database

Im trying to copy content database(one web application, exacly what I want) from our production- to our test-Environment. Im using this guidefor backing up (the CA-alternative). When I use the ...
0
votes
0answers
172 views

Missing Site collection when attaching a content database

We have a problem with a single site on our SharePoint and need to restore it from last weeks backups What I am trying to do, it to restore the content database from last week, attach this to a ...
0
votes
0answers
42 views

Content DB restore problem (SP2007)

I'm having an issue restoring a content database and hopefully one of you guys can help me out. I'm trying to replicate a live issue environment in a new temporary dev environment for troubleshooting ...
0
votes
0answers
959 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% ...
0
votes
0answers
70 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
33 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 ...
0
votes
0answers
204 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
0answers
1k views

Error while attaching content db to a different server

I got back up of content db from a demo server and trying to attach it to a newly created web application in my personal copy of same demo server but not up to date. however I am getting this error, ...