Plesk Repair Utility: Microsoft SQL Server

Using the Plesk repair utility with the mssql aspect
checks the availability of Microsoft SQL Server database servers and
verifies the integrity of Microsoft SQL Server databases and database
users. The following options are specific to this aspect:

• -connection - Checks that the Microsoft SQL database servers
  registered in Plesk are available and can be connected to.
• -databases - Checks that all Microsoft SQL databases created in
  Plesk exist on the database servers. Recreates any databases that are
  missing.
• -database-users - Checks that all Microsoft SQL database users
  created in Plesk exist on the database servers. Checks database
  users’ privileges and corrects them if there are discrepancies.
  Recreates any database users that are missing.

Examples:

• plesk repair mssql - Checks the availability of Microsoft SQL
  database servers and verify the integrity of Microsoft SQL databases
  and database users.
• plesk repair mssql -connection - Checks that the Microsoft
  SQL database servers registered in Plesk are available and can be
  connected to.
• plesk repair mssql -database-users - Checks that all Microsoft
  SQL database users created in Plesk exist on the database servers.
  Checks database users’ privileges and corrects them if there are
  discrepancies. Recreates any database users that are missing.