Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
ZIP Temporary Work Area on C: Drive Options · View
jlee
#1 Posted : Saturday, April 09, 2011 10:11:14 PM Quote
Rank: Newbie

Groups: Registered

Joined: 4/9/2011
Posts: 1
During the ZIP phase of the the SQLBACKUPandFTP, the C: drive is used at the temporary location of the compress file until the ZIP process is completed and then it is moved to the designated drive and folder area. How can you change this ZIP temporary work area to another location as in another drive than using the C: drive. In our shop we designate the C: drive as our system drive only and use other logical partition for data, work areas, etc.
mikeshilov
#2 Posted : Sunday, April 10, 2011 11:44:20 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Try the following:

1. go to "Advanced Settings"
2. in "Large database dackup" section specify "Temporary folder"
3. in "Compression Settings" section check "Zip to temporary folder before moving to a network location"

BR,
Mike
Guest
#3 Posted : Thursday, April 14, 2011 3:03:21 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 732
Thanks for the reply Mike. 5.5.x version doesn't require checking the box for ZIPing in the temporary location, the code must default to use the path if one is entered in the write sql backup to temporary location. The 4.3.x version doesn't honor either of the entries; it will zip in the windows\temp or the user's local settings temp folder on the C: drive. We will be upgrading to the v5.5.x to keep the zip from using the C: drive. thanks. JLee.
mikeshilov
#4 Posted : Thursday, April 14, 2011 3:40:43 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
You're right. In v5.5 we've upgraded the Zip engine to minimize using a temporary folder for zipping.
Taren
#5 Posted : Tuesday, May 24, 2011 10:25:00 PM Quote
Rank: Newbie

Groups: Registered

Joined: 5/24/2011
Posts: 1
Location: Brazil
jlee wrote:
During the ZIP phase of the the SQLBACKUPandFTP, the C: drive is used at the temporary location of the compress file until the ZIP process is completed and then it is moved to the designated drive and folder area. How can you change this ZIP temporary work area to another location as in another drive than using the C: drive. In our shop we designate the C: drive as our system drive only and use other logical partition for data, work areas, etc.



Thanks for the reply Mike. 5.5.x version doesn't require checking the box for ZIPing in the temporary location, the code must default to use the path if one is entered in the write sql backup to temporary location. The 4.3.x version doesn't honor either of the entries; it will zip in the windows\temp or the user's local settings temp folder on the C: drive. We will be upgrading to the v5.5.x to keep the zip from using the C: drive. thank

mikeshilov
#6 Posted : Wednesday, May 25, 2011 1:56:06 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
you are welcome
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.