Forum Discussion
BIReportServer SQL Database purge
How can we purge data from the PowerBI SQL database? i would like to clear out data from our Dev server, it is currently 33GB in size
d_gosbell
Super User
Super UserIt depends on what you mean by purge.
If you don't want any of the data the fastest way to clean it all out would be to drop the databases completely and then use the Report Server Configuration Manager to generate new emtpy ones.
If you want to keep some of the data then you would have to delete any reports you don't want from the portal then you could use SQL Server Management Studio (SSMS) to do a shrink operation on the databases to reclaim space.
i want to keep all the reports, but i feel like i could purge
is there any harm in this?