Hello,
I would like to know how people have gone about backing up there moodle server and the SQL database when running in a windows enviroment?
Like software used?
How has test restores gone? have you just recovered the database or the moodle data folder as well?
Restoring IIS?
Lots of question for an interested mind!
Cheers,
Rich
The same as you would on any other system, actually. You can set up a cron job from inside Moodle or you can use your own normal backup processes. I don't think that there is any special procedure for Windows and MSSQL inside Moodle anyway. You can start here with the Site Backup doc, that will give you far better information than I could... Cheers.
We are a Windows shop, and we use HP Data Protector for our server-level backups:
http://www8.hp.com/us/en/software-solutions/software.html?compURI=1175640#.URlwUGf1XwM
We have been hosting 1.9 on Server 2003 with SQL 2005, so I can't speak directly to 2008R2 restores yet, but it has worked great to restore on 2003/SQL Server 2005 for other systems. With the HP DP SQL license we can backup at both the OS and database level SQL server without taking anythign offline, and we usually just restore the database itself instead of the whole server.
We just started running a new 2.3 server on 2008R2 with SQL Server 2008 and are using HP DP to back it up, also. I'm hoping we don't have to find out how well it restores with 08R2, as we usually can get what we need from the indidivual course backups.
