Questions tagged [content-database]
A Content Database is an SQL Server database where the content of a SharePoint intranet (extranet, public web) is stored.
369
questions
0
votes
0answers
16 views
Recover lost MDF and LDF files - No backup [closed]
Does anyone have an experience with recovering lost MSSql database files (MDF/LDF) with disk recovery tools like recuva or similar?
We lost the files during a removal of a service, The content ...
0
votes
1answer
31 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 ...
1
vote
1answer
30 views
Setting up a “garage sale” on sharepoint
Our company is looking to sell a number of retired electronics (computers, etc). Previously we would have someone manually monitor and make sales, however this has proven to be inefficient in a large ...
0
votes
1answer
49 views
Remove MS Project Server from SharePoint 2016
Background:
We are currently running SharePoint 2016 Enterprise.
We also apply the monthly cumulative patches every month as well.
After the patches are applied we run the “ps config” using this ...
1
vote
1answer
15 views
Can we use SQL Server 2016 for SharePoint 2013?
I have a SharePoint 2013 Foundation single server farm. My current SQL version is "SQL Server 2008 R2".
I have another server with SQL Server 2016 version and I want to move all content databases to ...
1
vote
0answers
26 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 ...
0
votes
1answer
20 views
Is it possible to create site collection after creating new content database in Sharepoint 2019 CSOM (C#)?
I'm working on SharePoint 2019 environment.
I have just created site collection programmatically (CSOM) using MSDN Link
However, I want to create a content database through CSOM and point this newly ...
0
votes
1answer
29 views
Migration of SharePoint 2013 to SharePoint 2016 [closed]
After Mounting the database on SharePoint 2016, below is an error I'm getting:
Could not load file or assembly 'VDR_Mail_Event_Solution, Version=1.0.0.0, Culture=neutral, PublicKeyToken=...
0
votes
1answer
48 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 ...
1
vote
1answer
168 views
Error “Move-SPSite : Execution Timeout Expired.”
I want to move a 30GB Site Collection to another content database. This should be done with PowerShell with the Move-SPSite command. After about 40 Minutes the job stops with the following error ...
1
vote
3answers
43 views
Sharepoint databases structure
I need to know how the structure of databases of Sharepoint works, what is any databases, when they are created and this kind of stuff... I'm using a Sharepoint 2016 on premises.
0
votes
0answers
32 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 ...
1
vote
3answers
59 views
Sharepoint site still down even after restore the content databse to new web app
We’ve a major issue in our main intranet portal. It’s down with a lot of errors that were not fixed by investigating on event viewer and ULS logs.
However, I’ve restored the content database to a ...
1
vote
1answer
80 views
Same web application with content db in two separate database servers
Is it possible to have same web application with two site collections having content databases in two different SQL servers?
If so, can farm back and restore method from CA be used for restoration?
1
vote
1answer
34 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 ...
0
votes
1answer
27 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 ...
1
vote
1answer
39 views
Mount-SPContentDatabase rollback after upgrade
We need to move/use a content database from old to new web application.
Scenario goes like:
Detach content database from Old Web Application with Windows Classic Authentication mode
Attach content ...
1
vote
1answer
37 views
Can i get when the sharepoint databases have been backuped using “Get-SPDatabase”
I have 2 on-premises farms 2013 & 2016. and i want to get all the sharepoint databases names,if they need updates and when they have been backup-ed, now i find this script to get the name and ...
0
votes
1answer
12 views
Get List of Site Collection under Content Database
Is there a way I could view the list of Site Collection under a specific Content Database?
Doing it one-by-one on Central Admin is not desirable since there's a lot.
2
votes
1answer
15 views
What can be done before Content Database is connected?
Soon we'll be grading our SharePoint environment in an overnight upgrade... I'm currently prepping our servers to make the transition as painless as possible, but what sort of configuration can be ...
1
vote
1answer
66 views
Procedure to refresh MySites content database in dev with production data
I would like to know the appropriate procedure to refresh MySites in dev by using a production content database backup.
3
votes
1answer
39 views
What negative impact can occur if I detach a Sharepoint content database file location via SQL?
The end goal is to move the MDF file of a non-critical Sharepoint site collection to a different drive. The database server/name/etc... is going to be unchanged.
Microsoft basically states that the ...
1
vote
1answer
58 views
Project server 2013 database locked
Today we noticed that our Project server 2013 database is locked somehow.
Weird thing is, when we check whether from CA that site SC or via SharePoint shell, we get answer that site collection is not ...
2
votes
2answers
352 views
SharePoint content DB status is in stopped state for all the content DB from central admin under manage content DB section
When i tried to create a new site collection, we found " SharePoint content DB status is in stopped state for all the content DB from central admin under manage content DB section. "
We did perform ...
1
vote
2answers
511 views
Risks of increasing file size limit above default of 250 mb
My company is new to SharePoint. We have an on-premise installation with the file size limit set to the default of 250 mb. We've had a request to increase that limit to 500 mb. The Microsoft article ...
0
votes
1answer
249 views
The content database on the server is temporarily unavailable (sharepoint online)
Currently I am working on an application based on sharepoint add-in webpart(sharepoint hosted) in sharepoint online which was getting deployed successfully till yesterday, but today when I deployed it,...
0
votes
1answer
144 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
40 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
2answers
64 views
SharePoint web applications and content database mismatch
When I use Get-SPWebApplication command on sharepoint sever got 9 web applications names.When I use Get-SPContentDatabase got 15 content databases.How this mismatch happened??any idea???
0
votes
1answer
372 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 ...
2
votes
2answers
136 views
Repair Automatically Disabled/Greyed out
I'm trying to resolve some issues under monitoring, the main one being "
Content databases contain orphaned items". However, the 'repair automatically' is disabled and I don't know how to repair '...
1
vote
2answers
534 views
Unable to upgrade SharePoint Admin Content Database
I saw the following status: "Database is up to date, but some sites are not completely upgraded." under manage databases upgrade status. I upgraded most of the databases using upgrade database command,...
0
votes
1answer
146 views
DocStream, DocToStream compile lines into a file
In SharePoint 2013 Ent to database WSS_Content there are tables DocStream and DocToStream, they store information about the file in the form of binary data. I noticed that in SP 2013 the file is ...
1
vote
1answer
49 views
SP2013: Broken WSS_Content database is restored, some documents are not displayed
Please tell me, after the fall of SQL Server the database was restored (Backup Symantec) only by 93%, after CHECKDB, a lot of errors in the DocStream table, which contains just the binary data, i.e. ...
3
votes
2answers
73 views
Sharepoint Foundation Databases, is more better?
Accidental sharepoint admin here trying to get familiar and fix some issues.
Here is a pic from servers in our Farm screen. I'm noticing that we have two sharepoint foundation server databases? Is ...
0
votes
1answer
31 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, ...
1
vote
2answers
3k views
How to restore existing Site Collection Content DB to a SharePoint Site Collection
I have a Site Collection Content DB back up. I want to create/ restore to existing site collection. Are there any ways to do that?
1
vote
1answer
35 views
To retrieve site lists where user has access from DB
I am trying to retrieve all the sites a particular user has access from the content database. But not able to get all the sites. Somehow I can get site collections where user has access but still not ...
1
vote
1answer
4k views
SharePoint update status: Cannot Upgrade content database
I did an update of SharePoint 2013 using December 2017 CU. In central admin I see this info:
Configuration database version: 15.0.4989.1001
Status: Upgrade available
In Upgrade Status page I see ...
0
votes
1answer
339 views
Restore-SPSite : Invalid object name 'Sites'
I tried to rename the site collection host header (see post here) and it did not work, so I found this blog and thought I could give Backup-SPSite, Remove-SPSite and Restore-SPSite a try. I used this ...
2
votes
3answers
165 views
How to export one site collection and restore it in a different environment when build versions of the farms are different?
I am using Backup-SPSite and Restore-SPSite to restore a site collection, but the problem is that I am getting the following error:
What is causing this error :- Restore-SPSite : <nativehr>...
1
vote
1answer
805 views
SharePoint content database shrink operation recommended or not
We have a large content database with 200 GB space in SP 2013 and it consists of two large site collections with 100 GB space each.
We plan to permanently delete one site collection of size 100GB in ...
4
votes
4answers
184 views
SharePoint 2013 too many content databases
I joined a company where there are 10 content databases created for 10 site collections(SP2013 version). All the databases together has less than 80GB content.
Well I don't know why they created ...
3
votes
1answer
455 views
SharePoint 2010 Site Collection Maximum Size
Title says it all, I hope!
We have a SharePoint 2010 SP1 and one of our collections regularly goes over their quota (and ask for us to extend it).
We would like to know if there is an absolute ...
0
votes
1answer
344 views
Site not available after move-spsite
A site collection isn't available after moving it to another content database.
Errors: HTTP/1.1 200 OK Server: Microsoft-IIS/8.5 Date: Tue, 31 Oct 2017 08:47:25 GMT Connection: close
OR File not ...
1
vote
1answer
92 views
SharePoint Record center not showing all documents after content db restore
I am moving a SharePoint 2013 content database from a SharePoint farm to another one using the SQL backup/restore way and mounted successfully the content database to the new web application via ...
1
vote
1answer
48 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
1answer
87 views
What tp_BaseViewID means?
I'm little bit confused where to find a content or a row which is referenced to tp_BaseViewID column of AllWebParts table in WSS_Content databse. What this ID actually means and where to find this ...
1
vote
2answers
618 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 ...
