Backup to Flash Drive

[Ray Lavelle]

I have a utility I wrote which can backup/restore my database as well
as schedule backups. This has always worked pretty well except when I
try to backup to a USB Flash Disk. When I use one of these the backup
fails. If I backup to the C:/ drive then copy it over to the disk it
works fine but when SQL Server tries to do it, it can't.
I am simply doing the following:

BACKUP DATABASE MyDatabase TO DISK = 'E:/backup.dat_bak' WITH INIT

Anyone know what could be going wrong?

[mck]

Re: Backup to Flash Drive


"Ray Lavelle" <bostonpartykid @yahoo.com> wrote in message
news:d8653140.0 309032311.36f02 596@posting.goo gle.com...[color=blue]
> I have a utility I wrote which can backup/restore my database as well
> as schedule backups. This has always worked pretty well except when I
> try to backup to a USB Flash Disk. When I use one of these the backup
> fails. If I backup to the C:/ drive then copy it over to the disk it
> works fine but when SQL Server tries to do it, it can't.
> I am simply doing the following:
>
> BACKUP DATABASE MyDatabase TO DISK = 'E:/backup.dat_bak' WITH INIT
>
> Anyone know what could be going wrong?[/color]

Have LocalSystem account (or account for SQL Server) privileges to access
flash disk?

[Simon Hayes]

Re: Backup to Flash Drive

bostonpartykid@ yahoo.com (Ray Lavelle) wrote in message news:<d8653140. 0309032311.36f0 2596@posting.go ogle.com>...[color=blue]
> I have a utility I wrote which can backup/restore my database as well
> as schedule backups. This has always worked pretty well except when I
> try to backup to a USB Flash Disk. When I use one of these the backup
> fails. If I backup to the C:/ drive then copy it over to the disk it
> works fine but when SQL Server tries to do it, it can't.
> I am simply doing the following:
>
> BACKUP DATABASE MyDatabase TO DISK = 'E:/backup.dat_bak' WITH INIT
>
> Anyone know what could be going wrong?[/color]

You might be seeing this issue:

http://support.microsoft.com/default.aspx?scid=kb;en-us;281345

Otherwise, can you clarify what you mean by the backup "fails"? Is
there an error message? Presumably the USB drive appears in Windows as
a local drive? And what result do you get if you execute this query:

exec master..xp_cmds hell 'dir e:\'

Simon

[Ray Lavelle]

Re: Backup to Flash Drive

It turned out that the problem was that backing up to a USB disk is a
lot slower so the command timed out. Simply increasing the
commandTimeout solved the problem.

sql@hayes.ch (Simon Hayes) wrote in message news:<60cd0137. 0309040634.7b13 ab50@posting.go ogle.com>...[color=blue]
> bostonpartykid@ yahoo.com (Ray Lavelle) wrote in message news:<d8653140. 0309032311.36f0 2596@posting.go ogle.com>...[color=green]
> > I have a utility I wrote which can backup/restore my database as well
> > as schedule backups. This has always worked pretty well except when I
> > try to backup to a USB Flash Disk. When I use one of these the backup
> > fails. If I backup to the C:/ drive then copy it over to the disk it
> > works fine but when SQL Server tries to do it, it can't.
> > I am simply doing the following:
> >
> > BACKUP DATABASE MyDatabase TO DISK = 'E:/backup.dat_bak' WITH INIT
> >
> > Anyone know what could be going wrong?[/color]
>
> You might be seeing this issue:
>
> http://support.microsoft.com/default...b;en-us;281345
>
> Otherwise, can you clarify what you mean by the backup "fails"? Is
> there an error message? Presumably the USB drive appears in Windows as
> a local drive? And what result do you get if you execute this query:
>
> exec master..xp_cmds hell 'dir e:\'
>
> Simon[/color]