Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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
SQL
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
5 years ago

It 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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    i want to keep all the reports, but i feel like i could purge

    is there any harm in this?