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
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:
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:
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