|
|
|
Forum 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..
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Tuesday, March 26, 2013 11:32 AM
Points: 195,
Visits: 70
|
|
i have not worked with the Express edition, but can you please try this: select * from msdb..sysjobs
|
|
|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Tuesday, February 05, 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 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.
|
|
|
|