This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 9%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 84%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
If the reply above was helpful please mark as accepted answer so it can be helpful for other community members with same questions.
Regards
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.
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.
I want to schedule back-up (Every Day) my databases via ssms-18 with back-up file name format "databasename_back-up date_back-up time.bak". Can you help me to solve this?
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.