compact database backups

Question

compact database backups

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

river1 SSC-Insane Points: 24309 More actions · Answer 1

ok, but suppose this enviroment:

You are in Africa , you can a very poor connection to internet. You need to send a file to FTP, but that file as 200MB witch take 3 hours to upload to the FTP.

What will i gain in using the RapidShare if the Pc from where i'm sending the file is very slow (connection very slow)?

Lowell SSC Guru Points: 323518 More actions · Answer 2

even with the maximum compression settings a backup file that compresses to 200meg might go to 189meg with higher compression; there is no miracle compression that will shrink a gig to 10 meg;

a big backup compressed,is going to be slow through;

maybe you could consider doing some replication or log shipping instead? then after the one initial load, only changes get sent over, which would be much smaller than the original load?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

river1 SSC-Insane Points: 24309 More actions · Answer 3

no, we do not have internet all the time. sometimes we are without internet for 1 or 2 days...

river1 SSC-Insane Points: 24309 More actions · Answer 4

and we do not have direct connection between the two places to do the replication...

Lowell SSC Guru Points: 323518 More actions · Answer 5

replication does not require a constant connection; merge replication, for example, would stack up untill it got PULLED; log shipping would be up to the other end to grab and apply the logs;

read up on both methods, i really think it can do what you need it to do.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 6

river1 (4/30/2010)
How can i implement a thing like that? so that only the company (across AFRICA) can use it?
At this moment we put the files in a FTP Server, but the files (backup files) are very BIG so it takes many time to do...

get ready to pay up

there is a product called HyperIP that we've been using for years. Can't remember if EMC bought them or if they are still a separate company. you buy 1-2 appliances per site and they compress your network traffic. forgot how much it costs per year.

HP and others also make appliances that do similar things, but they may only be for file shares. not 100% sure. also check out Cisco, Juniper and other networking gear that may do TCP/IP compression