Schedule SQLExpress Backup using SQLDMO

• k-346900

  SSC Rookie

  Points: 33

  More actions

  December 28, 2006 at 2:49 pm

  #103292

  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..

• Jambu Krishnamurthy

  SSCrazy

  Points: 2054

  More actions

  December 29, 2006 at 7:15 am

  #680478

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

  select * from msdb..sysjobs

   

• AlexGreen

  Right there with Babe

  Points: 763

  More actions

  July 16, 2011 at 12:10 pm

  #1353869

  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.