Hi. Can you tell mi what sql table are responsible to store images. My db is 450 MB but there is only about 250 products. and my source file are set to file system.
I;m new in this game so i dont know this db are big or small.
What table for images id Sql ??
Zertifizierter Entwickler
- 87
- 843
- 16.02.2016
- Czech Republic
Hi. The pictures are stored in dbo.Picture.
You can reduce the database size by cleaning up dbo.Log and dbo.QueuedEmail tables. Make sure you also removed guests accounts from the system.
Once it is done, use dbcc shrinkdatabse command to free disk space. http://www.isunshare.com/sql-server/how-to-empty-and-delete-sql-server-log-file.html
You can reduce the database size by cleaning up dbo.Log and dbo.QueuedEmail tables. Make sure you also removed guests accounts from the system.
Once it is done, use dbcc shrinkdatabse command to free disk space. http://www.isunshare.com/sql-server/how-to-empty-and-delete-sql-server-log-file.html