Some content databases are growing too large message

Occasional Visitor

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-powersh... 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-power... 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!