Schedule SQL Express BAckup using SQL DMO

dmouser

Is it possible to schedule SQL Express BAckup using SQL DMO do I need to use

WScript.Shell,SQLDMO.SQLServer,SQLDMO.Category,SQLDMO.Job,

SQLDMO.JobStep,SQLDMO.JobSchedule

dmouser

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

Allen White

Because SQL Express doesn't include the SQL Server Agent the jobs you are creating can't be executed. You'd be best served to use Windows Scheduler to run the programs performing your backups.

dmouser

I would like to schedule back up programatically in ASP. If I want to use WSH , It can only run VBScript and JScript files that are .vbs or .js. It does not run .asp files. If you wish to run the VBScript code contained in an .asp file in the WSH environment, you need to remove all of the HTML tags; the <% and %> tags, and rename the file with a ".vbs" extension. Also, remove all references to any of the ASP intrinsic objects. What would be the best solution

Allen White

Well, since you want to schedule automatic backups, and SQL Express doesn't support SQL Agent, I think your only option is to copy the code to a VBScript file and schedule that through Windows Scheduler. The ASP code doesn't help you with the automatic processes so it's superfluous.

dmouser

Is it possible to call vbs file from ASp Application to automate back up process

Cesar Francisco

Hello,

A similar question. I am writing my first application. It is a small data entry and data display Form. How can the user of this deployed (if ever) application save the database to a memory stick and open it in an other instance of the same application on a different computer It is a normal and expected when say someone writes a text, that that text can be saved, moved and opened it in any other computer -- so far the computer has a program installed which is capable to read it.

How could this be implemented Is the application welded to a database and cann't be detached from it Can the data itself be separated from the database as in the case of an Access or FileMaker solution

Greetings,

Seemingly there are lot of newbies and not so newbies chasing after an answer for this problem.