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 ...
5
votes
1answer
5k 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
121 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
42 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
335 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, Restore/...
1
vote
1answer
54 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
141 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
14 views

Sharepoint 2010 Database version

We have an weird error we cannot find out why this happened. We have some content database that are showing : SharePoint database is in compatibility range and upgrade is recommended But the what is ...
0
votes
1answer
56 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
345 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
98 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
31 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
394 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 C:\Users\...
2
votes
0answers
24 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
854 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 ...
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
31 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
37 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
51 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
44 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
921 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 update....
1
vote
0answers
21 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
483 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
9 views

Strange content behaviour after site restore

I restored with restore-spsite a site collection into a new farm. The content db passed from 10.7GB to 4.7GB. When I download some content document - browsing locally - it may download suddenly, or ...
0
votes
0answers
19 views

WSS 3.0 Restore and Add

I created a server to mimic our current production server of WSS 3.0. I was able to restore the database to the SQL server, and did the below command with an elevated command line. stsadm -o ...
0
votes
0answers
29 views

After SharePoint site restore not update the content DB

I got the SharePoint 2013 site collection back and solution wsp and restore them in new environment. It is done. But when I go to the sharepoint list and update the list with front end custom web art ...
0
votes
0answers
56 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
53 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
53 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: 2/...
0
votes
0answers
57 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 System.Runtime.InteropServices....
0
votes
0answers
19 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
18 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
48 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
132 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
35 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
28 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
58 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
64 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
35 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
40 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 : https://sergeluca.wordpress.com/2013/05/10/note-to-self-moving-a-sharepoint-contentdb-from-...
0
votes
0answers
314 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
185 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
47 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
1k 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
73 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
34 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
210 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, ...