Category Archives: Knowledge Base

How to automate maintenance of your databases

database, Knowledge Base, maintenance

Maintenance of your databases is as important as regular backups. Once scheduled backups are set, the thought may appear that your data is safe and sound and it is, until a problem appears.

As a rule, databases don’t crash completely, but there may be a sharp decrease in performance because of server laсk of disk space or any other issues that can corrupt databases. That’s why it’s highly recommended not only to perform regular backups of your databases but also maintain them. Continue reading How to automate maintenance of your databases →

[JOB-BAK:1301#1] Failed to backup database. There is no destination selected to keep Full database backup type

adventureworks, database, Knowledge Base

If you get the following error message during a backup:

[JOB-BAK:1301#1] Failed to backup <database name> database with "Full" backup type: Failed to backup <database name> database. There is no destination selected to keep Full database backup type. Continue reading [JOB-BAK:1301#1] Failed to backup  database. There is no destination selected to keep Full database backup type →

[DST-1:1001#103] Destination error: Could not find a part of the path

amazon, Knowledge Base, settings

Typically, the following error message:

Destination error: Could not find a part of the path 'y:\1'.
Trying again...
Destination error: #[DST-1:1001#103] Failed to connect to the Folder destination. > Failed to create folder "y:\1". > Could not find a part of the path 'y:\1'.

Continue reading [DST-1:1001#103] Destination error: Could not find a part of the path →

Solved: [JOB-BAK:2006#11008] Previous Full backup of a database was created with a different application

Database Backup, Knowledge Base, SQL Server, sqlbackupandftp

During the backup you can face the following warning:

[Warning] [JOB-BAK:2006#11008]. The previous full backup of <database name> database was created with a different application (non-SQLBackupAndFTP). You may not able to restore the database automatically using SQLBackupAndFTP.

Continue reading Solved: [JOB-BAK:2006#11008] Previous Full backup of a database was created with a different application →

[DBMS-MSSQL:11006#11007] MySQL backup error: unknown variable ‘column-statistics=0’

full backup, Knowledge Base, sql backup job

The following error message:

[DBMS-MSSQL:11006#11007] MySQL backup error: unknown variable ‘column-statistics=0’

means that the version of mysqldump utility used by SQLBackupAndFTP to create MySQL backup doesn’t support the –column-statistics parameter (it should be older than 8.0.2). Continue reading [DBMS-MSSQL:11006#11007] MySQL backup error: unknown variable ‘column-statistics=0’ →