How can we help you today? How can we help you today?

Backup to USB drive (1 TB) is failing

All,

I am trying to backup a database of size 800 GB onto one terra byte usb drive, but this process is failing . Can anyone point me in right direction .Any help is appreciated.

I am able to backup other smaller databases onto the same drive. Also , dirve has lot of free space left on it.


Below is the log file:
SQL Backup log file 5.4.0.55

-SQL "BACKUP DATABASE I_C
 TO DISK = 'F:\Backups\d99db01\I_C_Full.sqb' 
WITH COMPRESSION = 3 "

-----------------------------  ERRORS AND WARNINGS -----------------------------


2/10/2009 4:58:04 PM: Backing up I_C (full database) to: 
2/10/2009 4:58:04 PM:   F:\Backups\d99db01\I_C_Full.sqb

2/10/2009 4:58:05 PM: BACKUP DATABASE [I_C]  TO VIRTUAL_DEVICE = 'SQLBACKUP_ECF3C02A-C6D7-4E9A-870D-750D70F6A38B' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (I_C), 2/10/2009 4:58:05 PM', DESCRIPTION = N'Backup on 2/10/2009 4:58:05 PM  Server: D99DB01  Database: I_C', FORMAT

2/10/2009 5:13:38 PM: Thread 0 error: 
Error 620: Error writing to backup file(s).
Process terminated unexpectedly. Error code: -2139684860
2/10/2009 5:13:38 PM: Warning 210: Thread 0 warning: 
Warning 210: Error writing to backup file:  F:\Backups\d99db01\I_C_Full.sqb
Warning: System error 112 (There is not enough space on the disk)
2/10/2009 5:13:38 PM: 
SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_ECF3C02A-C6D7-4E9A-870D-750D70F6A38B:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
SQL error 3202: SQL error 3202: Write on "SQLBACKUP_ECF3C02A-C6D7-4E9A-870D-750D70F6A38B" failed: 1117(The request could not be performed because of an I/O device error.)


Thanks.
fais
0

Comments

4 comments

Sort by
  • petey
    What was the size of the 'I_C_Full.sqb' on your thumb drive when the backup failed? What was the available space left on that drive?

    Thanks.
    petey
    0
  • fais
    I took the red gate backup for the same database , backup size was around 200 gigs ( level 3 compressions). But when I try to backup on USB drive, it fails.

    Compressed backup size = 200 gigs
    Free space on USB drive is 920 gigs.

    Thanks.
    fais
    0
  • petey
    When the error occurred, was the size of the backup file that was partially created also around 200 GB? It is helpful to know the size of the partially created file when SQL Backup failed to perform the backup.

    Thanks.
    petey
    0
  • fais
    Petey,

    Finally figured out the cause of failure.

    The 1 Terra byte USB drive was configured as FAT 32 . Later we conveted it to NTFS and everything was fine.

    Thanks .
    fais
    0

Add comment

Please sign in to leave a comment.