Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Another accidental DBA question. We have a DB instance that host 10 databases. This DB server doesn't have any maintenance plan set up. I want to set up a decent maintenance plan that will do a full database back up everyday and do an hourly transaction log back up. I tried clicking on new maintenance plan button from SSMS and it looks like the SQL server agent is not configured. I plan to enable this by running the following

 sp_configure 'show advanced options', 1;
 sp_configure 'Agent XPs', 1;

Then I plan to use the Maintainence plan wizard and set up my plan. Am I following the right route>? Do I have to watch for something while setting up the plan? Your advise is appreciated. Thanks

share|improve this question
Can you describe/show what your actual problem is? I can't tell from this. – Phil Sumner Jul 1 '14 at 15:51
up vote 7 down vote accepted

You can use Ola Hallengren's - SQL Server Maintenance Solution

This is much flexible than maintenance plans.

We have 300+ servers and we are using it for all our backups. It just works flawless.

To get you started :

share|improve this answer

While the maintenance plans aren't the most flexable things in the world, for someone who is only managing just a couple of servers, maintenance plans are perfect for you. The code you show in your question will enable the SQL Agent, then you can configure and schedule your maintenance plans.

You'll also need to go into the "SQL Server Configuration Manager" and configure the SQL Agent service to start automatically, and then start it.

share|improve this answer
to add to your post, there is a free book that give a good over view of maintenance plans -- Brad's Sure Guide to SQL Server Maintenance Plans. – DenisT Jul 1 '14 at 16:03

Simple answer: You are following correct path. You can create your own maintenance plan from MP wizard its easy and works fine. You don't need to use complex Ola Script.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.