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
Author
Message
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
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 12, 2014 8:54 AM
Points: 195, Visits: 80

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
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

Add to briefcase

Permissions Expand / Collapse