What are the challenges you face when working across database platforms? Take the survey
Options

Backup to USB drive (1 TB) is failing

faisfais Posts: 21
edited February 11, 2009 11:43PM in SQL Backup Previous Versions
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.

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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.
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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 .
Sign In or Register to comment.