Hi Team,
Greeting!
We have found bug that, my database got corrupted and some how SQLFTPBACKUP tool continually taking backup successfully without any error why ?
We are confident that our backup is run perfectly but whe we have checked backup to restore it give error and unable to restore.
Please reply we want solution from SME’s.
Hello,
Thank you for your message.
Please try using the “Enable checksum” and “Verify After Backup” checkboxes as shown in the provided screenshot, as they may help detect certain scenarios of database corruption.
However, the primary reason why SQLBackupAndFTP can backup a corrupted database is related to the fact that the backup operation for SQL Server does not inherently detect corruption errors. To detect database corruption, you’ll need to use other tools.
Let us know if you need further assistance.
Regards,
Oleg