@waqasafzal
Ok, before enabling the Scheduled Database Backups option again follow the procedure below.
In the Exclude Tables setting of the Database Backups section on the iTSec plugin Settings page make sure the:
[prefix]_itsec_temp,
[prefix]_itsec_lockouts,
[prefix]_itsec_log
tables are excluded from the backup.
(Where [prefix] should be substituted with your database tables prefix).
Next check for the presence of wp-content/uploads/ithemes-security/backup.lock folder. Delete the folder manually if it exists.
Now login to your database using phpMyAdmin and if necessary select your database.
To view your database structure, click the Structure tab at the top of your phpMyAdmin window. In the Structure window, you can view the table names, the number of records in each table, the size of each table etc.
Identify the table(s) with 10000s or 100000s records.
Exclude that (those) table(s) from the iTSec plugin Database Backup.
Then try and create a backup manually. Click on the Create Database Backup button (it’s under the Backups tab). If the manual Database Backup completes successfully study the excluded tables. Ask yourself: what data is stored in that (those) table(s) ? Is there any point in including the data of those tables in a backup ? Can I delete all records from this (those) table(s)?
Often there are log tables holding many many many records of data which is useless.
In other words try and reduce the database footprint(size) if possible.
Once you are confident the database footprint is minimized and a manual Database Backup works you can try and enable the Scheduled Database Backups setting again …
dwinden