Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3089
  • Last Modified:

Create Maintenance plans in SQL Server 2005

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
OfficeVaxjo
Asked:
OfficeVaxjo
1 Solution
 
craskinCommented:
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now