Schedule backup of data/log files

Is there an equivelant to the SQL Server Agent in SQL server express edition? If not, how can I schedule the backup of the data/log files?

Thanks,

hi,

there's not a direct equivalent.. you can resort on third pary alternatives (http://www.valesoftware.com/products-express-agent.php, never tried it), or you can go for native solutions using the OW native scheduler (AT/SCHTASKS), executing a Transact-SQL statement to perform your desired backup(s) via the SqlCMD.exe command line tool..

just create a cmd file including

[cmd file]

BACKUP DATABASE pubs TO DISK = 'c:\pubs.bak';

[/cmd file]

and schedule it via WinAT at the desired time..

voila..

regards

|||

have a look at the following post...

http://www.virtualrealm.com.au/blogs/mykre/archive/2006/09/01/SQL-Agent-for-SQL-Server-Express.aspx

This is a simple scheduler system that simulates a few of the functions of the agent and might do the job that you need.