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.