imran786
asked on
Data transfer rate and appropriate backup solution
We have 50 GB MS SQL Data base. After 3 years its will be Max.100 GB.
I found may backup solution.
Which one is good for us. We are looking more economic and little professional.
Is all DTR correct?
ATA =133
SATA =150MB/s
SATA2 =300MB/s
USB = 12 Mb/s
USB2 = 480 Mb/s
Firewire 400 = 400 Mb/s
Firewire 800 = 800 Mb/s
LTO1 = 40 MB/s
LTO2 = 80 MB/s
LTO3 = 160 MB/s
I found may backup solution.
Which one is good for us. We are looking more economic and little professional.
Is all DTR correct?
ATA =133
SATA =150MB/s
SATA2 =300MB/s
USB = 12 Mb/s
USB2 = 480 Mb/s
Firewire 400 = 400 Mb/s
Firewire 800 = 800 Mb/s
LTO1 = 40 MB/s
LTO2 = 80 MB/s
LTO3 = 160 MB/s
Yes, those are data transfer rate. Which one will you buy?
You wil lneed a program that can backup SQL files while open, or else you will need to shut down the SQL server while backing up.
Is this an on- site backup, or something that will be taken off site.
In general. Tape is the most convenient backup.
Other options include using an eSATA drive in an external box- fast and fairly cheap.
I hope this helps !
Is this an on- site backup, or something that will be taken off site.
In general. Tape is the most convenient backup.
Other options include using an eSATA drive in an external box- fast and fairly cheap.
I hope this helps !
ASKER
Thanks Sysexpert,
tape backup is fast and convenient
but tape drive maintenance,
tape (cartridge) need to be changed always Monthly (depend on usage)
IF you want to restore to another server you need another drive.
Drive is expensive.
On site backup is already there in local drive of the server.
We are Looking something for off site backup.
We have some backup software.
Now is best for us......
tape backup is fast and convenient
but tape drive maintenance,
tape (cartridge) need to be changed always Monthly (depend on usage)
IF you want to restore to another server you need another drive.
Drive is expensive.
On site backup is already there in local drive of the server.
We are Looking something for off site backup.
We have some backup software.
Now is best for us......
ASKER
If you use Sata,
Does Sata prompt for selection when connected like USB.
Does Sata prompt for selection when connected like USB.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.