?
Solved

Create Maintenance plans in SQL Server 2005

Posted on 2007-03-23
3
Medium Priority
?
3,082 Views
Last Modified: 2012-08-13
I cant create maintenance plans in SQL Server 2005. I can se the Mainteance plans folder in SQL Server Management Server Studio Express / Object Explorer. But when i right click to create a new maintenance plan I just see Reports

I have installed SSIS
0
Comment
Question by:OfficeVaxjo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 12

Accepted Solution

by:
craskin earned 200 total points
ID: 18780791
sql 2005 express does not include the sql agent, so you won't be able to use the built-in maintenance snap-in. but you can use stored procedures to accomplish much of the same thing. have a look at

http://www.sqldbatips.com/showarticle.asp?ID=27
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question