14

Given the amount of bloat and the fact there's not much in the 2nd stage recycle bin, it's more than likely Auditing has been turned on for the site collection. I believe trimming of the audit log is not enabled by default either, which could cause your content db to grow out of hand pretty quickly depending on level of activity within the site collection. ...


12

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 into a byte array which I was able to convert into base 64. public static void GetImage(ClientContext context, string uri) { try { var files = context.Web....


11

Follow these steps: Open Central Administration. Application Management. View all site collections. Select the site collection you need to get the database name. In the panel on the right you should see "Database Name", that's the name of the content database. -Hope it helps-


11

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/AdminRecycleBin.aspx SiteUrl/_layouts/15/AdminRecycleBin.aspx?view=2 SiteUrl/_layouts/15/RecycleBin.aspx SiteUrl/_layouts/15/AdminRecycleBin.aspx?view=2 is the ...


9

This might certainly be it. It might also be trying to create one on the default SQL server and not the one you want. We have 3 sql servers in our farm and it was going to the 1 instead of 2. This is an old point but I did want to point out something. When you run the command: Mount-spcontentdatabase -name (name of your db) -webapplication (name of ...


9

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 bin setting that (default is 30 days). after this period finished (30 days) it moved to 2nd stage recycle bin it also called Site Collection Recycle Bin. In 2nd ...


8

To find the table(s) which are taking up the most space run this query in SQL Server Management Studio (with your content database selected to query against). That should help you narrow it down to a particular table or tables and then from there you can determine what can be done to reduce the size. You might want to throw some "with nolock"s in there to ...


8

Just look at the code snippet below and try to imagine the scenario of what will happen: using(SPSite site = new SPSite("http://somesite")) { using (SPWeb web = site.OpenWeb(SameGuid)) { return web.Url; } } The above code can raise an exception because two web objects would be returned, there are infinite scenarios where GUID is used to ...


8

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){ $site.StorageUsageCurrent }


7

Why not simply using Central Admin... :-) (works even if you do NOT have access to either the physical server (console) or databases server. Central Admin -> Upgrade and Migration -> Review Database Status. By pasting /_admin/DatabaseStatus.aspx at your CA url. Rgds, Arjan Vos


7

because when I was installing second server in farm it said that servers must share config database. Way before starting installation or implementation of SharePoint one needs to decide the topology they will follow as advised by Microsoft as best practices. I am actually very surprised by your questions specially when you are installing second server. ...


7

Directly querying or modifying the database can place extra load on a server, or can expose information to users in a way that violates security policies or personal information management policies. If server-side code must query data, then the process for acquiring that data should be through the built-in SharePoint object model, and not by using ...


7

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 Database > OK. Or use Dismount-SPContentDatabase "<ContentdBName>" Open SQL Management Studio. Restore your database. then run the following Mount-...


6

I know this question is nearly a year old, but we recently had a similar problem and I thought I'd post here in case it helps anyone else. We had the same issue, a web application that, according to central admin, had a single content database with 0 site collections in it. I ran the following commands: $app = get-spwebapplication –identity “url of the ...


6

use below PowerShell code: $url="http://sharepoint.contoso.com/site/subsite/" (Get-SPSite $url).ContentDatabase.name Result should appear as: WSS_Content_2


6

There is a couple of reasons for this: SharePoint is from companies point of view a Microsoft product, so if there is a security risk then it's seen as Microsofts fault. This is the reason for Microsoft to putting in a lot of security into SharePoint which by default isn't in ASP.Net like: not running full trust not allowing updates on GETs and unverified ...


6

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 following: Create your new web application Create the root site collection. Backup and restore the site collections from source content database to new one ...


5

Did you check to make sure that you mounted the right db. If you type the database name wrong it will create a new database and it will show 0 current site count. I know - I've done this and because I didn't refresh the sql node I didn't see the new content_database listed. For example: Your content database is named: wss_content_help0101 You meant ...


5

When you delete a Site Collection, it will still remain in the Content database until the "Gradual Site Delete" Timer job is run (by default, it runs once daily). So, once you delete the site collection and run the timer job, then you can again restore the same site collection in the same content database.


5

Generally you only have one instance of SQL server per farm. Unless you cluster or mirror you instance. A SharePoint farm can only have one central administration database although you can host the central administration website on more than one server in your farm The SharePoint config database is used by central administration to help manage all of your ...


5

This can mean any of the two things. A previously deleted site collection is still residing in the content database if your farm is a SP2010 SP1 and above. This can account to different size of the site collection that shows up in the central admin and a different size for content database keeping all deleted site collections. Your Content Database contains ...


5

When a site collection's size is calculated, the size of the second stage recycle bin is not included. However, the size of 2nd stage recycle bin will contribute to the size of your content database. Perhaps your 2nd stage recycle bin is large? Consider emptying the recycle bin and/or adjusting its quota settings in Central Admin (web application settings > ...


5

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 running in compatibility range and upgrade recommended Note: If your farm has been on a patch level lower than July 2015 CU and would like to go to a CU equal ...


4

It depends! SharePoint can easily handle that amount of data and that amount of files. But there is no "magic recipie" that you just apply to SharePoint and then upload all that data. You need to think of how these documents are going to be used (read/write scenarios), you should organize them in Site Collections and sites (and with that split out databases,...


4

{Warning} : Do not touch the database structure of SharePoint it will invalidate your warranty. This is a blob storage design variable. You will see it increase as the storage requirements increase. A database can only hold so much data so to compensate it is partitioned. This value represents the partition in use. This went further into shredded storage ...


4

The technet page RJ linked to in his comment is one that I refer customers and management to all the time. These limits are there for a reason and they mention special scenarios where these limits can be broken. For example: Content databases of up to 4 TB are supported when the following requirements are met: Disk sub-system performance of 0.25 IOPs per ...


4

You may have deleted (but not removed) SPSites in your content DB, which shows in SSMS, but not in Central Administration. To check if you do, run: >Get-SPDeletedSite If there are deleted sites, you'll see these sites listed like this: WebApplicationId : 009c1289-392b-43a6-8222-146117074738 DatabaseId : 88efc46f-5a2b-4171-81cb-7577da65bac3 ...


4

AFAIK, using the existing services; it is not possible to access the content database informations from Client Object model or services. As a work around you can create your own WCF service and deploy it in SharePoint, which can provide your required data. How to Customize WCF Services in SharePoint 2010 SharePoint 2010: Create Custom WCF Service


4

The content database gets created when a web application is created. However, there can be more than one content databases in a web application as can be more than one site collection. Each site collection can have a maximum of one database but more than one site collection can share a same content database. This has been the case in MOSS, SP 2010 and is ...


4

Another way via PowerShell $site = Get-SPSite "your site url" write-host $site.WebApplication.ContentDatabases Result look like: SPContentDatabase Name=DEV2_WSS_Content_80


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