Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Back Up Your Database With USB Expand / Collapse
Author
Message
Posted Monday, May 8, 2006 12:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 9, 2007 8:05 AM
Points: 3, Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kparks/backupyourdatabasewithusb.asp
Post #278395
Posted Wednesday, May 17, 2006 10:13 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, July 3, 2014 2:36 PM
Points: 631, Visits: 236

Add multiple HDs and you can also rotate backups offsite.

We find that for a multi-server backup solution, that a Firewire external HD provides better throughput than USB.

I use the native NTBackup, SQL Server backup, and a German product called Drive Snapshot. I take a new Snapshot after patching each server, so the server image is around a month old.

Coupled with BartPE w/ XPE and you have a great disaster recovery solution.

Andy




Post #280939
Posted Thursday, May 18, 2006 8:53 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 2, 2013 12:15 PM
Points: 1,443, Visits: 711

Excellent article!

I think in a true production environment, you'd have to add offsite storage.  Shipping hard drives off site could be tricky, dropping a hard-drive would be alot more costly than dropping a tape.

This might be ideal for backup and restore in a development or test environment where the data is a little less critical than production data...

(something to think about anyway)

Mark

Post #281116
Posted Thursday, May 18, 2006 1:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:30 PM
Points: 128, Visits: 448

Good article! I've used something like this in the past for database transfers.

 if you're going to use this in a production environment, be sure the first couple of times you plug in the USB drive you test thoroughly, with variable amounts of data.  We had a USB solution blue screen a system (consistently) when the data rose above 400GB. Other systems, the drive worked fine no matter the size of the data, YMMV.




Post #281231
Posted Friday, May 19, 2006 1:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 9, 2011 3:06 AM
Points: 9, Visits: 40

good article  I agree  being relatively new to this have having a single server with SQL 2K   I am intrigued by the concept  Bart PE..never heard of it..Ghost of course

Can yo explain to a simple person exactly what the setup is

Does the Server just have a Bart PE CD in its drive and a USB Drive attached ?? Do yo use another pc or similar ?? Can you schedule ??

This looks like exactly the type of emergency image I have been looking for

Ian

 




Post #281309
Posted Wednesday, May 24, 2006 5:59 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 3, 2014 9:19 PM
Points: 505, Visits: 1,691

I thought this was going to be an article about backing up to one of those portable keyring USB fobs.

Silly me. 

S.

 

Post #282634
Posted Tuesday, May 30, 2006 6:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 9, 2007 8:05 AM
Points: 3, Visits: 1

Bart PE is a modified version of windows XP that boots off and runs off a CD.  When you create a Bart PE CD, you can choose what software is installed on the installation.  Of course you have to have copies of the software you would like installed to create the CD.  The whole reason for the CD is to get Norton Ghost to work with your USB drive.  Creating a DOS usb boot disk for Norton Ghost is very challenging and may be impossible depending on the USB drive you have. 

Once you create the CD, you have to boot your server off the CD and use Ghost to image the OS partition.  Automating that would be rather challenging. 

Kevin Parks

 

Post #283532
Posted Tuesday, May 30, 2006 6:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 9, 2011 3:06 AM
Points: 9, Visits: 40

Ok  to follow on with my naivity ...

I create a Bart CD and also have Ghost loaded on it as well

and ???

I put the CD in my Server...then ???

Boot to CD or Drive     How do I keep everything running and create a USB Image simultaneously  or have I missed the point here




Post #283536
Posted Wednesday, June 14, 2006 12:44 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, July 3, 2014 2:36 PM
Points: 631, Visits: 236

In Windows you cannot replace the drive partition you are booted from, so there is a need to "boot from CD" to restore your C: drive.

BartPE is a GNA boot to mini-XP or mini-Win2003, so you can build an image that supports all the stuff that DOS cannot (NTFS, RAID, SAN, etc.).

The "roll your own" BartPE:

http://www.nu2.nu/pebuilder/

Is NOT for the faint of heart, so I suggest Realtogo:

http://www.reatogo.de/

And you will be booting your server and workstations from CD / DVD to restore an image of the machine, then update with what ever data file backup restoration that is appropriate for the machine. I use Firewire external HD to house the images (<machine>_<drive>_YYYYMMDD.SNA)

Have you seen:

http://www.storcase.com/infostation/5bay_sata.asp

For the image I use Drive Snapshot, it allows snapshot of an online production server and comes with a "map the image as a drive" feature to use Windows Explorer for those, "I just need a single folder/file restoration" times.

http://www.drivesnapshot.de/en/

Enjoy,

Andy




Post #287244
Posted Friday, July 7, 2006 9:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 7, 2006 3:20 PM
Points: 2, Visits: 1

I have considered a backup solution of this type before.  The thing that makes it a bit risky is the fact that your backup data is still connected to your server. If you were to contract a virus, the virus has access to your live production data files and your backup data files.  Having more then one harddrive to connect to the server lowers the risk a bit. Having four drives and using a different one for each week of the month maybe.  This plan too falls apart if you don't discover the virus in a relatively short amount of time.

 

Thanx,




Post #292854
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse