SQL Backup Jobs - Not Running...
- SQL Backup 4.6
- SQL Server 2005, Express Edition SP1
- Windows 2003, Standard Edition SP1
We are currently evaluating SQL Backup for use in our environment for full, nightly backups as well as log shipping. The SQL Backup price is very reasonable for the capabilities and features it offers.
In investigating the software we liked the fact that it has a â€œSQL Backup Agentâ€ â€“ in other words, some type of Windows service that is awake and â€œdoing its thingâ€. However, the problem that we have run into is the following â€“ it seems as though in order to execute a scheduled job, we need to have Microsoftâ€™s â€œSQL Server Agentâ€ (not to be confused with Red Gateâ€™s agent) installed. As you can see, with SQL 2005 Express Edition, this is simply not possible.
The following posts seem to point to the fact that Microsoftâ€™s SQL Server Agent is required:
http://www.red-gate.com/messageboard/vi ... php?t=2256
http://www.red-gate.com/MessageBoard/vi ... php?t=3338
This begs the question, what exactly is Red Gateâ€™s SQL Backup Agent doing? The only thing we can think of is that itâ€™s the service under which the backup/compression is performed â€“ rather than being an actual agent which wakes up from time to time in order to perform any potential jobs.
Can you confirm this and, if so, could you offer any potential solutions â€“ short of purchasing SQL Server 2005, Standard Edition?