I tested a site for a couple of weeks with Host-tracker in order to check for outages. That worked and I moved the site to a different server. Now I'm about to hand the site over to the client but I want to clear the site log out (which is chock full of host-tracker data) before doing so.

I tried setting the history back to 0 days and then enabled the PurgeSiteLog task at its default shedule of one day. Now, a few days later the site log is still there and even tho DNN4.35 tells me the site log has been disabled, it will still show me the logs that were made.

So, before I go digging around dangerously in the db, how does one normally wipe the site log?

Thanks for any tips
Rob

Thanks for the reply Mike,

My hosting panel has Enterprise Manager on it so I can certainly open it up. I've been in and looked around but that's about all. I've also seen where one can paste a command in and run it. There's also another section on the control panel that says it does the same thing and of course there is also that page in DNN where one can paste SQL bits in and run them. Are these all the exactly the same thing?

And just another quickie.. is that the full command TRUNCATE TABLE [dbo].[DNN_SiteLog] or is part of it (the dbo?) a placeholder where I'm to put something else in? I'm afraid I'm an sql noob.

Which leads me to another query.. does this wipe the site logs for all portals in the DNN instance or can it be done for just one portal?

I do have a backup site I can try it on.

Regards,

Rob