MSSQL database export/import rename physical db name

Created:

2016-11-16 13:05:53 UTC

Modified:

2017-08-16 16:16:49 UTC

0

Was this article helpful?


Have more questions?

Submit a request

MSSQL database export/import rename physical db name

Applicable to:

  • Plesk 12.5 for Windows

Symptoms

When trying to export/import MSSQL database, the name of database and log will be renamed in %plesk_dir%\\Databases\\MSSQL\\YOUR_MSSQL_SERVER\\MSSQL\\DATA , for example, before the name was:

dbbase.mdf
dbbase_log.ldf

After export and import procedure the name will be changed to the following:

dbbase_dbbase_b2de9bfbfc9e454cab99699858aa8c15.mdf
dbbase_dbbase_log_1d9b2d44c63c4cc4a5c6b3df099cefe8.ldf

So if there were several attempted to import and export, the name will become longer. If it reached 256 characters, then backup starts to fail.

Cause

This is Plesk internal issue with id #PPPM-4974 , the fix will be included in the next Plesk updates.

Workaraound

  1. Download patch .
  2. Unpack the archive
  3. Go to %plesk_bin% directory (Paste %plesk_bin% into path line in Explorer).
  4. In this directory backup dbbackup.exe file
  5. Place patched dbbackup.exe from the archive to %plesk_bin% directory.

Attachments:

Have more questions? Submit a request
Please sign in to leave a comment.