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.


#11

Hi Tony_Pitwood,

Could you please clarify, do you still have this issue?

If yes, please send us the advanced log to check it. Here are more details on how to do it https://sqlbackupandftp.com/blog/how-to-send-log-to-developers

Please let us know when the log will be sent, also please provide us with the Application ID (“Help” > “About”) to identify the log.

Sorry for the inconvenience.


#12

Hi Alexandr,

Yes, the error still recurs – I have sent the Log to the Developers from
Advanced Logging and here are the details you asked for

SQLB2

Kind regards
Tony


#13

Hi Tony,

Thank you for the log, please give us some time to check it.

Sorry for the inconvenience.


#14

Hi Tony,

We have checked your log and found out that the user from behalf whom SQL Server runs (as a rule it NT Service\MSSQLSERVER) doesn’t have enough permission to the selected folders in the backup.

Could you please check it?

Sorry for the inconvenience.


#15

I did what I did before - went to C:\Windows\Temp folder - no SYSTEM folder but Pranas.net was there.
I tried to give full permission to Everyone but it came back with errors.
I then went to C:\Program Files\Microsoft SQL Server\MSql11.sql2012exp\backup folder and
gave full permission to Everyone.
And now it works!!!
Thanks for your help- I’ll see if it happens again
Kind regards
Tony


#16

Hi Tony_Pitwood,

That’s great! Thank you for your reply.

Please feel free to contact us on any issues or concerns.