Solved

Create Maintenance plans in SQL Server 2005

Posted on 2007-03-23
3
3,073 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
3 Comments
 
LVL 12

Accepted Solution

by:
craskin earned 50 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
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.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now