you could set up a SQL server job that restores the DB from a backup every hour. And then you will need some sort of scheduled task to re-copy the umbraco.config file. I'm not sure if that will be enough or if you will also need to re-publish the site...

i decided to keep it simple - the demo site will be for the end users to try so they have access only for the content tree and the media folder.
so - we need to reset only the DB and the media folder every hour/day.

DB reset - i can use some sort of cron job and its not a complex problem (excute url that runs DB script. i can use  Web Service Scheduler, schedule task package or pay and use my hosting schedule task add-on).

there are still 2 problems:
- how to "republish" the site? as far as i understand, after recreate the content from the DB the content tree must be republish.
- how to auto-overwrite the media folder?

anyone have an idea?

Thanks!

Hi Eran

I don't have the solution to your problem, but I do know that the great guys from CogWorks in the UK have made a demo site that resets after some time. Maybe you could try contacting them to hear how they made their functionallity. Just a suggestion :)

/Kim A

Eran,

I created that demo reset site. After creating the site and publishing everything i took a copy of the umbraco.config xml cache and put it in another directory and took a back up of the database.  The script i have restores the database deletes all folders under media (users may have created images in media section) and copies over the backedup umbraco.config file.  That copy action basically mimics a full site publish, you could also possibly write your own web service to publish all pages that is called after the db is restored but my way works quicker.

Regards

Ismail

Thanks Ismail,

so simple and yet great solution to my problem. is there any possibility that you willing to share with me this script?

how do you execute the URL that runs this script every X interval?

thanks,

Eran.

hi ismail, if youve got the time to share the reset script it would be great.
Thanks!

Hi Eran,

You could do the googling for the script, This can be coded as windows service also. Or can be bunch of services - DOS base scripts as per your folder structure.

To Restore database using job you can check http://bytes.com/topic/sql-server/answers/80544-restore-database-via-automated-order may help.

Regards,

Jigar ([email protected])

thanks jigar. i will check for it - also remember that i'm in shared hosting inviroment, so i have restriction. i'm sure that its not the hardest thing to do,
but i just ask for it because someone did the same and i thought to save the time.

Thanks,

Eran.

is working on a reply...