Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
Permission Issue Options · View
LookIn
#1 Posted : Saturday, September 3, 2016 11:29:28 AM
Rank: Newbie

Groups: Registered

Joined: 9/3/2016
Posts: 2
Hello Team,

1. I setup remote backup on private same network server.

2. I did setup network share path on Advance option

3. I did setup required folder permission on sql server temp folder.

- Manual backup is working fine.

- If I schedule backup than it is giving error.

09/03/2016 09:00:16 Creating backup of ASIFD600 to \\WIN-J3AQCGA68V0\Temp\Pranas.NET\SQLBackupAndFTP\mcxo5bbe (full)
09/03/2016 09:00:17 Compressing (7-zip 7z, Level: Normal) ASIFD600201609030900.bak (Size: 11,355 KB) to \\WIN-J3AQCGA68V0\Temp\Pranas.NET\SQLBackupAndFTP\mcxo5bbe
09/03/2016 09:00:28 ERROR: Fatal error

7-Zip [64] 16.02 : Copyright (c) 1999-2016 Igor Pavlov : 2016-05-21

Scanning the drive:
0 files, 0 bytes

Creating archive: \\WIN-J3AQCGA68V0\Temp\Pranas.NET\SQLBackupAndFTP\mcxo5bbe\ASIFD600201609030900.7z

Items to compress: 0


Scan WARNINGS for files and folders:

\\WIN-J3AQCGA68V0\Temp\Pranas.NET\SQLBackupAndFTP\mcxo5bbe\ASIFD600201609030900.bak : Access is denied.

Scan WARNINGS: 1

Error:
cannot open file
\\WIN-J3AQCGA68V0\Temp\Pranas.NET\SQLBackupAndFTP\mcxo5bbe\ASIFD600201609030900.7z.tmp
Access is denied.
(2)
7-Zip [64] 16.02 : Copyright (c) 1999-2016 Igor Pavlov : 2016-05-21

Scanning the drive:
0 files, 0 bytes

Creating archive: \\WIN-J3AQCGA68V0\Temp\Pranas.NET\SQLBackupAndFTP\mcxo5bbe\ASIFD600201609030900.7z

Items to compress: 0


Scan WARNINGS for files and folders:

\\WIN-J3AQCGA68V0\Temp\Pranas.NET\SQLBackupAndFTP\mcxo5bbe\ASIFD600201609030900.bak : Access is denied.

Scan WARNINGS: 1

Error:
cannot open file
\\WIN-J3AQCGA68V0\Temp\Pranas.NET\SQLBackupAndFTP\mcxo5bbe\ASIFD600201609030900.7z.tmp
Access is denied.. Error: WARNING: Access is denied.
\\WIN-J3AQCGA68V0\Temp\Pranas.NET\SQLBackupAndFTP\mcxo5bbe\ASIFD600201609030900.bak



System ERROR:
Access is denied.
09/03/2016 09:00:28 Creating backup of ASIPG to \\WIN-J3AQCGA68V0\Temp\Pranas.NET\SQLBackupAndFTP\mcxo5bbe (full)
09/03/2016 09:00:28 Compressing (7-zip 7z, Level: Normal) ASIPG201609030900.bak (Size: 2,389 KB) to \\WIN-J3AQCGA68V0\Temp\Pranas.NET\SQLBackupAndFTP\mcxo5bbe
09/03/2016 09:00:39 ERROR: Fatal error


====================

Please suggest what could be possible error?

Thanks
LookIn
#2 Posted : Saturday, September 3, 2016 12:09:36 PM
Rank: Newbie

Groups: Registered

Joined: 9/3/2016
Posts: 2
Just to add on my previous error... If I change compression setting to .zip than it work fine with manual and automatic process.

So this looks like something related to 7-zip permission issue.

Please suggest what permission we need to give it to 7-zip to run on network?

Thanks
Alexander Omelchenko
#3 Posted : Monday, September 5, 2016 7:50:57 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 348
Please note remote backup feature is in permanent unsupported Beta because of the complexity of the task. Please find more information at http://sqlbackupandftp.com/remote/

To solve this issue we recommend you to install SQLBackupAndFTP at the same server or computer where SQL Server is installed.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com