Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
.zip files erased after failed job Options · View
iCone
#1 Posted : Thursday, June 21, 2012 4:09:31 PM Quote
Rank: Member


Groups: Registered

Joined: 5/9/2012
Posts: 20
Why if the job fails for whatever reason after successfully compressing the .bak file the compressed files are deleted?

Have encountered situations on where the backup files location becomes unreachable and the compressed files are deleted on the temp folder leaving me without a backup. Is there a way to avoid that?
AlexP
#2 Posted : Friday, June 22, 2012 2:34:54 AM Quote
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 433
Do you want to keep .bak files in temporary folder if job execution has failed for whatever reason?
iCone
#3 Posted : Friday, June 22, 2012 10:10:37 AM Quote
Rank: Member


Groups: Registered

Joined: 5/9/2012
Posts: 20
AlexP wrote:
Do you want to keep .bak files in temporary folder if job execution has failed for whatever reason?


If the job failed because the destination was unreachable I would like to have the .zip in the temp folder and deal with it manually, is better than having nothing.

If the job fails for any other reason it may be incomplete, corrupt or unusable so it will have no use.

Is what I'm asking for possible?
AlexP
#4 Posted : Saturday, June 23, 2012 11:56:29 AM Quote
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 433
Hi,

We aren't planning to implement this behavior. I believe in this case we'd get feedback with an issue of cleaning up temporary folder and saving disk space. Many users are using large databases.
Please use email notifications for failed jobs to make decisions immediately or backup to folders in addition to FTP.
iCone
#5 Posted : Thursday, June 28, 2012 3:26:16 PM Quote
Rank: Member


Groups: Registered

Joined: 5/9/2012
Posts: 20
Understand the possible issue of filling up the disks and can relate because my db's are over 140Gb but if the FTP or network access fails the backup files will be deleted, I would prefer to manually compress and erase temp files than loosing my backup.



Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can 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 MySql Backup MySql Backup to cloud Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups