New answers tagged database
I would suggest to use the powershell with SharePoint CSOM and write the custom code to extract the data in to your external database as needed. Pls refer the below link to get an overview on CSOM with powershell. Reference Link
200 GB is the maximum size recommended for each content database. since you already have 200GB of files, I would recommend enabling Remote Blob Storage(RBS). Enabling RBS will reduce the load on SQL server and also keep the BLOB files outside the SQL database. which mean all the uploaded files are externalised. Check the following URL if you want more ...
Top 50 recent answers are included