Article ID: 2274, created on Oct 19, 2007, last review on May 4, 2014

  • Applies to:
  • Plesk 8.2 for Windows

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.



 

AdditionalInformation

%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

b23c51a6195823476e308cc12db2be0e 85a92ca67f2200d36506862eaa6ed6b8 a914db3fdc7a53ddcfd1b2db8f5a1b9c c45acecf540ecd42a4bbfb242ce02b1d 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF