You may want to create a new SharePoint Site Collection with a dedicated content database. It's a good idea to isolate the Site Collection in a separate database so it's easier to maintain and easier to recover in case of outages or corruptions.
There are 2 ways of doing this
Central Admin
IMPORTANT - Set and restrict all existing Content databases to maximum site limit, so no new site can be added there.
- Set Maximum Number of Site Collections = Current Number of Site Collections
- Set Site Collection Level Warning to 1
- Navigate to Central Administration (ensure you have necessary permissions).
- Click Appliction Management.
- Click Manage Content Database.
- Select the Web Application where you want to create new Site Collection with its own database.
- Click Add a Content Database.
- Provide a good name for the database so you can easily identify the related DB and Site coll.
- Create new Site Collection from Central Admin --> Application Management --> Create new Site Collection.
- The new Site Collection will automatically be created in the new Content Database.
PowerShell
- Start PowerShell as "Run as administrator".
- Ensure you load necessary libraries.
- Create new Content Database
- Create new Site Collection using the content database just created
New-SPContentDatabase -Name [Database Name] -DatabaseServer [Database Server] -WebApplication [WebApp URL]
New-SPSite -Url [Site Coll URL] -OwnerAlias [domain\user] -SecondaryOwnerAlias [domain\user] -ContentDatabase [Database Name] –Template [Template]
- error CAML Query containing special characters
- [Solved] SharePoint Illegal operation attempted on a registry key that has been marked for deletion
- Trigger Flow on selected Listitem from SharePoint view - create button with JSON column formatting
- SharePoint Excel error - The workbook cannot be opened because it contains the following features that are not supported by Excel in the browser
- Send Email with attachment using SharePoint PowerShell, SMTP server
- How to show or hide columns in SharePoint Online List Library from
- SharePoint excel error - A problem occurred while connecting to the server. If the problem continues, contact your administrator.
- How to get SharePoint Online user details from person or group column using REST API
- How to get SharePoint List Item URL using PowerShell
- How to get the SharePoint Tenant Login URL
- Special character & not working with SharePoint REST API
- How to disable SharePoint subsite creation option for owners
- Managed Metadata error - The data returned from the tagging UI was not formatted correctly
- Deploy SharePoint wsp solution package using PowerShell
- How to create classic site in SharePoint Online
- See actual SharePoint error exception modify web.config
- 'Edit Document' Requires a Windows Sharepoint Services-compatible application and Microsoft Internet Explorer 6.0 or higher
- How to enable anonymous public access for SharePoint Online site collection, file, folder without login ?
- SharePoint installation error - Setup is unable to proceed due to the following error This product requires Microsoft .Net Framework 4.5
- How to add animated Gif to SharePoint Online Page
- [Solved] SharePoint Search Internal server error exception
- How to create SharePoint Document Library
- SharePoint - Use Today's Date Time in list view filter and calculated column
- How to redirect SharePoint Site Collection to different URL
- SharePoint error cannot connect to the configuration database
- How to adjust MacBook Desktop icons size - MacOS
- How to rename a Pandas DataFrame Column Names - Python
- Fix SharePoint PowerShell error - The term Get-SPweb is not recognized as the name of a cmdlet function script file or operable program - SharePoint
- [macOS] How to search or view previous terminal command history - MacOS
- How to format LocalDate in Java using DateTimeFormatter - Java
- Eclipse Error : The Eclipse executable launcher was unable to locate its companion shared library. - Eclipse
- Json Serialization and Deserialization using Java Jackson - Java
- Running Android Lint has encountered a problem NullPointerException Error - Android