We have a IBM xSeries server running MSSQL 2000 and Legato's HSM software. Every night we back up our 12 G SQL database up to tape, but we would also like to make a disk backup of the database.
I was thinking we could just attach an external USB hard drive and put a backup of the database on that every night as well.
Any idea that would work? How long would it take to backup a 12 GB database across a USB cable?
06-09-2005, 09:53 PM
Yeah it would work....but I think it would take a while. I say get a Lacie Big Disk 500GB or something, which is Firewire 800...then pick up a firewire 800 card and away you go :)
Only thing is that FW800 stuff is kinda expensive......but hellishly fast ;)
06-10-2005, 03:19 AM
I just copied 40GB to my external which was USB 2.0 day before last and it didn't take too long, maybe 30 minutes or something, I don't remember for sure but it wasn't too long.
06-10-2005, 09:55 AM
yeah well it would depend on how quickly they want it done..but if it is over night its doesn't matter. Well USB 2.0 isn't that slow - isn't it actually faster than firewire 400? I thought USB2 was 480mbps compared to firewire 400 being 400mbps?
06-10-2005, 03:49 PM
Lot's of help, thank you. One more thing. How can I tell if this server's ports are USB 2.0?
06-10-2005, 07:04 PM
How old is the server? Anything under 3 years old I would image would have USB 2.0.
Can't you check through Device Manager? (sorry I can't think today :eek: )