none
SQL Server 2008 R2 Missing Maintenance Plan Wizard

답변

  • Which Edition of SQL Server 2008 R2 are you using? If you are using SQL Server 2008 R2 Express, this feature will not be available.


    Pradeep Adiga
    My blog: http://www.sqldbadiaries.com

    Recent posts on my blog
    2010년 11월 18일 목요일 오후 3:38
  • Hi,

    Pardeep is correct, all SQL Server 2008 R2 Editions have Maintenance Plan feature except Express Editions (Express Edition, Express with Toosl or Express with Advanced Services). For more information, you can refer to Features Supported by the Editions of SQL Server 2008 R2 (http://msdn.microsoft.com/en-us/library/cc645993.aspx).

    By the way, you can see Maintenance Plan node under Management if you use an Management Studio Express to connect an instance of non-express SQL Server; however you still could not see Maintenance Plan node under Management if you use non-express Management Studio to connect an express instance of SQL Server. (All these tests based on SQL Server 2008 R2/Express)

    Thanks,
    Chunsong


    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    2010년 11월 23일 화요일 오전 11:48
  • I would suggest that you look at the maintenance scripts provided by Ola Hallengren - http://ola.hallengren.com/

    Implement these and then run the resulting sp's as windows scheduled tasks.

    Either that or script out your backups manually and schedule those as tasks. There is no SQL Sgent with the Express edition, so if you wish to schedule anything then the windows scheduler is your best bet.


    Richard Douglas Http://SQL.RichardDouglas.co.uk | @SQLRich
    2010년 11월 23일 화요일 오후 12:20

모든 응답

  • Which Edition of SQL Server 2008 R2 are you using? If you are using SQL Server 2008 R2 Express, this feature will not be available.


    Pradeep Adiga
    My blog: http://www.sqldbadiaries.com

    Recent posts on my blog
    2010년 11월 18일 목요일 오후 3:38
  • I perfectly agree with Pradeep, I have expirenced this issue "Maintenance Plan Wizard"  doesn't exist in SQL server 2008 R2 Express, and also when you have Sql Server Management Studio Express Edition.

     

     


    Best Regards Don't forget to mark it as answer if it helps
    2010년 11월 18일 목요일 오후 4:05
  • Hi,

    Pardeep is correct, all SQL Server 2008 R2 Editions have Maintenance Plan feature except Express Editions (Express Edition, Express with Toosl or Express with Advanced Services). For more information, you can refer to Features Supported by the Editions of SQL Server 2008 R2 (http://msdn.microsoft.com/en-us/library/cc645993.aspx).

    By the way, you can see Maintenance Plan node under Management if you use an Management Studio Express to connect an instance of non-express SQL Server; however you still could not see Maintenance Plan node under Management if you use non-express Management Studio to connect an express instance of SQL Server. (All these tests based on SQL Server 2008 R2/Express)

    Thanks,
    Chunsong


    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    2010년 11월 23일 화요일 오전 11:48
  • I would suggest that you look at the maintenance scripts provided by Ola Hallengren - http://ola.hallengren.com/

    Implement these and then run the resulting sp's as windows scheduled tasks.

    Either that or script out your backups manually and schedule those as tasks. There is no SQL Sgent with the Express edition, so if you wish to schedule anything then the windows scheduler is your best bet.


    Richard Douglas Http://SQL.RichardDouglas.co.uk | @SQLRich
    2010년 11월 23일 화요일 오후 12:20
  • I was misled by all these replies.

    Yes, it is true that only SQL Server 2008 Full versions have the maintenance plans available. But what misled me is that there is another answer too:

    If the user you access the SQL-database with is not member of the sysadmins-group, the maintenance-plan part of the management folder will be hidden. Go to security in the SQL Server and add the user you are logging into the SQL-server with, and you will find that the maintenance-plan option is suddenly visible.

    2012년 7월 11일 수요일 오후 2:47
  • Remember that the account used also needs to have rights to see "maintenance plan". The administrator account doesn't necessarily have those rights, or they can have been removed.

    Ian

    2012년 9월 10일 월요일 오후 4:51