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
887 views Asked by Soham Dasgupta At
1
There are 1 answers
Related Questions in BACKUP
- How to restore a e2image image backup
- Differential backup for delete and restoring files and folders
- How would I use my backup for my 1inch wallet to get back into my wallet
- backing up RDS to non AWS backup solution
- Can I backup a dockerized mysql database just by copying the container's volume?
- Do I need the series of differential backups to restore my Ceph image to a specific point?
- Backup with Spatie does not work on Windows
- :Unable to obtain authentication token using the credentials provided
- How to create a localized backup server Using Windows server?
- Extract Note Text Format (Bold/Italic/Strikethrough) from iOS OTG Backup
- backup issue about openstack disk
- Auto back up using python
- Avoid automatically backup after restore from snapshot on RA3 Redshift cluster
- UDF (DVD-R) incremental writing of changed file sectors
- About VM Esxi Backup
Related Questions in SMO
- How to replicate the "Script Table As... Drop And Create..." SQL Server Management Studio action in SMO?
- Inserting data into a non-organized table in word from SMO file
- Why does .Script and .EnumScript not accept ScriptingOptions objects as arguments?
- Generate SQL Script from SMO Without CREATE TABLE Statement
- SQL Creating SQL Server Agent Job with scheduler
- How to get 'ALTER' in SQL statements when using SMO class in c#?
- How to best generate script with data for system-versioned temporal tables?
- Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo
- How to set a column's default value using Microsoft SMO?
- SQL-Serverexport using SMO-Assemblies (Powershell) - How to make seperate files per Statement?
- Executing a powershell script from multiple environments result in different outcomes
- SSIS : Executing local dtsx package without using Microsoft.SqlServer.Dts.Runtime in .NET 6 with SQL Server 2019
- Failed to retrieve data for this request error calling ServerConnection.Databases.Contains()
- Cannot connect with SMO to Azure SQL database from console app. Works in VS2022 debug, but get NullReference when running app
- Getting program module scripts using PowerShell
Related Questions in SQL-SERVER-2008R2-EXPRESS
- Connecting a SQL Server Express 2008 R2 database to Visual Studio 2017 without upgrading it
- User Input Date And Time as SQL Query Parameters in RDLC Reports
- Join syntax not being recognized by SSMS
- Restore SQL Server 2008 R2 database to SQL Server 2012 and getting syntax errors
- SQL Server make Column data undeletable
- Controls spill over to next page in RDLC Report
- SQL Qry required to get a comma separated string from a table
- How to make event/function in SQL Server 2008 R2 database instead of VBA Macros?
- How to delete oldest week(period) in MS SQL database?
- SQL Server 2008 R2 Express 10GB Filesize limit
- SQL Server 2008 R2 Express cant connect to my editors
- SQL Server Login failed for user after a couple hours
- SQL Server 2008 R2 Recordset apears not created
- Simple SQL Bulk Insert not working
- Read from Database and Insert into DataGridView
Related Questions in MAINTENANCE-PLAN
- Unable to select filegroups in a Back Up Database Task of a Maintance Plan
- Time between constrained datatimes
- Is there a known API or module to automate Start/Stop activity for IBM WebSphere application servers with RPA?
- Code reusability issue when creating API with Flask
- Way to ensure maintenance plan attempts every stored procedure?
- SQL rebuild Index Maintenance Plan is missing the Index Stat Option to set fragmentation percentages?
- Getting a 503 for the resources as well while setting up for a maintenance page in NGINX
- Maintenance tasks on Azure SQL Managed instance
- How do I maintain zabbix for MongoDB backup? with ansible
- Azure Used Vs Allocted Vs Maximum in elastic pool
- SQL Server 2016 Maintenance Plan Editor - Add Annotation Not Working
- calculating MTBF in Excel
- Do re-indexing of database runs automatically with CRM app?
- How to handle maintenance process with React
- SQL Maintenance Plan - Determining Duration of Steps
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?
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)
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: