Questions tagged [content-database]

A Content Database is an SQL Server database where the content of a SharePoint intranet (extranet, public web) is stored.

92 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
8
votes
1answer
2k 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 ...
7
votes
1answer
6k 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: ...
4
votes
0answers
598 views

Move multiple site collections from one content database to multiple content databases

Is there a easy way to divide site collection equally between the number of content databases attached to a single web application? I'm having a single content databases where a lot of sites were ...
3
votes
1answer
857 views

Preferred server for timer jobs not available and OOB timers jobs not runnings

In my environment when I go to CA > Manage Content DB settings; the preferred server for timer jobs in the dropdown is not shown and is empty. Also OOB timer jobs which have job lock type of content ...
3
votes
3answers
261 views

Restore Content Database on different Farm with InfoPath Forms

We have an activity to backup a content database from SharePoint 2013 server and restore it on a different SharePoint 2013 Farm. The Database contains many InfoPath forms. Yes, the URL will be changed....
2
votes
0answers
152 views

Where an uploaded image stored?

I need to know where an uploaded image usually stored ? I can't find it in file system. Only what I've got after saving is some changes in AllDocs table of SP database. To be precise: Id ...
2
votes
1answer
1k views

Store large video files in SharePoint 2013

I have a SharePoint site for one of my clients and it is mainly used for publishing (ECM). In terms of size, the site can be considered as a "small" site as we have overall DB size of 100GB (approx) ...
2
votes
0answers
157 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
3answers
3k views

MissingFeature - Issue

I am trying to get rid of the health error: [MissingFeature] Database [WSS_ContentDB] has reference(s) to a missing feature: Id = [id] I followed this link Removing features from a content ...
2
votes
1answer
82 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 ...
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
234 views

SharePoint2016: Content Database in "Error" status, do not appear with Get-SPContentDatabase

I am stuck with this urgent issue, same as Harris' issue here. In Central Administration, under "Manage Content Databases", for my main WebApplication, here is the two content databases I ...
1
vote
3answers
52 views

Storing data to a separate SQL database instead of content database

Our team is planning to move away from storing to SharePoint content database and save the data instead to an own designed SQL database. The goal is to use SharePoint just as an interface. My task is ...
1
vote
0answers
55 views

Cannot Delete content Database (having no sites) using SSOM SharePoint 2019

I'm trying to delete a content database (having no sites) using below code: _oDB.Delete(); where "_oDB" is object of SPContentDatabase and the content database exists. However, I'm getting below ...
1
vote
1answer
123 views

Low free space on a SharePoint Content DB

We have to upload up to 133 video files to a SharePoint 2016 Site but there is a very low free space in the content DB. There are multiple sites for the same content DB but only 1 site collection is ...
1
vote
1answer
599 views

How accurate is the Site Setting/Storage Metrics menu for content database size?

I'm speccing a Site Collection, it's been proposed to merge two site collections in to a single, global site collection. I've read that a site collection has a 100GB recommended limit, so I'll go ...
1
vote
0answers
63 views

How to get SP list versioning properties from WSS_Content database?

I need to set all list versioning properties via csom. All properties I usually set with following code: SP.List l = new SP.List(...); l.EnableModeration = true; //1 l.EnableVersioning ...
1
vote
1answer
56 views

Content DB property "WarningSiteCount" does not work

I'd like to use the "WarningSiteCount" property to receive information when sites warning number has reached. Unfortunately, I do not receive emails (I'm putting my account as the primary site ...
1
vote
2answers
2k views

Missing Web Parts

I getting error of missing dependencies on web parts at Central Admin. So I ran Test-ContentDatabase to find all the errors. Once found, I ran another script against my database to find where the ...
1
vote
0answers
12 views

How to check existence of web appln entry in sharepoint_confg DB

I want to check the existence for a specific entry in the sharepoint_config database . Previosuly i have created a web appln and its content db , and now i removed both. How will I come to know ...
1
vote
0answers
60 views

Site collection & content database considerations, any suggestions for best practices?

We're in the migration planning stages of moving from MOSS 2007 to SharePoint Server 2016 and one thing we want to avoid is having to worry about managing content databases too early. On MOSS 2007, ...
1
vote
1answer
28 views

Content DB Size Issue - How to Create New Content DB and Move

I'm very new to SharePoint 2010 Administration and have been asked to handle our Content DB Size issues. While not tremendously large right now we would like to handle the situation early. I've ...
1
vote
0answers
46 views

Refreshing UAT with production content + HNSC sites

We have Hosted Names Site Collections in both UAT and Production and I am in the process of Refreshing the UAT db with prod db, I have these Take a backup of the prod db Detach the DB of QA from the ...
1
vote
1answer
93 views

Restoring content database on SQL Server throws error database size limit

We a standalone SharePoint 2013 server with SQL Server Express. I have received a content database backup file of ~50MB. When I try to restore this content database backup file in our SQL Server ...
1
vote
0answers
151 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
37 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
43 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
1answer
2k 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
314 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
1answer
88 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
1k 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
0answers
53 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
2k 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
1answer
333 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 ...
1
vote
0answers
23 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
1answer
867 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 ...
1
vote
0answers
45 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
552 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
2answers
31 views

If we create SharePoint Content Database High Availability, is anything to be done from SharePoint Side?

I got a requirement from my client that one of content database needed high availability mode. As I know This could be done by SQL DBA Team, If we create SharePoint Content Database High Availability, ...
0
votes
1answer
15 views

Can items deleted in a SharePoint Document Library be saved in a Database for audit purposes?

I would like to know if items in a document library that are deleted are able to be saved to a database... this would be for audit purposes. Or does the recycle bin (1st and 2nd level) only hold items ...
0
votes
2answers
43 views

Large document library

My client uses SharePoint 2016 on prem. The last couple of months they started using third party software that send client files to one SharePoint library. For each client, a sub folder is created in ...
0
votes
1answer
90 views

Mount-spContentDatabase: Some Or All Identity References Could Not Be Translated

I'm trying to move a wss 3.0 application to a 2010 foundation server. What I've done so far: Restored wss3 content database to SQL Server used by spf2010 server (it's on a separate achine). Created ...
0
votes
0answers
25 views

SP2007 (All)UserData nvarchar field content garbled for choice fields

In our SharePoint 2007, one of our lists field is configured as such: <Field Type="Choice" DisplayName="Standard" Required="FALSE" Format="RadioButtons" ...
0
votes
1answer
53 views

When custom column deleted, internal name still exists

I have an app that pulls data from custom column by internal name. If I create the column and delete it, than create it again, SharePoint still has the internal name saved and then appends a 0 to the ...
0
votes
0answers
48 views

A parameter cannot be found that matches parameter name "NoB2BSiteUpgrade"

I tried to use the mount database with NoB2BSiteUpgrade like below Mount-SPContentDatabase "MyDatabase" -DatabaseServer "MyServer" -WebApplication https://sitename -...
0
votes
1answer
21 views

Can i create new Web Application with Copy of existing Web Application Content database in Same SharePoint Farm?

1.I have one web application 'WebAppA.company1.com' in production SP Farm with a content database Wss_Content_DB1 and i taken backup and restored in staging as Wss_Content_DB2 and mounted to ...
0
votes
1answer
52 views

SP2013 and Powershell : Export mapping between SPContentDatabase and Sites to CSV

TL;DR : I'm trying to get all the SPSites (preferably only the URLs) contained by each SPContentDatabases mounted on each one of my WebApps into a csv. In the edit, I explain how I could break the ...
0
votes
1answer
175 views

Remove Project Server Completely from SharePoint 2016

My SharePoint 2016 environment have MS Project Server. I want to remove MS project Server from my environment completely and cleanly. I want to remove its database schema, service application, ...
0
votes
1answer
10 views

A SharePoint 2007 Content Database has been migrated but SharePoint is still trying to access the old Database server

We had a legacy SharePoint 2007 which was using an old version of SQL Database. The Content Database was then migrated to a different SQL Server that was running on a newer version. This has caused ...
0
votes
1answer
64 views

How to programmatically upload file to host named site collections?

I am new to SharePoint, I want to know how host named site collections, path based site collections, and their files are stored in SharePoint databases. How to upload files to host named site ...