Does anyone know how to automate database backups in EPO4? I can do it manually using OSQL to disk, and I cannot seem to find a tool in the EPO console that will automate that for me. Is there something that I can use in the MS SQL 2005 Express version that will do this?
SQL 2005 Express does not ship with SQL Agent so scheduling a backup job is out of the question. You can use the Windows Task Scheduler tool to perform scheduled backups.(Note: SQL Server 2008 Express ships with SQL Agent - but the service does not start - so dont bother using that).