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.logafter 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:
-
Export and then Import MSSQL database going to Domains > example.com > Databases > Export Dump/Import Dump:
Comments
4 comments
Time to fix it. Never saw this feature working.
@Marco we will do our best to fix this issue soon, but no ETA yet.
April 2020, still same error and no fix
@Ccoltman, for now, no ETA for this issue to be fixed. Please, stick to the provided workaround.
Please sign in to leave a comment.