Questions tagged [content-database]
A Content Database is an SQL Server database where the content of a SharePoint intranet (extranet, public web) is stored.
0
votes
0answers
22 views
PowerShell: Get List Item's custom field values(List Items are in Recycle Bin)
There are several list items with the same name and author in Recycle bin.
I need to retrieve all the fields(not only ID, Title, and other standard fields) before restoring.
How I can retrieve custom ...
2
votes
1answer
9 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
19 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
22 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
13 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
55 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
68 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
65 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
0answers
11 views
How to select list versioning settings from WSS_Content?
I need to change the settings on the image bellow via csom:
So it's pretty obvious:
SP.List l = new SP.List(...);
l.EnableModeration = true;
l.EnableVersioning = true; ...
0
votes
0answers
14 views
Field(s) that indicate Document Modified Date, including file folder path changes?
I have an application that scans our Sharepoint Database for documents modified in the last X days, however, it seems that the fields I am using to determine document changes are not tracking file ...
0
votes
0answers
18 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
24 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
18 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
31 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
53 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
117 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
75 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
30 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
51 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
30 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
1k 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
34 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
1k 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
173 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
57 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
230 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
163 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
204 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
197 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
53 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
41 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
56 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 ...
0
votes
2answers
293 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
2answers
99 views
Deleted ldf files, Sharepoint database schema lost
After deleting manually ldf files related to the share point databases, it's impossible to connect to SharePoint sites. It shows: "Cannot connect to the configuration database"
It is not related to ...
2
votes
0answers
81 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 ...
3
votes
2answers
37 views
How does SharePoint Designer interact with core?
When an user does some changes like changing background color or adding an image for Home.aspx via SharePoint Designer what actually happens at this moment? In other words what happens under the hood? ...
0
votes
0answers
52 views
How to get home page content programmatically?
Is there any way to get home page content programmatically ?
I've already known that home page is stored in [WSS_Content].[dbo].[DocStreams] ?
Am I right ?
I use this query:
SELECT * FROM [...
2
votes
1answer
334 views
How to recreate a view by xml?
I can retrieve the xml data of a view which is stored in the [WSS_Content].[dbo].[AllWebParts] table.
example of decompressed content of a view:
<root>
<ViewFields>
<FieldRef ...
3
votes
1answer
323 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 ...
1
vote
1answer
21 views
Having multiple indices may freeze entire DB?
Here is the post for reference on recommendation to create indices in list.
It makes sense to create minimum indices. I've a case so I needed SharePoint community's help in understanding if in worst ...
3
votes
2answers
421 views
Need to get content database in SharePoint online using CSOM
I need to access a content database's name, and its properties like Size, etc. using CSOM in SharePoint online.
Is there a possibility?
0
votes
0answers
124 views
Database Upgrade Error : Too new to upgrade
I recently identified that one of the content databases have been restored from a different environment to my test environment. The database schema version is different from the existing config db ...
1
vote
2answers
811 views
Shrink content database and logs only with powershell
I would like to create a copy of a content database on my UAT machine and restore on my development machine.
The backup of the content db would take abot 12GB. I would like to minimize this size as ...
2
votes
1answer
76 views
Detached Content Database While Site Collection Upgrade is Running
The content database was detached from SQL server by mistake while site collection upgrade was running, now the database is attached again and the site still showing upgrade in progress but opening ...
4
votes
0answers
354 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 ...
1
vote
1answer
28 views
How to fetch the Feature details, ID directly from Content Database
Is it possible to a get the details of a specific feature thats available in content database?
my custom feature name is JobReminders_TimerJob_Timer_JobRemindersFeature
using SSMS , i wanna find this ...
10
votes
2answers
825 views
size of content database does not decrease after deleting content
I am using SharePoint Foundation server in my development environment, it has a content database with size almost 68 GB.
I deleted all the major content (media file and documents) but its size does ...
1
vote
1answer
54 views
Cross domain, site collection migration
We need to migration a site collection is running on SharePoint foundation 2013 server to another domain.
I m planing to take the backup of content database and restore it in new farm then attach it ...
0
votes
2answers
83 views
Errors while restoring the content database from one Server Farm to another Server Farm
I have taken the backup of my existing content db and restored it in a new SPFarm. Both farms are in sync. The same versions have been installed. SP1 & APRIL 2017 CU. (I have verified this).
Now, ...
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 ...
