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.