Forum Discussion
Some content databases are growing too large message
Hi all,
New admin of share point 2019. We got a database exceeded 100GB message, but not sure how to handle this message. Can I just backup data contents ? or should delete files from site collections ?
1 Reply
- Use PowerShell to see how many site collections are running on the content database. https://www.sharepointdiary.com/2013/11/get-all-site-collections-in-content-database.html If there are multiple site collections: Step 1- create a new content database(s) https://www.sharepointdiary.com/2014/07/create-new-content-database-in-sharepoint-2013-using-powershell.html Step 2: Move some site collections to new content database(s) https://www.sharepointdiary.com/2015/07/move-site-collection-to-another-content-database-using-powershell.html If you have a single massive site collection that is triggering this error, it's time to investigate and start planning. For example, if there are a bunch of subsites, which ones can be moved to site collections. Is there old content can be deleted or archived? If you have lots of large files, maybe setting up blob storage is an option? Good luck!
