Solved

Data transfer rate and appropriate backup solution

Posted on 2007-04-08
5
179 Views
Last Modified: 2013-11-14
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
0
Comment
Question by:imran786
  • 2
  • 2
5 Comments
 
LVL 39

Expert Comment

by:PUNKY
ID: 18872212
Yes, those are data transfer rate. Which one will you buy?
0
 
LVL 63

Expert Comment

by:SysExpert
ID: 18872801
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 !
0
 
LVL 1

Author Comment

by:imran786
ID: 18874371
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......
0
 
LVL 1

Author Comment

by:imran786
ID: 18874394
If you use Sata,
Does Sata prompt for selection when connected like USB.

0
 
LVL 63

Accepted Solution

by:
SysExpert earned 125 total points
ID: 18880019
I think that it should be defined as a normal drive with a drive letter, per eSATA drive that you connect.

I would not use USB as it is slow, and you may need to map the drive since USB is considered removable media, no matter what drive is hooked into it.

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Having issues meeting security compliance criteria because of those pesky USB drives? Then I can help you! This article will explain how to disable USB Mass Storage devices in Windows Server 2008 R2.
Lets start to have a small explanation what is VAAI(vStorage API for Array Integration ) and what are the benefits using it. VAAI is an API framework in VMware that enable some Storage tasks. It first presented in ESXi 4.1, but only after 5.x sup…
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question