Forum Discussion
BIReportServer SQL Database purge
Super UserBased on that 1 table if you did a shrink the maxiumum space you could reclaim is the 9Mb of Unused space so it would not really be worth doing
yeah, so any issues with purging the data from this table?
and then free up the space
- d_gosbell
Anonymous wrote:
yeah, so any issues with purging the data from this table?
and then free up the spaceSo if you are talking about truncating the table (eg deleting all the rows) yes there would be an issue. Deleting anything directly from the database is not supported and is highly likely to cause issues. Your entire instance might stop working or all your reports might thow errors. You should only ever delete things from the UI or using the support API methods.
The extended content table stores the content for your pbix based reports and the data models are loaded in and out of RAM dynamically from there. So if you delete anything from there you will almost certainly loose reports from the portal.
If you are just talking about performing a shrink operation at the database or table level there is not much danger in that although it is probably something you would want to do while the instance is not being actively used to minimize the impact. Although as I already mentioned you would only regain a maximum of 9Mb from shrinking that table.
ok thanks
so what in your opinion is the best method to reduce the size of the database moving forward?