Delete Huge files shared by users

I have installed Openfire 4.2.2 on Windows 7 with SQL Server 2012 on the same machine. I am using it from long time, but now i want to remove files shared by some users in past history few days or months back.

How can i do that ?

What files do you mean? Is it files shared using HTTPFileUpload plugin?

its shared by users using spark

File transfers in Spark are Peer-to-peer. It shouldn’t be stored on the server.

you mean files transferred using spark are peer to peer and are not stored in Database of Sql or in Openfire or somewhere else ?

They are not. If you close chat window with file transfer and reopen it, you can’t redownload it. The other user has to send it again. If your database is growing, this might be because you have Monitoring service and saving all the chats. If you don’t have monitoring and not many group chats with a lots of history stored, then your database shouldn’t grow that much.