Scheduling a backup on SQL Server Express

Hi,
is there a way to schedule a backup ?
Using the Management Studio Express I've seen only the way to Backup a
database but not to "schedule" a backup.
Any help or suggestion is appreciated
Adriano
hi Adriano,
Adry wrote:
> Hi,
> is there a way to schedule a backup ?
> Using the Management Studio Express I've seen only the way to Backup a
> database but not to "schedule" a backup.
>
unfortunately, SQLExpress does not provide the SQL Server Agent, so you have
to rely on os scheduled (AT, SCHTASKS) scripts to be run via osql.exe or
sqlcmd.exe...
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