vCenter SQL Express Database – maintenance: SQLscheduler!
I think that SQL 2005 Express Edition is the most famous database chosen by ‘’smaller’ companies that work with a Vmware virtual Infrastructure.
This free database platform is perfect to use for ESX-environments with 5 ESX-hosts maximum. One of the most important limitations of this Express version are the maintenance features which are not possible within the SQL Management Studio…
For scheduled backups p.ex, you will need the commandline, but also here there are not much possibilities to maintain your backup schedules…
I discovered the following tool, and this one answered my needs in this: SQL scheduler 2.0
Features:
- Supports all versions of SQL Server 2000 and 2005
- Supports unlimited SQL Server instances with an unlimited number of jobs.
- Schedule SQL Server maintenance tasks: backups, index rebuilds, integrity checks, etc.
- Runs as Windows Service
- Email notifications on job success and failure
- And more…
You can download this free tool from here: http://www.lazycoding.com/products.aspx
Register this software as a Windows service and schedule your SQL backups within a GUI interface!