Link to home
Start Free TrialLog in
Avatar of cmdown
cmdown

asked on

Backup SBS2003 using external USB drives - Drive letter problem

Hi
I have an SBS 2003 R1 server that is using the built in backup system to backup to external USB drives.  The problem is that the backup keeps failing due to drive letter assignment.

Two external USB drives are used alternately

Both have been independently plugged into the server and assigned the drive letter G using the drive management console.

However, when backup runs it appears that one or the other drive is loosing its assignment and reverting to another drive letter.

Is there any way to lock the assignment so that whichever drive is used, the server will always automatically assign it the letter G.  Going into the drive management console each time is not an option for the end user.

Many thanks & Happy Christmas
Avatar of grakem
grakem

right click on my computer, click manage go into disk management and right click on the drive you want to use and assign drive letter (choose something high like R)

do the same with the other drive and ensure you plug them back into the same usb drives.

*sorry typo Same usb drives should be same usb ports
ASKER CERTIFIED SOLUTION
Avatar of Lee W, MVP
Lee W, MVP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cmdown

ASKER

I should have said that when I set up the backup, I plugged each drive into both ports and set the drive letter to G (ie total of 4 operations )

Leew - I'll have a look at your script. thx.
Avatar of cmdown

ASKER

Leew - could not access your page.  Error response as follows:

Microsoft OLE DB Provider for SQL Server error '80040e57'

String or binary data would be truncated.

/downloads/download.asp, line 20

I'm running IE7
Try again in 5 minutes - I'll have that fixed.

-Lee
Should be working now - a quick note:  The way I determine the drive is to use a FOR loop to look for a particular marker file.
USB drives are flakey and unreliable under the best of conditions.

My advice is to ditch it and move over to eSATA.

Much faster and far more reliable.
Avatar of cmdown

ASKER

Please close question.
cmdown,

Please close the Q yourself by either accepting one or more of the answers, or by following the instructions in the link I sent. The asker is always supposed to take care of closing his Q's.

Thanks,
rindi,
EE Cleanup Volunteer