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
1answer
25 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
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 ...
3
votes
4answers
27k views

How can I know in which content database my site collection is stored?

I have a farm and I see in sql many content databases. I have some site collection and would like to find something in the userinfo table in the sql database. But in which content database do I need ...
1
vote
1answer
821 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
2answers
915 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
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 ...
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
3answers
1k views

Restore-SPSite error “0x80070003”

I am getting following error when restore content database in SharePoint 2013. Restore-SPSite : 0x80070003 At line:1 char:1 + Restore-SPSite http://SiteCollection/ -Path <"Path Name"> + ...
2
votes
1answer
923 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) ...
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/...
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 ...
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
28 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 = $...
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: ...
0
votes
2answers
1k views

Programmatically create content database in C# (SP 2013)

The goal is to have a web user interface with the option to create new site collections with new Content Database. With the admin user I can manually in the CA create new Content Databases. I can ...
0
votes
2answers
720 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 C:\Users\...
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 ...
2
votes
2answers
85 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
2answers
921 views

What is the best way to CRUD data in SQL database into SharePoint?

In Sharepoint site, I have a list, it will display data from the table in SQL database. When user insert, update or delete item in this list, the SQL database will be changed too. The change is one ...
0
votes
1answer
41 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
32 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
226 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
45 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 ...
0
votes
3answers
5k views

Error “Attempted to use an object that has ceased to exist” while trying to access sharepoint landing page

I could access sharepoint central admin, but not sharepoint sites or pages. Is it something related to connection time outs or content database timer locks? How to fix this? Server Error in '/' ...
1
vote
0answers
33 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
29 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
32 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
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://...
1
vote
1answer
280 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 ...
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
286 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
56 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
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 ...
1
vote
1answer
763 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 ...
1
vote
3answers
70 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
132 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?
0
votes
1answer
976 views

Documents / Library missing after migrating My Site to the new Content Database

I've moved some My Sites to new content database with the powershell cmdlet Move-SPSite. However, after moving them, it appears documents were "lost" on some of them (most of sites is just fine). When ...
3
votes
3answers
1k views

Where do you deploy scripts that are loaded in a masterpage?

Do you deploy the script files to "_layouts" or the content database? If "_layouts," do you use a <ScriptLink> tag or a <script> tag?
1
vote
1answer
52 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
34 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
51 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
41 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.
0
votes
2answers
1k views

Backup & Restore sharepoint 2013 content db on the same server with the different name

I want to create copy of existing webapplication on the same server. Can any one suggest me the steps to do that? Thanks in advance.
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 ...
2
votes
2answers
5k views

Sharepoint Database Connection issue after recovering the content Database

Recently our SQL server which contained the SharePoint Content Database got corrupted. So we recovered the database. After that we tried to point out SharePoint System to the recovered database and we ...
1
vote
1answer
78 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.
1
vote
2answers
342 views

Get error after content database restore to another server

I have some problem with restore sharepoint content database. get back up content data base from server A. then restore to SQL server server B. create a new web application in server B. add restored ...
3
votes
2answers
77 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 ...

1
2 3 4 5
8