Ever had an image accidentally deleted in BBIS? Read on to find out how to restore it!
Images in BBIS are handled via an image handler and are stored in the database. Before restoring the database give this a try.
declare @IMAGEID int = 3558;
declare @IMAGEKEY nvarchar(50) = 'Image_' + cast(@IMAGEID as nvarchar(10)) + '_0',
@CURRENTDATE datetime = getdate();
update SITEIMAGES set DELETED = 0, INTRASHBIN = 0 where ID = @IMAGEID;
exec spAddUpdate_CacheItem @IMAGEKEY, @CURRENTDATE, 0;
* this has only been tested in BBIS 18.104.22.168 (CRM 4)