How can we help you today? How can we help you today?
JulianKuiters
Hi James I've just emailed you two log files: a FULL backup log; and a DIFF backup log. As an example from the logs, below there some of the log for a full backup of AABF01 database, followed by the failed backup for AABF01_SS which is the snapshot of AABF01. 19/12/2006 6:00:00 AM: Backing up AABF01 (full database) to: 19/12/2006 6:00:00 AM: C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\AABF01\FULL_(local)_AABF01_20061219_060000.sqb 19/12/2006 6:00:00 AM: BACKUP DATABASE [AABF01] TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\<DATABASE>\<AUTO>' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', VERIFY, ERASEFILES_ATSTART = 1, COMPRESSION = 2, THREADS = 2 19/12/2006 6:00:02 AM: Database size : 43.117 MB 19/12/2006 6:00:02 AM: Compressed data size: 9.563 MB 19/12/2006 6:00:02 AM: Compression rate : 77.82% Processed 4528 pages for database 'AABF01', file 'AABF01' on file 1. Processed 1 pages for database 'AABF01', file 'AABF01_log' on file 1. BACKUP DATABASE successfully processed 4529 pages in 1.032 seconds (35.951 MB/sec). 19/12/2006 6:00:03 AM: 19/12/2006 6:00:03 AM: Validating files: 19/12/2006 6:00:03 AM: C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\AABF01\FULL_(local)_AABF01_20061219_060000.sqb 19/12/2006 6:00:03 AM: 19/12/2006 6:00:03 AM: RESTORE VERIFYONLY FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\AABF01\FULL_(local)_AABF01_20061219_060000.sqb' The backup set on file 1 is valid. 19/12/2006 6:00:04 AM: Backing up AABF01_SS (full database) to: 19/12/2006 6:00:04 AM: C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\AABF01_SS\FULL_(local)_AABF01_SS_20061219_060004.sqb 19/12/2006 6:00:04 AM: BACKUP DATABASE [AABF01_SS] TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\<DATABASE>\<AUTO>' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', VERIFY, ERASEFILES_ATSTART = 1, COMPRESSION = 2, THREADS = 2 19/12/2006 6:00:19 AM: VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had elapsed.) 19/12/2006 6:00:19 AM: SQL error 3013: BACKUP DATABASE is terminating abnormally. 19/12/2006 6:00:19 AM: SQL error 3002: Cannot BACKUP or RESTORE a database snapshot. 19/12/2006 6:00:19 AM: 19/12/2006 6:00:19 AM: Memory profile 19/12/2006 6:00:19 AM: Type Maximum Minimum Average Blk count Total 19/12/2006 6:00:19 AM: 19/12/2006 6:00:19 AM: Commit 300154880 4096 585007 716 418865152 19/12/2006 6:00:19 AM: Reserve 497025024 4096 13609200 102 1388138496 19/12/2006 6:00:19 AM: Free 105103360 4096 2127590 160 340414464 19/12/2006 6:00:19 AM: Private 497025024 4096 4454742 389 1732894720 19/12/2006 6:00:19 AM: Mapped 1060864 4096 114202 59 6737920 19/12/2006 6:00:19 AM: Image 24731648 4096 182083 370 67371008 19/12/2006 6:00:19 AM: 19/12/2006 6:00:19 AM: Warning 300: Backup failed. Retry attempt: 1 19/12/2006 6:00:21 AM: BACKUP DATABASE [AABF01_SS] TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\AABF01_SS\FULL_(local)_AABF01_SS_20061219_060004.sqb' WITH NAME = 'Database (AABF01_SS), 19/12/2006 6:00:04 AM', DESCRIPTION = 'Backup on 19/12/2006 6:00:04 AM Server: C-JKUITERS Database: AABF01_SS', INIT, VERIFY, ERASEFILES_ATSTART = 1, COMPRESSION = 2, THREADS = 2 19/12/2006 6:00:21 AM: 19/12/2006 6:00:21 AM: Warning 300: Backup failed. Retry attempt: 2 19/12/2006 6:00:23 AM: BACKUP DATABASE [AABF01_SS] TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\AABF01_SS\FULL_(local)_AABF01_SS_20061219_060004.sqb' WITH NAME = 'Database (AABF01_SS), 19/12/2006 6:00:04 AM', DESCRIPTION = 'Backup on 19/12/2006 6:00:04 AM Server: C-JKUITERS Database: AABF01_SS', INIT, VERIFY, ERASEFILES_ATSTART = 1, COMPRESSION = 2, THREADS = 2 19/12/2006 6:00:23 AM: 19/12/2006 6:00:23 AM: Warning 300: Backup failed. Retry attempt: 3 19/12/2006 6:00:25 AM: BACKUP DATABASE [AABF01_SS] TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\AABF01_SS\FULL_(local)_AABF01_SS_20061219_060004.sqb' WITH NAME = 'Database (AABF01_SS), 19/12/2006 6:00:04 AM', DESCRIPTION = 'Backup on 19/12/2006 6:00:04 AM Server: C-JKUITERS Database: AABF01_SS', INIT, VERIFY, ERASEFILES_ATSTART = 1, COMPRESSION = 2, THREADS = 2 19/12/2006 6:00:25 AM: 19/12/2006 6:00:25 AM: Warning 300: Backup failed. Retry attempt: 4 19/12/2006 6:00:27 AM: BACKUP DATABASE [AABF01_SS] TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\AABF01_SS\FULL_(local)_AABF01_SS_20061219_060004.sqb' WITH NAME = 'Database (AABF01_SS), 19/12/2006 6:00:04 AM', DESCRIPTION = 'Backup on 19/12/2006 6:00:04 AM Server: C-JKUITERS Database: AABF01_SS', INIT, VERIFY, ERASEFILES_ATSTART = 1, COMPRESSION = 2, THREADS = 2 / comments
Hi James I've just emailed you two log files: a FULL backup log; and a DIFF backup log. As an example from the logs, below there some of the log for a full backup of AABF01 database, followed by th...
0 votes