On October 19, 2021, we have enabled single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
If you had already registered your account at MyPlesk.com/Plesk360/Platform360 please use one for login. Otherwise please re-register it using the same email address as your existing Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account.

Articles in this section

See more

Copy database not working: no errors are shown in Plesk GUI

Avatar
Marc López
Updated
Follow
Plesk for Windows kb: bug ABT: Group A

Applicable to:

  • Plesk for Windows

Symptoms

  • Unable to clone a MSSQL database going to Plesk > Domains > example.com > Databases > Copy. The following error might be shown in Plesk GUI:

    PLESK_ERROR: Database cloning failed.

    or

    PLESK_ERROR: dbbackup failed: Command 'IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PenultimoMarcajeFecHor]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT')) [details]

  • One of the following errors is shown in %plesk_dir%admin\logs\php_error.log after enabling Plesk debug:

    CONFIG_TEXT: ERR [1] "C:\Program Files (x86)\Plesk\admin\bin64\dbbackup" --copy "-server-type=mssql" -with-data "-src-server=.\MSSQLSERVER2016" "-src-port=0" "-src-server-login=dbadmin" "-src-server-pwd=******" "-src-database=originaldb" "-dst-server=.\MSSQLSERVER2016" "-dst-port=0" "-dst-server-login=sa" "-dst-server-pwd=******" "-dst-database=cloneddb" failed with code 21. stdout: Command 'IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[tablename]')) EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[Active_tablename] AS SELECT.... FROM.... WHERE... ''Active'') ' ' failed Invalid object name 'dbo.tablename'.
    ERR [panel] Task failed: id=3717, pid=43812, type=db-clone, error=Database cloning failed.

    CONFIG_TEXT: ERR [1] "C:\Program Files (x86)\Plesk\/admin/bin/dbbackup" --copy "-server-type=mssql" -with-data "-src-server=.\MSSQLSERVER2016" "-src-port=0" "-src-server-login=dbadmin" "-src-server-pwd=**********" "-src-database=originaldb" "-dst-server=.\MSSQLSERVER2016" "-dst-port=0" "-dst-server-login=sa" "-dst-server-pwd=**********" "-dst-database=cloneddb" failed with message: Command 'IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbadmin].[fu_getvalue]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT')) BEGIN execute dbo.sp_executesql @statement = N'CREATE FUNCTION fu_getvalue ... END ' failed There is already an object named 'fu_getvalue' in the database.
    ERR [panel] Task failed: id=861, pid=1580, type=db-clone, error=Database cloning failed.

Cause

This is a Plesk bug ID #PPPM-6901 which is planned to be fixed in future Plesk updates.

Resolution

As a workaround:

  1. Log in to Plesk GUI

  2. Export and then Import MSSQL database going to Domains > example.com > Databases > Export Dump/Import Dump:

Comments

4 comments

Sort by Date Votes
  • Avatar
    Marco Marsala

    Time to fix it. Never saw this feature working.

    0
    Comment actions Permalink
  • Avatar
    Lev Iurev

    @Marco we will do our best to fix this issue soon, but no ETA yet.

    0
    Comment actions Permalink
  • Avatar
    Ccoltman

    April 2020, still same error and no fix

     

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    @Ccoltman, for now, no ETA for this issue to be fixed. Please, stick to the provided workaround.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles