Backup Schedule

Hi
In MSDE2000 i can create backup from database and schedule it
how can i do this with SQLExpr.2005?
Mex
hi Mex,
Meelis Lilbok wrote:
> Hi
> In MSDE2000 i can create backup from database and schedule it
> how can i do this with SQLExpr.2005?
SQLExpress does not (very unfortunately) provide the SQL Server Agent..
but you can achieve a similar result scheduling your maintenance activities
(say a .sql file) via the AT or SCHTASK operating system scheduler..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply