In our software because the users are using SQL Server 2008 R2 Express, I would want to create backup jobs for them programmatically using the SMO API. Is it possible? If possible point me to any articles written on this light of this topic.
Is it possible to create backup jobs on SQL Server 2008 R2 Express with SMO
886 Views Asked by Soham Dasgupta At
1
There are 1 best solutions below
Related Questions in BACKUP
- Need to create a simple script for ftp login
- Backup strategy for build tool hosted on Azure VM
- Error with Data Pipeline backup when I transfer my data from DynamoDb to S3
- Tablesnap not working
- Can WebDeploy Backup on Application Level Not the Whole Site?
- Cassandra restore from incremental backup files from multilple nodes
- How to avoid "use <database>" statement on mysqldump backups?
- Bash output limited to echo only
- Batch file to delete all folders in a directory except the newest folder
- CentOS6 - Backup all RPMs and installed programs
- Tar backup error
- What is the best file format to save dynamoDB table?
- Creating Backup and Restore where the Executable path in vb.net
- Daily and weekly backup strategies
- iOS Enable backup for file ONLY IF backup is encrypted
Related Questions in SMO
- Backup database code not working when I add a backup compression option using SMO
- Filter DBO schema/owner only - dont show SYS Stored Procedures
- Vb.Net SQL Server Management Object(SMO) file not found error
- Issue with Smo .EnumAvailableMedia()
- how to backup of specific tables from database sql server and save .bak file in computer using vb.net code
- How to get encrypted records from table in sql server by symmetryk key using sqlserver.management.smo
- new-object : Cannot find an overload for "Server" and the argument count: "*numberofservers*" in PowerShell script
- How to target multi SQL Server editions
- Restore network database on SQL Server without copy it
- SMO.Transfer fails due to LocalAdmin login, but only for some databases
- SQL Server 2016 list instances
- Restore SQL Server database using C#
- WIx - "Registry key not found" when trying to see if a value of SQL SMO exists
- Unable to get newly created Logins from Remote SQL Server Instance using SMO & C#
- Running sql script from Windows Forms Application
Related Questions in SQL-SERVER-2008R2-EXPRESS
- Visual Studio 2013 Click Once With SQL Server Express 2008 R2
- Incremental commit to optimise insert query
- SQL Server 2008 R2 Recordset apears not created
- Cannot connect to SQL Server 2008R2 Express
- Using batch file for running SQL Server Express with parameter silently
- How to solve it when there are multiple SQL Server instances, but can only connect to one?
- Given a SQL Express database base file (.MDF) how can I wipe/clear/reset the schema and/or data?
- Looking for a free DNN community edition website Backup and restore procedure working with DNN 7 and SQL server express 2008 r2
- SQL Server 2008 trigger inserting multiple rows
- T-SQL: For Loop, Temporary (in-memory) Tables and Stored Procedures
- Opening SQL Server Express via JDBC in Mathematica?
- Max number of tables (objects) in SQL Server editions (compact, express)
- Having Foreign Key relations between two different columns in two different databases
- SQL Server Express: How to determine SP memory usage
- Connecting Database using c# in Visual Studio 2013
Related Questions in MAINTENANCE-PLAN
- Conditional maintenance plan for backups
- Maintenance Plan read Server Agent log
- What is an ideal way to put a Java Web Application (Struts) into Maintenace mode?
- SQL Maintenance Plan - Determining Duration of Steps
- How to retrieve all indexes in a database along with their data types in SQL Server 2005?
- Maintenance Plan Fails But Query Runs
- How do I maintain zabbix for MongoDB backup? with ansible
- Maintenance tasks on Azure SQL Managed instance
- Maintaining a Caching Appliance
- Database Maintenance
- Is it possible to create backup jobs on SQL Server 2008 R2 Express with SMO
- Notify operator task vs. notify if job fails
- Only one Storyboard for iPad and iPod/iPhone devices
- How running a program or PowerShell script, after the "SQL Server Maintenance" plan ended?
- Do re-indexing of database runs automatically with CRM app?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Since the Express versions don't have the SQL Server Agent that executes jobs - no, I don't think this is possible.
What you could do however is create a standalone console app that uses the SMO library to perform the SQL Server backup, and then just schedule that console app on your machine using the built-in Windows scheduler, to runonce every day (or every four hours or whatever you need)
As for resources on SMO - check these out: