SharePoint content databases are the most important artifacts in SharePoint platform as they hold majority of the data. However, at times we may have to delete the content database from SharePoint. Here is how you can utilize PowerShell to delete database:
SharePoint 2010: Remove content database using PowerShell
To delete content database from SharePoint, use: Remove-SPContentDatabase cmdlet, which removes the content database from SharePoint web application and deletes it from the SQL Server also.
Syntax: Get-SPContentDatabase -Identity "ContentDB-Name" | Remove-SPContentDatabase E.g. Get-SPContentDatabase -Identity "SP10_Intranet_Content02" | Remove-SPContentDatabase
- To add content database in SharePoint using PowerShell, Refer: How to Create a New Content Database in SharePoint 2013 using PowerShell
- How to Find and remove unused content databases in SharePoint: Find and Delete Unused Orphan Databases in SharePoint
You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.