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

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
78 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
25 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
23 views

Any possible problems when migrating SharePoint 2007 databases from SQL 2005 to 2012

Due to SQL Server 2005 EOL, we plan to migrate all SharePoint 2007 and 2010 content databases to SQL Server 2012 (or SQL 2008). I wonder if it will be safe to migrate, and any possible points to be ...
1
vote
1answer
207 views

Source content DB Size after moving site collections

I have one content DB (Source content DB) with 500+ site collections in it. Recently i have moved all site collections to 10 different content DBs (using Move-SPSite command) in order to improve ...
1
vote
1answer
125 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
41 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
118 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
27 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
121 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
75 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
265 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
456 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
36 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
391 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 ...
8
votes
0answers
979 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 ...
2
votes
0answers
15 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
1k 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
13 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
33 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
29 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
667 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
39 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
711 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
19 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
42 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
462 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
21 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
16 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
14 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
23 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
81 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
31 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
23 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
49 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
48 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
16 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
30 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
35 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
44 views

Masterpage not found and features missning after Backup/Restore of Content Database

I have backed up a web application and restored in on Another server. All content seems to be there, but 1) I get an error when I go to startpage, the log says ourcustom.master cannot be found. When ...
0
votes
0answers
204 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
147 views

PS1 Script Clone user permission , Exception on You cannot call a method on a null-valued expression

This script clones Users permissions given a Source user and a target User. It works perfectly in my test environment but not in production. #Function to copy user permissions Function ...
0
votes
0answers
143 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
39 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
852 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
65 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
32 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
192 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, ...