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
2
votes
1answer
1k 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
196 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
515 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
368 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
101 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
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
1answer
99 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
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
2answers
236 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
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 ...
3
votes
2answers
38 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? ...
3
votes
1answer
704 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
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 ...
1
vote
1answer
22 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
704 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?
1
vote
2answers
2k 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
117 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
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 ...
1
vote
1answer
31 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
1k 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
74 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
236 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 ...
1
vote
1answer
36 views

How to move the SharePoint's SQL Server Instance from one Server to Another

Am having a single server farm for my SP 2013, currently WFE is installed on Server01 and sql db in Server02 . I dont have sufficient space in server02, where sql server is running, like no D:\ drive ...
5
votes
1answer
133 views

Create a Replica of Content DB and use it as content database of new web application in the same SPFarm

Am having a Single Server Farm Environment wherein I am having 1 WFE and 1 SQL Server machine . in the SQL server box, I have taken a backup of SharePoint's web application's content DB. Content DB ...
3
votes
2answers
501 views

Sharepoint Migration of DB from one server to another server

we have a SharePoint 2010 production farm consists of 2 servers 1 server(App+ WFE) and 1 DB(sQL2008) server . we would like to move the existing Databases from old server to new database server(Later ...
2
votes
1answer
47 views

Site collection content database

If a site collection content database size grow up; can I add a second Content Database to it? if No, what's the solution?
1
vote
2answers
290 views

Third-party software that splits large content Db into multiple files?

This question is necessarily vague, and I apologize in advanced for that. Somewhere on this stackexchange I saw an answer that referred to using third-party applications that can split a large content ...
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) ...
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
141 views

RBS - Do the Microsoft.Data.SqlRemoteBlobs.Maintainer.exe.config settings need to be the same on each server?

I'm setting up RBS and looking at adding an additional content database. The instructions that I'm reading mention to add the connection string to the Microsoft.Data.SqlRemoteBlobs.Maintainer.exe....
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
211 views

How much a site collection can store if i do not specify any Qoute when creating it

I am working on an on-premise sharepoint enterprise server 2013. currently i have the following info:- i have one web application + one content database. I have 10 site collections. now when i ...
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 '/' ...
0
votes
1answer
36 views

SharePoint 2013 / Data Scrubbing

After you delete an item or document from a list or library, and then the recycle bin and secondary recycle bin, does the data remain in the database for a certain amount of time? .. or forever unless ...
1
vote
1answer
178 views

Issue when restoring Content Databases

I am trying to restore a production database in my UAT environment for testing purposes but something wrong is happening. I am able to restore the database via SQL MS, without any errors. Then the ...
1
vote
1answer
28 views

Create content database and re-add to TOP site collection

I have one Content DB which is of 250 GB. I want to create new DB and re-add to that particular TOP site collection. This Web application has several content databases, each for its specific top site ...
4
votes
1answer
316 views

Is Content Database Encryption Supported?

There are some folks in IT that are interested in Encrypting all of the SharePoint Databases, specifically the Content Databases. Is this a wise option and is it supported? We will be using SP2016 ...
1
vote
2answers
61 views

Content Database Restore Failing

Can anyone point me a direction to solve this issue? Error: 18456, Severity: 14, State: 5. Login failed for user 'Domain\Administrator'. Reason: Could not find a login matching the name ...
5
votes
4answers
625 views

SharePoint Content DB exceed 200 GB

As per Microsoft site I saw content DB size will be 200 GB for best performance. I want to know if site collection size reached 200 GB then as an admin, what action should I take to reduce the size so ...
1
vote
2answers
2k views

Whether SharePoint content database is encrypted

I have been asked by the security team of my client that whether the data in SharePoint (here SP2013) is encrypted or not. If it is encrypted, what is the type of encryption used and things related to ...
0
votes
1answer
115 views

Mount/dismount database for migration

I'm mirgrating from one domain to another. Finally managed to get the new sharepoint version to match (infact, its actually a little newer than the original now!). I have exported the databases ...
2
votes
2answers
100 views

Split content database by creating new site collections

Im having one site collection with 5 sub sites utilizing very high space on the content database. Is it possible to move these sites by creating new site collections to different content databases? ...
0
votes
1answer
30 views

Display the Business data that reside on PDW to sharepoint list

I was trying to display the Business data that reside on PDW or APS (parallel data warehouse), to SharePoint list .And to do so I tried to connect to the database server using SharePoint designer ...
0
votes
1answer
139 views

Cannot delete SharePoint site collection using powershell

To cut it short, the site collection still remains in Central Admin while the content database is deleted. I used powershell, but I get cannot open database "db" after requested by the login. Login ...
1
vote
1answer
71 views

What is the Minimum permission the Configuration Wizards' Service Account need to have on the Database

we have installed a new sharepoint enterprise server 2013. and now i want to run the "Central Administration >> Configuration Wizards". where i am asked to select the Service Account which will be ...
0
votes
1answer
143 views

Export webpart configuration as xml from sharepoint content database

I would like to programatically(C#) export all properties of all my webparts from Sharepoint 2013. I have access to SP content db and I wonder whether it is possible make use of it somehow (for ...
1
vote
2answers
44 views

Attaching SharePoint databases on a lower SQL version

Searched the interwebz for this but couldn't find any info. I've got two SharePoint 2013 environments. SharePoint is upgraded to the same version on both. SQL Server versions are different, though: ...

1
2
3 4 5
8