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/...
- 8,489
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 ...
- 45.4k
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 &...
- 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....
- 45.4k
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 ...
- 8,090
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 ...
- 857
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 ...
- 45.4k
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 ...
- 1,363
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 ...
- 45.4k
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; ...
- 5,191
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.
...
- 56.9k
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 ...
- 593
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 "...
- 7,247
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]
[...
- 45.4k
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://...
- 441
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 ...
- 4,979
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 ...
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 ...
- 56.9k
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 ...
- 56.9k
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 ...
- 56.9k
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
...
- 5,968
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 "...
- 56.9k
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 ...
- 4,006
1
vote
How to import data into Excel from MS Access?
Ok. So there are a couple of solutions depending on whether you have SP Enterprise or not.
Enterprise: Use OneDrive for Business (Really nothing more than a SP Library, but hey... it's branded) just ...
- 98
1
vote
Issue with "Restore-SPEnterpriseSearchServiceApplication"
You have to create a new application pool for this to work.
You can export the topology and use it in the restore as follows.
# E.g. Export the current Search Topology from your Production farm as ...
- 1,107
1
vote
Accepted
Move SharePoint Search databases to new Search Application
If you want to migrate farm from one environment to another environment, I suggest you could back up the search service application and restore it in another environment.
We can back up and restore ...
- 2,956
Only top scored, non community-wiki answers of a minimum length are eligible