How to decrease database size?

Hallo,

Our store database reached 1GB, and the hosting provider doesn't allow the size of the database to be more than 1GB.

Now, I can't add new data such as product or category to the database.

How to decrease database size? or remove which items?

There are about 1800 removed products. but I think their pictures data still exist in "Picture" table. How to remove them?

Hi,

 

where are the media stored to date according to the shop settings?

Configuration -> Settings -> Media Settings

 

 

Hi, 

Thank you for your answer.

I changed the media storage to File System.

I deleted log files, and shrank the database also.

But It reduced database size just 30MB.

I think product pictures still exist in database.

Is it right?

If you have access to the database (using SSMS or something) this should give you a list of the PictureIds that are referenced on deleted Products:

SELECT *
FROM Picture
WHERE Id IN
(
    SELECT PictureId
    FROM Product_Picture_Mapping ppm
         INNER JOIN Product p ON ppm.ProductId = p.Id
    WHERE p.Deleted = 1
);

Always be careful, verify, and do a full backup before attempting to delete based on this.