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 in case of discrepancies. Recreates any database users that are missing.

Examples:

plesk repair mssql - Check the availability of Microsoft SQL database servers and verify the integrity of Microsoft SQL databases and database users.

plesk repair mssql -connection - Check that the Microsoft SQL database servers registered in Plesk are available and can be connected to.

plesk repair mssql -database-users - Check that all Microsoft SQL database users created in Plesk exist on the database servers. Checks database users' privileges and corrects them in case of discrepancies. Recreates any database users that are missing.

 

Leave your comments on this page

Leave your feedback or question on this documentation topic below. For technical assistance, contact your hosting service provider or submit a request to Plesk support. Suggest new features for Plesk here. Discuss general questions on the Plesk forum. All offtopic comments will be removed.