I was looking for a flexible way to automatically back up our production database and encountered a few web pages I thought would be of general interest. That led me on to something quite intriguing but more on that in a bit.
First, if you are new to SQL Server (Express),
this page at Microsoft Technet is pretty useful and shows how you can use Management Studio to get all sorts of things done.
Buried within that article, there's a link to an external article on SQL Server Express back ups I'd actually already found but it's pretty interesting and can be found
here.
Now we get to the really interesting bit. The
backup utility detailed in part two of the article above is
hosted at codeplex. This means someone could perhaps extend umbraco using the utility code to enable the creation of very flexible backup functionality.
A method to create scheduled tasks would need to be worked out but this might be worth investigating by coders rather better than this one ;)
Anyway, regardless of whether integration is considered a good idea or not, the articles are of great use if you are using SQL Server Express for smaller sites.
Richard
2 * 3 * 3 * 37 : The prime factorisation of The Beast.