Database mirroring

Hi,

Is there a way to automatically mirror/backup a SQL Express database with a SQL Server 2005 licenced system?

They will be on seperate machines on the internet.

I have done manual backup and restores but would like to allow constant updates to allow both databases to be synchronized.

I read that the SQL Server 2005 version has a mirroring facility but I also read that this is not possible in the Express version.

What other (automated) options do I have?

Thanks Andrew

Hi Andrew,

SQL Express does not support Mirroring but it can serve as a Witness for other Mirrored servers.

You can automate backup, or any other scriptable action, by generating a .sql script file and then using Windows Task Schedule to create a Task to run the script using SQLCmd. Jasper Smith wrote an article about doing this and also offers a tool called ExpressMaint that you can use as part of your script to run backups.

Mike