Hi is there any simple way to remove data of *.ldf & *.mdf with querry analyser. I need a simple way to free up space of the log with querry analyser as i don&#039;t have permission of the c drive as the database is hosted on a shared ISP SQL server .But i have the owner permssion of the databse and can use SQL querry analyser, And i am stuck as my space is limited and i can&#039;t get more space for transaction log and filegorup . <BR>This is the only option i have left with to remove or truncate the data of my file group properties. Please be sure as this is live project and any mistake by me can cost me a lot. Please advise me options to free up file space of transaction log and other wfiles whihc are not needed on server.