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

Activity overview

Latest activity by JulianKuiters

Groups should be collapsed at startup
It would be nice if the server groups were collapsed (not showing individual servers) when SQL Backup application is started. When there's hundreds of servers, it just cripples the apps start up ti...
1 follower 1 comment 0 votes
Add 'Reports' to the server context menu
It would be nice to be able to right click a server in the scheduler and choose 'Reports' -> 'Failed backups', etc. This should bring up the Reporting dialog, with the report scope set to single s...
1 follower 1 comment 0 votes
Cannot restore DIFF with a new name
Theres an issue with the restore wizard in that you can't restore an existing database with a new name using a full and diff backup. Steps to reproduce : 0. Click Restore... in the main window 1. R...
3 followers 3 comments 0 votes
"Save As" on script tabs
On the last page of the restore wizard there is a Summary and Script tab. Please add a "Save as" button so I don't have to copy and paste the script into another program just to save it. Maybe a "C...
0 followers 0 comments 0 votes
No "Back" in restore wizard after failure
After stepping through the restore wizard, if you recieve an error message after clicking Finish, you have to start the wizard from scratch. It would be better if you could click "Back" to change s...
0 followers 0 comments 0 votes
Email Notification reports SUCCESS when some backups fail
James, I've forwarded a email notification log to you. (Following on from the VDI Error 1010 problem) I've found that despite failing to backup a number of databases, the email notification is alwa...
0 followers 0 comments 0 votes
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