Parallels Virtualization and Automation Software

SYMPTOMS

Domain 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'.

CAUSE

The 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]

RESOLUTION

To fix this, please download the following file:

http://download1.swsoft.com/Plesk/Autoupdate/Windows/8.2.0/124965/psabackup.dll

and place it to %plesk_bin% folder.

Note: Please see how to install Plesk hotfixes properly.



 

Additional information

%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