In addition to the usual SQL server native back up it would be useful to have a backup & restore feature in the admin section - ideally you could schedule a backup directly through the admin eg daily, weekly etc - this is mainly useful for clients on hosted installations where they may not necessarily have direct access to the database itself ( ie. it's shared over several clients )
The existing export database could provide a good template for this.
We have added the ability to backup the SQL database on a nightly basis. We have not added the ability to restore the SQL database. You can perform the store manually using the SQL Management Studio.
That's fine for us - but I was thinking more in the multi-client hosted environments. Ideally each individual client would have their own database in SQL so they can have their own backup procedures ( but do not have access to the DB itself ) AFAIK SQL Express supports unlimeted number of databases of up to 4gb in size although there is a 1gb throttle on bandwidth. Obviously if you were going to run several clients on one box SQL Express probably wouldn't cut the mustard - but the principle is still the same.
I've been thinking about the management infrastructure quite alot recently actually but will wait for 1.5 before making any further observations ;-)
