SymptomsDomain containing MSSQL database cannot be restored. The following error is displayed:
Script execution error during restore database 'database_name': Incorrect syntax near the keyword 'user'.
Incorrect syntax near the keyword 'user'.
CauseThe reason of the problem is that user word is reserved for internal MSSQL purposes and in case of using it as name of table or column it should be quoted with square brackets during backup - [user]
ResolutionTo fix this, please download the following file:
and place it to %plesk_bin% folder.
Note: Please see how to install Plesk hotfixes properly.
%plesk_dir% is environment variable which points to Plesk installation folder. By default it is C:\Program Files\SWsoft\Plesk
%plesk_bin% is environment variable which points to Plesk binaries folder. By default it is C:\Program Files\SWsoft\Plesk\admin\bin