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:
-
Export and then Import MSSQL database going to Domains > example.com > Databases > Export Dump/Import Dump: