Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

SQL Server 2017 on Linux System Databases Rebuild Option

For the longest time I've been running SQL Server 2017 GA in Ubuntu 17.10. But, recently, after a recent apt update/upgrade to the OS, it stopped working.

I can't find any documentation to rebuild the system databases as the message I'm getting from the log in the image provided.

It would be nice to have an option as "/ACTION=REBUILDDATABASE".

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    MaximonTrinidad shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  AdminMicrosoft SQL Server (Admin, Microsoft Azure) responded  · 

    You can run “/opt/mssql/bin/sqlservr —force-setup” in the context of the mssql user in order to recreate master/model/etc.

    We’ll also look to update our documentation for this. Thanks for asking!

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base