Thank you for your post into the SQL Backup 6 forum.
For what ever reason, Microsoft removed the SQL Agent from SQL Server Express Edition, hence why the SQL Backup GUI is indicating that the SQL Agent is not running.
Unfortunately SQL Backup does not detect that you have installed the SQL Backup Server components on a SQL Instance using the Express Edition. So the application allows you to create or run the Scheduled Backup Job wizard but in reality no job is created.
To workaround this problem, you need to use the SQL Backup Command Line and create batch files with the necessary parameters and keywords. Once you have created a batch file, use the Windows scheduler to to start the batch file .
An example batch file is as follows:
- Code: Select all
"C:\\Program Files\\Red Gate\\SQL Backup 6\\SQLEXP\\SQLBackupC.exe" -E -I SQLEXP -SQL "BACKUP DATABASE [AdventureWorks] TO DISK = 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.3\\MSSQL\\Backup\\<AUTO>.sqb' WITH DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, THREADCOUNT = 2"
Further information can be found HERE
under the Learning SQL Backup section ->Scripting SQL Backup section.