Can't find Maintenance Plan Task under Management and Toolbox options are grayout in MS Sql Server 2019 Standard edition.

Gowrab Das Dip 41 Reputation points
2022-10-13T06:30:05.303+00:00

249859-1.png249937-2.png

I have installed MS sql 2019 standard edition in our rhel 8 os. I have tried to create maintenance plan , but it seems disabled from ssms. I have already tried in SSMS 18.x and 19.x and find the same issue. please help me to get through over this problem.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,912 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 41,496 Reputation points
    2022-10-13T07:01:28.607+00:00

    I have installed MS sql 2019 standard edition in our rhel 8 os.

    Maintanance plans are not supported by SQL Server on Linux, see Release notes for SQL Server 2019 on Linux => SQL Server Management Studio (SSMS) => Maintenance plans aren't supported.

    0 comments No comments

  2. YufeiShao-msft 7,061 Reputation points
    2022-10-14T03:20:53.157+00:00

    Hi @Gowrab Das Dip

    On Linux Server, maintenance plans are not supported

    250292-image.png

    As an alternative, you can try to create your own SQL Server jobs to perform backups, index and statistics maintenance, you can check out this article: SQL Server on Linux: Running jobs with SQL Server Agent

    -------------

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  3. Olaf Helper 41,496 Reputation points
    2022-10-17T05:46:33.23+00:00

    I want to schedule back-up (Every Day) my databases via ssms-18

    SSMS is just a tool/frontend.
    Use a Linux CRON job to schedule backup the databases:
    https://www.freecodecamp.org/news/cron-jobs-in-linux/#:~:text=Cron%20is%20a%20job%20scheduling,other%20commands%20to%20run%20automatically.

    0 comments No comments