Unable to run Restore job correctly


#1

Hi, We are hitting errors trying to restore backups from selected destination on the C:\ drive. We have been using SQLBackup for years very happily. This is happening on 4 different worksites (not connected)

How do I send you the error log? (txt file)
Cannot upload it - Tried copy and paste with BlockQuote


#2

Hi Tony_Pitwood,

You can just post the log as a text. All you need to do is to export your log and open it via any text editor, then copy and paste the text.

Please let us know if you have any issues.

Sorry for the inconvenience.


#3

17/10/2019 7:40 AM Connecting to SQL Server: 2005 SP3 Express Edition. .\SQLEXPRESS
17/10/2019 7:40 AM Connecting to Folder destination “C:\db2005\Jens”
17/10/2019 7:40 AM Searching files in “Jens” folder by “rent*” mask
17/10/2019 7:40 AM Found “10” files.
17/10/2019 7:40 AM Restoring “rent” database on “15 September 2019 03:47 PM” from backup of “rent” database
17/10/2019 7:40 AM Downloading file “rent201909151547.bak” to “C:\WINDOWS\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup\6f9fb256-37b9-4901-947f-502f531d6159”
17/10/2019 7:41 AM Downloading file “rent201909151547.zip” to “C:\WINDOWS\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup\6f9fb256-37b9-4901-947f-502f531d6159”
17/10/2019 7:41 AM Restoring “rent” database from files: “rent201909151547.bak”
17/10/2019 7:41 AM Failed to restore rent database. Cannot open backup device ‘C:\WINDOWS\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup\6f9fb256-37b9-4901-947f-502f531d6159\rent201909151547.bak’. Operating system error 5(error not found).
RESTORE FILELIST is terminating abnormally.
17/10/2019 7:41 AM Trying to restore the database from default SQL backup folder (c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup)
17/10/2019 7:41 AM Failed to restore rent database. Cannot open backup device ‘c:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\rent201909151547.bak’. Operating system error 5(error not found).
RESTORE FILELIST is terminating abnormally.
17/10/2019 7:41 AM Disconnecting from Folder destination “C:\db2005\Jens”
17/10/2019 7:41 AM Job “Restore Job - 2” finished with “1” errors
17/10/2019 7:41 AM Sending report to ${https://sqlbackupandftp.com/weblog?jobid=6b7c34b8-58d9-47e9-83e7-3e4b51db46e1|Web Log}.


#4

Hi Tony_Pitwood,

Thank you for the details. Please give us some time to check the issue.


#5

Hi Tony_Pitwood,

Could you please clarify, have you installed SQLBackupAndFTP on the same computer where your DBMS?

Sorry for the inconvenience.


#6

Hi Alexander,
Each pc has SQL Server 2012 Express running as well as SQLBackupFTP 12.2.10
I have just tried it now on one pc - making a backup and then trying to restore from that same backup - same errors (as pasted in previous query above) using a Restore job that I had set up
As I was typing the above, I thought let me try what you suggested - to restore from the History list on the right of the Backup job.
That worked OK.
My problem is that we are usually restoring Backups made on another pc, so I cannot work from the Backup History.
We haven’t had this problem before it started happening 3-4 weeks ago, but it’s already happened on 5 of my installations, and they want to know why it’s not working, and what am I doing about it? Am I going to source another Backup programme or what?
We have happily used your product for the last 5-6 years, and I would much rather have a solution.
Kind regards
Tony


#7

Hi Alexander, I received another email from support
The email address you have used to contact us is no longer supported, and all further emails can be lost. Please u
What does that mean?
I checked My Account and you’ve got my email address as
tonypitwood@gmail.com but if gmail is a problem could you add
info@revivalsoftware.co.za
Regards
Tony


#8

Hi Tony_Pitwood,

We have received an email from you on the email address that is no longer in use, and we check the inbox emails there very seldom. If you use that email for further contact with us, your request can be lost.


#9

Hi Alexander
Is there no possible solution to this problem of being unable to Restore?


#10

Hi Tony_Pitwood,

We are working on this issue, please give us some time to check it.