Backup to USB 2.0 drive

Any reasons why backing up to a USB 2.0 HD would be bad? It's quick, easy,
and cheap. The main server is running low on storage and want to offload my
online backups ... thought this would be a cheap solution. The only backups
happening during production are log backups which are only at most 2mb.
Shaun Beane, MCDBA, MCT
http://dbageek.blogspot.com
Shaun,
I wouldn't do this in a corporate environment, but I might consider it
at home for pet projects. I always prefer to backup to local disk first,
and then xcopy/robocopy the file elsewhere, or get a tape backup agent
to grab it.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Shaun Beane wrote:
> Any reasons why backing up to a USB 2.0 HD would be bad? It's quick, easy,
> and cheap. The main server is running low on storage and want to offload my
> online backups ... thought this would be a cheap solution. The only backups
> happening during production are log backups which are only at most 2mb.
>
|||I agree, but I'm running low on disk space and mr. big boss man doesn't want
to spend the money on an additional drive for the raid. I can get a USB 2.0
drive for about 100 bucks. I would be backing up to the local USB drive
instead of local internal disk. Then I would backup to tape from there.
Shaun Beane, MCDBA, MCT
http://dbageek.blogspot.com
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:eRV7zzMyEHA.4028@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Shaun,
> I wouldn't do this in a corporate environment, but I might consider it at
> home for pet projects. I always prefer to backup to local disk first, and
> then xcopy/robocopy the file elsewhere, or get a tape backup agent to grab
> it.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Shaun Beane wrote:
|||For an additional 99 bucks, you could get MiniSQLBackup which ought to be
able to compress your backups to averagely 25% of their original size, and
then have it copy it to your USB drive upon completion. E.g. of syntax:
BACKUP mydb TO DISK = 'F:\Backups\db.bak' WITH COPYTO = 'U:\Backups\';
Or if you perform the backups manually, you could even use the free edition.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!