Software to automate backups for SQL Server 2008 databases

30 pts.
Tags:
Automated backup
Backup and Recovery
Backup software
SQL
SQL Server 2008
SQL Server backup
SQL Server Management Studio
I am running SQL Server 2008 and I know how to create backups of this data manually using SQL managment studio but we are looking for a way to automate the process. Does anyone know of a product that can be utilized to do this? Or a way the managment studio can be set up to do this? It's not difficult to create backups of the database and transaction logs but it would be greatly more efficent if the process could be done on a schedule.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

——————————
ADDITIONAL INFORMATION:

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    According to the error you have provided the SQL Server Agent is not running. It needs to be started before you can run the maintenance plan. You can also get that error when creating a maintenance plan as the script which creates the job will through that error if the SQL Server Agent is not running. To start the SQL Agent, Open up Admin Tools, then services. Find the SQL Server Agent service and start it. Then you should be able to save your job and start it.
    66,365 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following