Let me clarify a bit on what I’ve said above. I realize a maintance plan can be created and I have tried this however upon execution of that plan I am getting the following error:
TITLE: Execute Maintenance Plan
Execution failed. See the maintenance plan and SQL Server Agent job history logs for details.
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
SQLServerAgent is not currently running so it cannot be notified of this action. (Microsoft SQL Server, Error: 22022)
I am either looking for a remedy to this problem or an alternate software solution which also allows automation of the backup process.
Start the SQL Agent Service, and set it to start automatically.