Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Back Up Your Database With USB


Back Up Your Database With USB

Author
Message
kevin parks
kevin parks
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kparks/backupyourdatabasewithusb.asp
David A. Long
David A. Long
Right there with Babe
Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)

Group: General Forum Members
Points: 739 Visits: 237

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





SuperDBA-207096
SuperDBA-207096
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1599 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


CDA
CDA
SSC-Enthusiastic
SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)

Group: General Forum Members
Points: 170 Visits: 528

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.





ianM
ianM
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 41

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





Fal
Fal
Mr or Mrs. 500
Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)Mr or Mrs. 500 (528 reputation)

Group: General Forum Members
Points: 528 Visits: 1803

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

Silly me.

S.


kevin parks
kevin parks
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 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


ianM
ianM
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 41

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





David A. Long
David A. Long
Right there with Babe
Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)

Group: General Forum Members
Points: 739 Visits: 237

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





kilroy70
kilroy70
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 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,





Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search