I made a backup database. The backup failed, with this error:
SQL Backup log file
14.12.2006 15:30:07: Backing up Bicom4_SC (full database) to: 
14.12.2006 15:30:07:   C:\aa\FULL_(local)_Bicom4_SC_20061214_153007.sqb

14.12.2006 15:30:07: BACKUP DATABASE [Bicom4_SC]  TO DISK = 'C:\aa\<AUTO>' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', VERIFY, COMPRESSION = 1

14.12.2006 15:30:22: Database size       : 527,313 MB
14.12.2006 15:30:22: Compressed data size: 88,681 MB
14.12.2006 15:30:22: Compression rate    : 83,18%

Processed 53176 pages for database 'Bicom4_SC', file 'BiCom4Prazna_dat' on file 1.
Processed 1 pages for database 'Bicom4_SC', file 'BiCom4Prazna_log' on file 1.
BACKUP DATABASE successfully processed 53177 pages in 13.615 seconds (31.995 MB/sec).
14.12.2006 15:30:23: Warning 445: OLEDB error running ExecFast command: The count of column names and source expressions do not match. [Column name count,Source expression count,,,,]

14.12.2006 15:30:23: 
14.12.2006 15:30:23: Validating files:
14.12.2006 15:30:23:   C:\aa\FULL_(local)_Bicom4_SC_20061214_153007.sqb
14.12.2006 15:30:23: 
14.12.2006 15:30:23: RESTORE VERIFYONLY FROM DISK = 'C:\aa\FULL_(local)_Bicom4_SC_20061214_153007.sqb' 

The backup set is valid.
14.12.2006 15:30:31: Validation of all backup files failed.

The backup files were created successfully on the given path, althou there was an error - validation. The failed backup was not recorded on history activity tab.

I tried to restore the last failed backup, and again i got error on screen:
... OLEDB error running ExecFast command: The count of column names and source expressions do not match. Column name count,Source expression count,,,, ...

Despite in the failures the database was successfully restored. I hope to give you a detailed memo of eror but when I look the Log file, no error was found!? Restore successfull. Here is the log file:
SQL Backup log file
14.12.2006 15:57:26: Restoring Bicom4_SC_R (database) from: 
14.12.2006 15:57:26:   C:\AA\FULL_(local)_Bicom4_SC_20061214_153007.sqb

14.12.2006 15:57:26: RESTORE DATABASE [Bicom4_SC_R]  FROM DISK = 'C:\AA\FULL_(local)_Bicom4_SC_20061214_153007.sqb'  WITH  RECOVERY, MOVE 'BiCom4Prazna_dat' TO 'C:\Data\SQL Server00\Bicom4_SC_R.mdf', MOVE 'BiCom4Prazna_log' TO 'C:\Data\SQL Server00\Bicom4_SC_R.ldf'

Processed 53176 pages for database 'Bicom4_SC_R', file 'BiCom4Prazna_dat' on file 1.
Processed 1 pages for database 'Bicom4_SC_R', file 'BiCom4Prazna_log' on file 1.
RESTORE DATABASE successfully processed 53177 pages in 28.501 seconds (15.284 MB/sec).
14.12.2006 15:58:33: SQL Backup process ended.

And again, restore was not record on history activity tab. Probably becouse restore was ended with 'failure', but this information was important just as the information about successfull operations.

Regards
Uros
Urosd
0

Comments

1 comment

  • James Moore
    Hi Uros,

    Thanks for the feedback,

    There is an issue with the service where by if your local number formatting uses a , rather than a . as the decimal point the service fails writing the activity history to our database and thus the backups and restores do not appear in the grid/timeline.

    This will be fixed in the final release. In the mean time you might be able to get around it by setting your number format to use . rather than , as a decimal separator.

    Sorry for any inconvience and thanks for letting us know.

    - James
    James Moore
    0

Add comment

Please sign in to leave a comment.