Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
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
5 votes
Accepted

Remove all Recycle Bin Items from database

Don't touch the database, but instead of deleting items from 2nd stage Recycle Bin using PowerShell, try disabling it from Central Admin first before running the PS script: Central Administration &...
Jussi Palo's user avatar
  • 8,176
5 votes
Accepted

SharePoint 2013 list in SQL

Where does SharePoint list stores data in SQL? In SharePoint Content DataBase at AllLists INNER JOIN AllUserData ON AllLists.tp_ID = AllUserData.tp_ListId where the data stored at AllUserData....
Mohamed El-Qassas MVP's user avatar
4 votes
Accepted

SharePoint , Forms and Data Connections

There are many possible answers to this. Here are a few: Create a sharepoint list with approval turned on (list settings), and use a flow to handle the multiple approvers. Upon approval, the flow ...
Mike2500's user avatar
  • 8,060
3 votes

Whether to go for SharePoint List or Custom SQL Database

Based on your description, you don't have a complex ERD, it just one table to archive your project. So It recommended creating a SharePoint list instead of building a new database then develops UI ...
Mohamed El-Qassas MVP's user avatar
3 votes
Accepted

How to change Sharepoint database size?

You first need to go the SQL Server where you Database is located. Open the SQL Server Management Studio. Go to you required DB and right click to get "Properties". Click on ellipses as shown in ...
Vainktesh Kumar's user avatar
3 votes
Accepted

SPFx to connect to local SQL Server Tables,Stored Procedures & view.. Approaches to follow

DUPLICATE: https://stackoverflow.com/questions/61283372/generate-rest-api-from-sql-server-database This may not be the answer. No ready-to-use SPFx webpart right now, I'm afraid. Nowadays, the base ...
Radityo Ardi's user avatar
  • 1,343
2 votes
Accepted

MOSS 2007 + ContentDB size ~500GB = Performance Issues

Some things to consider: Make use of the object cache. You can always beef up SQL--add more memory. You can also add more servers to your farm to open up two lanes of possible web traffic. Retention ...
Mike's user avatar
  • 12.2k
2 votes

Copy items from sql database table to SharePoint list

It's a simple example to retrieve items from SQLdatabase table to SharePoint list Create a function to get your data from SQL server and return it as a data table. // your method to pull data from ...
Mohamed El-Qassas MVP's user avatar
2 votes
Accepted

Copy items from sql database table to SharePoint list

Add these 2 namespaces : using System.Data.SqlClient; using Microsoft.SharePoint; Add this code and call GetData method private void GetData() { try { string ...
Gaurravs's user avatar
  • 3,556
2 votes
Accepted

SharePoint Config Log grew massively

If it's a test/dev farm try to run this script at SQL use sharepoint_config go alter database sharepoint_config set recovery simple go dbcc shrinkfile('SharePoint_Config_log',100) go alter database ...
Mohamed El-Qassas MVP's user avatar
2 votes

SharePoint Config Log grew massively

The way to fix this is in SQL server: USE MTP_RC_DB; -- Connect to the database that you want to shrink ALTER DATABASE MTP_RC_DB SET RECOVERY SIMPLE; -- Set the recovery model to SIMPLE CHECKPOINT; ...
Luis Valencia's user avatar
2 votes
Accepted

Create Site Collection with New Database

You can use PowerShell command for this. Code: New-SPContentDatabase -Name "database name" -DatabaseServer "database server name" -WebApplication "web app url" $dbname = Get-SPContentDatabase "...
Dikesh Gandhi's user avatar
2 votes
Accepted

Get the status for Get-SPDatabase powershell command

Try this $baddb = Get-SPDatabase -id 25dfdfdf73-d941-4f66-9e92-18b19e7e5c79 $baddb | Select Name,Status It should show Name and online or offline status based on database status [OutPut] [...
Mohamed El-Qassas MVP'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.8k
2 votes

1 million records in SharePoint 2013 List

With large lists you should use Content Iterator and you can read info about designing large lists. Example of usage: private void GetItems() { SPList list = SPContext.Current.Web.Lists["My list"]...
Semushin Dmitrii's user avatar
2 votes
Accepted

Crawl Database Size

You may try these steps below. These will empty your search index before repopulating it and one will also loose crawl history. Central Admin-> Search service admin -> Index Reset. This will erase ...
Alok Kumar Gupta's user avatar
2 votes
Accepted

Are access macros supported on SharePoint

I know this is not an answer to say macros works on SharePoint online. Just wanted to give you an update on Microsoft roadmap on Access App. The Microsoft is no longer recommending Access Apps. This ...
Venkat Konjeti's user avatar
2 votes
Accepted

Change User Profile Service Application database name

You can specify the database-name when creating the service application through Powershell. To do this, use New-SPProfileServiceApplication with the flag -ProfileDBName. Documentation: https://...
Helge S's user avatar
  • 441
2 votes

How to change Sharepoint database size?

Two things, First, you have to make sure that you have enough disk space on Data Drive and Log Drive on the SQL server. Secondly, you have to make sure that you did not cap the maximum Size for the ...
Waqas Sarwar MVP's user avatar
  • 56.8k
2 votes

How to change Sharepoint database size?

Please open Microsoft SQL Server Management Studio and find the database which you used . Right click this DB and select properties , select files , modify the value ”initial size” to expected size ...
Anthony Wang MSFT's user avatar
2 votes
Accepted

SharePoint 2013 - Large SharePoint_Config Database

This is not normal, config DB should be couple of gigs. If some cleanup jobs stop working then we can see the increase the size of config DB. check which table is larger in size. using table by size ...
Waqas Sarwar MVP's user avatar
  • 56.8k
2 votes

System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)

this is becuase of the way you are performing the backups of your db. When you make the backup, change the Backup Set Name. Remove all of the destinations listed, and add 1 new destination. Do a full ...
Waqas Sarwar MVP's user avatar
  • 56.8k
2 votes
Accepted

Sharepoint databases structure

SharePoint Server farm creates 4 types of databases Configuration Database (SharePoint_Config ) Central Admin Database (SharePoint_AdminContent_ ) Service applications Database Content database ...
Siddharth Vaghasia's user avatar
2 votes
Accepted

Is it normal that our sharepoint on-premises 2013 does not have WSS_Loging database

Looks like you dont have Usage service configured or it is deleted or its database deleted. Open the Central admin > go to Application management > Manage Service Application. On this page look for "...
Waqas Sarwar MVP's user avatar
  • 56.8k
2 votes

SPFx to connect to local SQL Server Tables,Stored Procedures & view.. Approaches to follow

SPFx web parts are entirely client side, meaning they cannot directly access server side resources such as SQL Server without a web API. In order to access this data in your SPFx web part, you will ...
Callum Crowley's user avatar

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