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

Test backup error

Hi

Performed a backup of one of our test databases.

I hid the task to get on with evaluating the rest of the GUI. When the backup completed I noticed the pop up in the bottom right had a red X in it but the timeline and properties show the backup as successful.

The log had the following error in it

SQL Backup log file 6.0.0.339

-SQL "BACKUP DATABASE [AQUATEST] TO DISK = 'E:\SQLBackups\<SERVER>\Databases\<DATABASE>\<AUTO>.sqb' WITH ERASEFILES = 2B, PASSWORD = 'XXXXXXXXXX', DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, KEYSIZE = 256, THREADCOUNT = 3, VERIFY "
ERRORS AND WARNINGS


17/06/2009 16:21:57: Error: Rijndael: Invalid key size - 0
17/06/2009 16:21:57: SQL Backup process ended.

17/06/2009 16:21:57: Deleted msdb entries older than 10/06/2009 16:21:57
17/06/2009 16:21:57: Deleted local history entries older than 10/06/2009 16:21:57


PROCESSES COMPLETED SUCCESSFULLY

17/06/2009 16:20:29: Backing up AQUATEST (full database) to:
17/06/2009 16:20:29: E:\SQLBackups\MEDSQLTEST\Databases\AQUATEST\FULL_AQUATEST_20090617_162029.sqb

17/06/2009 16:20:29: BACKUP DATABASE [AQUATEST] TO VIRTUAL_DEVICE = 'SQLBACKUP_B79E1721-5BED-4CBA-A5D7-C1FBBC3BE411', VIRTUAL_DEVICE = 'SQLBACKUP_B79E1721-5BED-4CBA-A5D7-C1FBBC3BE41101', VIRTUAL_DEVICE = 'SQLBACKUP_B79E1721-5BED-4CBA-A5D7-C1FBBC3BE41102'
WITH BUFFERCOUNT = 18, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (AQUATEST), 17/06/2009 16:20:29', DESCRIPTION = N'Backup on 17/06/2009 16:20:29 Server: MEDSQLTEST Database: AQUATEST', FORMAT

17/06/2009 16:21:30: Database size : 5.177 GB
17/06/2009 16:21:30: Compressed data size: 702.962 MB
17/06/2009 16:21:30: Compression rate : 86.74%

17/06/2009 16:21:30: Processed 579840 pages for database 'AQUATEST', file 'AQUASQL_MEDWAY_LIVE_Data' on file 1.
17/06/2009 16:21:30: Processed 1 pages for database 'AQUATEST', file 'AQUASQL_MEDWAY_LIVE_Log' on file 1.
17/06/2009 16:21:30: BACKUP DATABASE successfully processed 579841 pages in 60.668 seconds (78.295 MB/sec).
17/06/2009 16:21:30:
17/06/2009 16:21:30: Verifying files:
17/06/2009 16:21:30: E:\SQLBackups\MEDSQLTEST\Databases\AQUATEST\FULL_AQUATEST_20090617_162029.sqb
17/06/2009 16:21:30:
17/06/2009 16:21:57: The backup set is valid.
Andrew Hodge
0

Comments

1 comment

Sort by
  • mattchandler
    Hi Andrew,

    Thanks a lot for getting back to us,

    I believe you've reproduced a bug here that we've seen previously. Could you please try removing any old backup files (from SQL Backup 5.4 or earlier) from the folder you're backing up to, and then run the same command again. If I'm right, the error message should stop happening then.

    We have fixed this issue for the 6.0 release in our internal builds, so it shouldn't affect anyone when the final release comes out.
    mattchandler
    0

Add comment

Please sign in to leave a comment.