Delete logdata from database

Vote:

Hey I want to clean the database for logdata, but I need documentation. Anyone who know where I can find documentation for database or have done this before? Thanks, André Brynildsen

#13180

Aug 29, 2007 10:43

Vote:

Here you go! Regards HAXEN


DECLARE @ScheduledJobName varchar(50)
DECLARE @ScheduledJobGUID uniqueidentifier

SET @ScheduledJobName = 'EPiServer Subscription Job'

SELECT @ScheduledJobGUID = pkID
FROM	tblScheduledItem
WHERE	[Name] = @ScheduledJobName


DELETE FROM tblScheduledItemLog
WHERE  fkScheduledItemId = @ScheduledJobGUID

DELETE FROM tblScheduledItem
WHERE  fkScheduledItemId = @ScheduledJobGUID

#15502

Aug 30, 2007 10:51

Vote:

I'm searching for tables which is used by "Log Service" (log4Net), not history logs for "Scheduler".

#15503

Aug 31, 2007 13:10