Home > IT Answers > SQL Server > Software to automate backups for SQL Server 2...
Phrathepmali
30 pts.
0
Q:
Software to automate backups for SQL Server 2008 databases
SQL Server 2008, SQL managment Studio, Automated backup, SQL Server backup, Backup software, SQL Server backup and restore, SQL Server Management Studio, Backup & recovery
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.
ASKED: Jun 26 2009  4:44 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
47070 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=22022&LinkId=20476
-----------------------------

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.
Last Answered: Jun 26 2009  6:53 PM GMT by Mrdenny   47070 pts.
Latest Contributors: Phrathepmali   30 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

mrdenny   47070 pts.  |   Jun 29 2009  4:56PM GMT

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.

 
0