Article ID: 112847, created on Nov 18, 2011, last review on Aug 12, 2014

  • Applies to:
  • Plesk 10.3 for Windows

Symptoms

While trying to back up domain (e.g. domain.tld) with database (e.g. db_new) you get the following error:

<!--?xml version="1.0" encoding="utf-8"?-->
<execution-result status="warnings">
<object name="domain.tld" type="domain">
<message code="InformationalException" id="58c31b17-3a68-4023-a53a-d5c548203689" severity="error">
<description>Cannot dump database content db_new of type mssql'</description>
</message>
</object>
</execution-result>


In psadump.log you see the following:

15088: Info 21/01/2011 07:54:24.718 : Backup mssql database 'db_new'
15088: Error 21/01/2011 07:54:40.437 : 93720822-2288-4704-891e-6da8baf5362e Cannot dump database content db_new of type mssql' ( psadumpagent.InformationalException: Cannot dump database content fergus of type mssql' ---> psadumpagent.InformationalException: Unable to dump MS SQL database. Full-text is not supported on this edition of SQL Server. Database backup will be not included to Plesk backup. ---> Microsoft.SqlServer.Management.Smo.UnsupportedFeatureException: Full-text is not supported on this edition of SQL Server. at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CheckVersionNotExpress(String uft) at Microsoft.SqlServer.Management.Smo.Database.get_FullTextCatalogs() at psadumpagent.MsSqlScriptGenerator.getObjectsWithoutDependenciesSupport(Server server, Database database, ScriptOperation operation) at psadumpagent.MsSqlScriptGenerator.GenerateDatabaseScript(String dumpFilename) at psadumpagent.MsSqlDatabaseProvider.doDump(DumpEnv env, Object Owner, Database database, DbServer dbserver, DumpParams dumpParams) --- End of inner exception stack trace --- at psadumpagent.MsSqlDatabaseProvider.doDump(DumpEnv env, Object Owner, Database database, DbServer dbserver, DumpParams dumpParams) at psadumpagent.DatabaseProvider.dump(DumpEnv env, Object Owner, Database database, DbServer dbserver, DumpParams dumpParams) at psadumpagent.DumpEnv.dumpDatabaseContent(Object owner, Database database, DbServer dbServer) --- End of inner exception stack trace --- )

Resolution

Use the file attached to substitute the original one (not to back up the original file in order to revert changes if necessary). If backup still fails with the same error, replace psadumpagent.dll with this one.

Attachments

f2d85fccc955a226f0b30e58456170cb a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 c796c01d6951fa24ed54c7f1111667c6 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF