Questions tagged [content-database]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
6 views

Getting compatibility level mismatch while mounting a database from 2013 farm server to 2016 fam server

Actually I am moving or rather migrating a web application from SharePoint 2013 to SharePoint 2016. There are 3 content dbs and I have restored them in the 2016 server. Now I am able to mount 2 dbs as ...
0 votes
2 answers
42 views

Does Sharepoint online have manage content databases similar like Sharepoint 2013 or 2016

I am new to SharePoint. I would like to migrate WSS_Content databases from SharePoint 2013 to SharePoint online. How can I do it? Is there any way to migrate those databases to SharePoint online. Or ...
  • 3
0 votes
1 answer
14 views

If we rename the SQL server machine name, will this new name get reflected inside the SharePoint On-premsies "Manage content database settings" screen

Inside our SharePoint on-premises 2013 "Manage content database settings" screen, we got this info:- where it mentioned that the database server name is SPSQL, but our system admin is ...
  • 984
0 votes
1 answer
40 views

Access Denied for all sites collections in same content DB while other content DB`s Sites are ok

Env: SharePoint 2016 on-prem I have 3 content database under 1 Web Application. there is 1 content database (have 6 site collections) suddenly became "Access Denied" including sites ...
0 votes
2 answers
38 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
1 answer
16 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 ...
  • 43
0 votes
2 answers
31 views

SharePoint On-Prem Content database vs SPO content database

I have over 300 site collections with it's own content databases (1:1 relation. each site has it's own CD). Now while moving to spo 365 can I have it in the same architecture? I can't find any article ...
  • 15
1 vote
1 answer
34 views

Content database size discrepancy/inconsistency - why?

I'm trying to check a content database's size. I want to use Powershell, but the method I've found examples of online is giving me a result that is inconsistent with other ways of looking at the ...
  • 12.3k
0 votes
2 answers
59 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 ...
  • 319
0 votes
1 answer
167 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 ...
  • 101
0 votes
1 answer
52 views

Chinese characters in SharePoint content DB

I'm using Sharepoint 2013 and having a problem and I found some records in UserData table that seem to have Chinese characters in the column. The column where I see this is the tp_ColumnSet. This ...
0 votes
1 answer
24 views

Content database more than 350GB with only one site collection

I just started a project with a customer. They have a content DB in SP2010 that is more than 350 GB and just one site collection (20000 subsites!!!). The Test-SPContentDatabase command did not ...
0 votes
0 answers
30 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
1 answer
144 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
0 answers
49 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
1 answer
330 views

Upgrade-SPContentDatabase in parallel as part of CU upgrade

I am updating our 2013 environments to the October 2020 CU to patch a vulnerability reported by our security team. The last time we patched CUs in the production environment, the Upgrade-SPContent ...
0 votes
1 answer
326 views

Clean orphaned site collection SharePoint 2019

I have a Web app(SharePoint 2019 on-premise, App server and DB server) with each site collection having its own content database. One of the demo content DB is deleted using MSSQL Server Management ...
1 vote
0 answers
329 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 ...
  • 582
0 votes
1 answer
67 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
1 answer
60 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 ...
  • 582
0 votes
1 answer
230 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
1 answer
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
1 answer
402 views

You cannot call a method on Null valued expression at: $File = $Web.GetFile([Guid]$Result.Id)

I have queried AllDocs table using Powershell and can see GUID values of Id, SiteId and WebId, But I am getting Error: You cannot call a method on Null valued expression at this line below: $File = $...
  • 2,525
1 vote
3 answers
67 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 ...
2 votes
2 answers
602 views

Upgrade-SPContentDatabase fails after installing updates

After installing the latest Cumulative Update for SharePoint 2016, I tried to upgrade content database but It gives an error each time. 100.00% : SPContentDatabase Name=WSS_Content Finalizing the ...
0 votes
1 answer
68 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
1 answer
58 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
1 answer
762 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 ...
  • 103
1 vote
1 answer
153 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
0 answers
67 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
1 answer
70 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
1 answer
37 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
1 answer
85 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
0 answers
25 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
1 answer
608 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
3 answers
158 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
0 answers
45 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
3 answers
149 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
1 answer
225 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?
  • 25
1 vote
1 answer
168 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
1 answer
81 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
1 answer
82 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 ...
  • 25
1 vote
1 answer
66 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
1 answer
14 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.
  • 25
2 votes
1 answer
19 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,747
1 vote
1 answer
138 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.
  • 285
3 votes
1 answer
97 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
1 answer
185 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 ...
  • 1,749
2 votes
2 answers
833 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,885
1 vote
2 answers
1k 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 ...
  • 197

1
2 3 4 5
8