Articles in this section

See more

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

Avatar
Marc López
Updated
Follow

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

2 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

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles