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

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%adminlogsphp_error.log after enabling Plesk debug:

  ERR [1] "C:Program Files (x86)Pleskadminbin64dbbackup" --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.

  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: