SQLServerCentral / Programming / SMO/RMO/DMO / Schedule SQLExpress Backup using SQLDMO / Latest Posts

RE: Schedule SQLExpress Backup using SQLDMO

AlexGreen — Sat, 16 Jul 2011 12:10:08 GMT

You should not spend time dealing with SQL DMO or custom scripts to backup your SQL Express databases.Try this tool http://sqlbackupandftp.com. You can create manual or scheduled backups with it. You can also save your backups in a remote location on your LAN or FTP sites, compression and encryption is also available.Version 6.0 provides some interesting advanced options such as differential and transaction log backups.

RE: Schedule SQLExpress Backup using SQLDMO

Jambu Krishnamurthy — Fri, 29 Dec 2006 07:15:00 GMT

i have not worked with the Express edition, but can you please try this:

select * from msdb..sysjobs

Schedule SQLExpress Backup using SQLDMO

k-346900 — Thu, 28 Dec 2006 14:49:00 GMT

is it possible to Schedule SQLExpress Backup using SQLDMO?SQL Express does not support SQL Agent then how can I view jobs created using SQLDMO?In management studio there is jobs option is unavailable. I have written code to add JObSchedule/job/jobStep and program is running without errors .. but no way to find out whether job is actually created and executed..