Backup with multiple files: Error:

DineshDinesh Posts: 14
edited November 17, 2006 3:32AM in SQL Backup Previous Versions
Hi

I tried to break the backup file into 10 and I got below result. Another problem is we cannot remove files once we added (see first two files). Isn't possible?

Backing up MyDB (full database) to:
E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\FULL_(local)_MyDB_20061116_165639_01.sqb
E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\FULL_(local)_MyDB_20061116_165639_02.sqb
G:\Dinesh\FULL_(local)_MyDB_20061116_165639_1.sqb
G:\Dinesh\FULL_(local)_MyDB_20061116_165639_2.sqb
G:\Dinesh\FULL_(local)_MyDB_20061116_165639_3.sqb
G:\Dinesh\FULL_(local)_MyDB_20061116_165639_4.sqb
G:\Dinesh\FULL_(local)_MyDB_20061116_165639_5.sqb
G:\Dinesh\FULL_(local)_MyDB_20061116_165639_6.sqb
G:\Dinesh\FULL_(local)_MyDB_20061116_165639_7.sqb
G:\Dinesh\FULL_(local)_MyDB_20061116_165639_8.sqb
G:\Dinesh\FULL_(local)_MyDB_20061116_165639_9.sqb
G:\Dinesh\FULL_(local)_MyDB_20061116_165639_10.sqb


Thread 0 error:
Error 620: Error writing to backup file(s).
Process terminated unexpectedly. Error code: -2139684860
Thread 1 error:
Error 620: Error writing to backup file(s).
Process terminated unexpectedly. Error code: -2139684860
Thread 2 error:
Process terminated unexpectedly. Error code: -2139684860
Thread 3 error:
Process terminated unexpectedly. Error code: -2139684860
Process terminated unexpectedly. Error code: -2139684860
Thread 4 error:
Process terminated unexpectedly. Error code: -2139684860
Thread 5 error:
Process terminated unexpectedly. Error code: -2139684860
Thread 6 error:
Process terminated unexpectedly. Error code: -2139684860
Thread 7 error:
Process terminated unexpectedly. Error code: -2139684860
Thread 8 error:
Process terminated unexpectedly. Error code: -2139684860
Thread 9 error:
Process terminated unexpectedly. Error code: -2139684860
Thread 10 error:
Process terminated unexpectedly. Error code: -2139684860
Thread 11 error:
Process terminated unexpectedly. Error code: -2139684860


Server: Msg 3013
BACKUP DATABASE is terminating abnormally.
Server: Msg 3202
Write on "SQLBACKUP_126A8E4C-569D-4BC7-9FF4-E6309942C52801" failed: 112(There is not enough space on the disk.)
Server: Msg 3271
A nonrecoverable I/O error occurred on file "SQLBACKUP_126A8E4C-569D-4BC7-9FF4-E6309942C528:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).

SQL Backup exit code: 790
SQL error code: 3271

Comments

  • peteypetey Posts: 2,358 New member
    It appears that the first 2 files could not be created. Are you using the GUI to perform the backup? In that case, you can delete the unwanted files by selecting each file in the 'Destination files' list, and clicking on the 'Remove' button.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Hi Peter,

    Thanks for reply. The "Remove" button is not appeared in the screen (even after fully maximized) but tab stops somewhere (yes, it is Remove button) and that tab stop can be used to remove files added. Hope this bug exists only with trial version.

    And it worked. We'll be purchasing Pro soon.

    Thanks again
  • peteypetey Posts: 2,358 New member
    Could you pls send me a screenshot where the Remove button is missing, to peter.yeoh at redgate.com? Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Thanks for reply Peter. I sent the image for your account.
  • peteypetey Posts: 2,358 New member
    Thanks, I received your mail. What screen resolution are you using? It appears to be very wide and short, with large fonts?

    I'm having problems replying to your mail (keeps getting rejected). Could you pls download the patched GUI from http://www.yohz.com/downloads/SQLBackup.zip and let me know if that page appears fine now? Also, are there any other pages that appear 'weird'?

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Hi Pete,

    Sent some screenshots of backup procedure for both old and patched applications. Check and let me know.

    Thanks
Sign In or Register to comment.