sql server msde: Scheduling a backup on SQL Server Express -- sql server msde

Scheduling a backup on SQL Server Express

Adry
11/17/2005 12:00:00 AM

sql server msde:

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

Re: Scheduling a backup on SQL Server Express

Andrea Montanari
11/17/2005 12:00:00 AM

hi Adriano,
[quoted text, click to view]
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.shtm http://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