Skip to main content
15 votes
Accepted

Placing a Sharepoint OpenBinaryStream() into a byte array Csom

Felt my way around this, I found that context.Load(file) , context.ExecuteQuery(), was needed to actually load the file, and then I need to proceed into putting it in a stream which I later turned ...
EasyE's user avatar
  • 375
10 votes
Accepted

size of content database does not decrease after deleting content

The only reason is that your contents are still residing in SP Content database. Just verify following URL once and check whether you skipped deleting items from this locations. SiteUrl/_layouts/15/...
Aakash Maurya's user avatar
9 votes

size of content database does not decrease after deleting content

Make sure that you have deleted the items in Site Collection Recycle Bin Note: Once the document is deleted it moved to 1st stage recycle bin. It stays there based on the web application recycle ...
Mohamed El-Qassas MVP's user avatar
8 votes

Need to get content database in SharePoint online using CSOM

No that is not possible. That layer of the infrastructure is blocked from Global Administrators. Best you can do is something like: $sites = Get-SPOSite -Limit all foreach($site in $sites){ $...
Eric Alexander's user avatar
7 votes

How to restore content databases in SharePoint 2016

In SharePoint 2016 > Create A new web application. Then Create a new site collection. Go back to Application Management > Manage Content database. Click on Content Database name > Check Remove Content ...
Mohamed El-Qassas MVP's user avatar
6 votes
Accepted

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

Yes it's correct, you can't restore a content database to another web application on the same farm because the Content Database GUID is already existing. So to overcome this issue, you have to do the ...
Mohamed El-Qassas MVP's user avatar
5 votes
Accepted

SharePoint update status: Cannot Upgrade content database

Try to run the below cmdlet to upgrade all content database that still needs upgrade Get-SPContentDatabase | ?{$_.NeedsUpgrade -eq $true} | Upgrade-SPContentDatabase For more details check Database ...
Mohamed El-Qassas MVP's user avatar
4 votes

SharePoint Content DB exceed 200 GB

2 things I can think off hand: Tell users to start purging content that is no longer necessary. Use Move-SPSite to move some site collections to a new content database. Based on your comment and ...
Eric Alexander's user avatar
4 votes

Need to get content database in SharePoint online using CSOM

Addition to Eric's answer (I know the question is related to CSOM) . But manually if you want to check storage usage then you can check it from site setting, admin center as well as from SharePoint ...
SP Developer's user avatar
  • 3,085
4 votes

Risks of increasing file size limit above default of 250 mb

I would do a testing before increasing the file size in the farm, because uploading the large file will take more time and some time you can have browser time out. I will have a 10 users at the same ...
Waqas Sarwar MVP's user avatar
  • 56.9k
3 votes
Accepted

Split content database by creating new site collections

You can do it with using the export and import Sp-web Export the subsite using export-spweb create a new content Database Create a new site collection with blank template New-SPSite http:///sites/...
Waqas Sarwar MVP's user avatar
  • 56.9k
3 votes

Is it possible to migrate a ContentDB between farms with different build

Yes, but before monunting, run Test-SPContentDatabase (which will say something like your error message above), and then Mount-SPContentDatabase. Finally Upgrade-SPContentDatabase which will upgrade ...
Benny Skogberg's user avatar
  • 25.5k
3 votes

SharePoint Content DB exceed 200 GB

You basically have two options: Split your content across multiple site collections and distribute the site collections evenly in multiple content databases. Meet the requirements to use 4 TB ...
Lars Fastrup's user avatar
  • 3,140
3 votes
Accepted

SharePoint Content DB exceed 200 GB

In your case, the best option is split the site collection into multiple site collections.each site collection should be in own content database. You have to decide upon the usage and target ...
Waqas Sarwar MVP's user avatar
  • 56.9k
3 votes

Cross domain, site collection migration

That's the right approach to take, but you'll need to do a couple of other things as well: When you've restored the DB to the new SQL server, run EXEC sp_chagedbowner 'domain\user' to change the ...
Andy Dawson's user avatar
  • 1,865
3 votes
Accepted

How to recreate a view by xml?

If you need to update via direct xml then use SetViewXml method of view. So your code would like this SPList list = web.Lists["Test"]; SPViewCollection collViews = list.Views; string strViewName = "...
Ahmad Zia's user avatar
  • 1,266
3 votes

How to restore existing Site Collection Content DB to a SharePoint Site Collection

You did not specify which version of SharePoint you have. But if it is at least 2010, unattached content database can be used. See https://technet.microsoft.com/cs-cz/library/hh269601(v=office.14)....
Lukas Nespor's user avatar
  • 1,661
3 votes

SharePoint content DB status is in stopped state for all the content DB from central admin under manage content DB section

I have seen a database switching status without user-intervention once. Customer promised he didn't flip that switch. I never found an answer on that. I also didn't put too much effort on that ...
MHeld's user avatar
  • 5,123
3 votes

SharePoint content DB status is in stopped state for all the content DB from central admin under manage content DB section

There are reasons when one stop the content in SharePoint from central admin / powershell. Main reason, when a content database is becoming huge in size then admin stop the content database & ...
Waqas Sarwar MVP's user avatar
  • 56.9k
3 votes
Accepted

What negative impact can occur if I detach a Sharepoint content database file location via SQL?

Once you detach the MDF file, SharePoint will unable to access the Database and throws the error (login failed for the app pool account or no data found or 404 error). all the site collections in that ...
Waqas Sarwar MVP's user avatar
  • 56.9k
3 votes
Accepted

Upgrade-SPContentDatabase fails after installing updates

Try to do the following: Dismount the content database which has the "Invalid Column" issue. Run the SharePoint Configuration Wizard to get the farm patched successfully. Mount the unmounted database ...
Mohamed El-Qassas MVP's user avatar
2 votes

content db size issue

The database structure changes between versions of SharePoint, thus, the changes in schemas mean migrating data to a new format within SQL. There will be a lot of blank space within those DBs that can ...
George Grainger's user avatar
2 votes
Accepted

Site Collection size cause

In SharePoint 2010, versioning stores complete copies of previous versions. The size you are seeing is all the previous versions. Some things to combat this, in your versioning settings in the ...
Eric Alexander's user avatar
2 votes
Accepted

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

1st you have to login with the farm admin account in order to start config wizard The account which will run service should be domain account. Rest sharepoint will fix the permission for that account. ...
Waqas Sarwar MVP's user avatar
  • 56.9k
2 votes

Restore Production Content DB to TEST

Backup SharePoint Production content databases, Restore them into test environment SQL Server instance. Identify and take a list of your source content databases either from Central Administration (...
Akshay Dattatray Nangare's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible