Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Schedule SQLExpress Backup using SQLDMO Expand / Collapse
Posted Thursday, December 28, 2006 2:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 29, 2006 3:27 PM
Points: 1, Visits: 1

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

Post #333298
Posted Friday, December 29, 2006 7:15 AM


Group: General Forum Members
Last Login: Tuesday, September 22, 2015 12:52 PM
Points: 196, Visits: 94

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

select * from msdb..sysjobs


Post #333417
Posted Saturday, July 16, 2011 12:10 PM


Group: General Forum Members
Last Login: Tuesday, February 5, 2013 8:56 AM
Points: 17, Visits: 40
You should not spend time dealing with SQL DMO or custom scripts to backup your SQL Express databases.

Try this tool 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.
Post #1142983
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse