Questions tagged [content-database]

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

86 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
509 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
630 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
221 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
130 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
931 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
153 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
3answers
25 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
34 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
53 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
288 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
45 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
51 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
926 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
52 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
44 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
80 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
138 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
35 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
39 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
1k 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
272 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
311 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
822 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
549 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
7 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 ...
0
votes
1answer
8 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
26 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
21 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
0answers
13 views

Finding original site template id used for main site without access to Sharepoint 2013 server

I'm trying to recover a sharepoint 2013 site by installing sharepoint 2013 in a new domain. I only have access to database backups from the original server. One option I've seen uses a query based on ...
0
votes
1answer
7 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
42 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 ...
0
votes
1answer
58 views

migration sharepoint 2010 to 2013

I try to migrate site collection from SharePoint 2010 to 2013. But I can't see my site in the new URL, I have a default SharePoint site. PS C:\Users\svc-bpm-sysadmin> Test-SPSite -Identity http://...
0
votes
0answers
24 views

Restoring a database on multiple server architecture with two front end servers

I am having a multiserver architecture with two front end servers. I want to restore a content database in one of the web application and it should reflect on both the site collections. But when i ...
0
votes
0answers
36 views

2013 to 2016: Upgrade all DB's? Or just Content Databases?

I am in the process of completing a Farm Upgrade from 2013 to 2016. I have the new 2016 Farm built and configured, and am ready to transfer the databases. I know that I don't need to move the ...
0
votes
1answer
37 views

can you shrink db when dbo DoscStreams is almost full?

I am not an expert in SharePoint server maintenance and i received an notice that one of the database has reached it 93% usage of disk space. i know from research that dbo.DocStreams contains the ...
0
votes
1answer
604 views

The attach operation cannot continue because another object in this farm already contains the same ID

My SQL DBA Team decided to change the SQL version and they did migration from one sql server to other sql server and when i tired to do add content database operation from central admin it gives this ...
0
votes
1answer
32 views

Create Content Database from Farm Application Page

This issue seems like it should be very easy to resolve, however it has taken hours and makes no sense. Case: Custom application page with simple form fields. When the form is filled out by user, ...