Error 570: File is not a SQL Backup file.
I have a job to restore 10 production database on Test server.
Right now the problem that I am facing is : Sometimes 7 are successful restore and 3 fails with the following error : Error 570: File is not a SQL Backup file. and database goes into recovering state and then stays there. ( non funtional )
Then I have to manually delete the databases and then clean the files and then start the restore again. with my second attmept, all are restored successfully with same backup files .
Can anyone help to alleviate this issue.
I am using SQL Backup version : 184.108.40.206