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

Question

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.

Answer 1

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.

Answer 2

Hi @Gowrab Das Dip ，

On Linux Server, maintenance plans are not supported

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.

Answer 3

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.