Post reply

Schedule SQLExpress Backup using SQLDMO

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

  • 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

     

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply