![]() ![]() In my case, I’m running demos and love the fact that reinstalling SQL Server only took a few minutes. IndexOptimize uses the SQL Server ALTER INDEX command: REBUILD WITH (ONLINE ON) to. So, Backups are important! Even in Linux. SYSTEMDATABASES, All system databases (master, msdb, and model). Make sure the status is: active: (running)! In Ubuntu I use the following command to check the status of my SQL Server instance: The AnswerĮxecute the following command in the user contextĪnd, will be seen this added to the SQL Server 2017 Linux documentation. To my surprise! I got a quick response which I appreciate very much. I look everywhere for more information but found no blog post or any documentation about it. The following message was logged in the log event: (see Image)Ĭommand executed, looking at the last log entry: “ sudo cat /var/opt/mssql/log/system_health_0_131668975728890000.xel” Back in March 30th, I posted a suggestion on SQL Server forum, about there was no documentation on how to rebuild SQL Server System database(s) in Linux.įor some reason, I finished doing an “ sudo apt update” follow by the “ sudo apt upgrade“, and after doing some OS updates “ my SQL Server stopped working”.
0 Comments
Leave a Reply. |