VDI Error 1010: Failed to get configuration from server

• 
  Hi Julian,
  
  Could you please check your log files and see if SQL Backup has written anything to them for that attempted backup - they are normally in C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance_name> unless the location has been changed in the tools->options menu.
  
  If you could either post the appropriate log file here or email it to me (james.moore >at< red-gate.com) then that would be great.
  
  Thanks,
  
  - James

  James Moore December 18, 2006 04:02

  - 0 +
• 
  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
  

  ---

  JulianKuiters December 18, 2006 17:32

  - 0 +
• 
  Hi Julian,
  Thankyou for posting and emailing the application logs.
  
  Unfortunately, SQL Server 2005 does not support the backing up or restoring of snapshots, such that SQL Backup likewise does not support this feature. As a result the error "SQL error 3002: Cannot BACKUP or RESTORE a database snapshot." was raised in the log.
  
  There is an issue in the user interface however as it should not be allowing you to perform a backup of a snapshot, and I have added a report so that the developers can hopefully look into this at some stage before the final release.
  
  Thanks,
  Jason

  Jason Cook December 19, 2006 09:41

  - 0 +
• 
  Thanks Jason.
  
  It would make more sense for the UI to not allow backups of snapshot databases.
  
  This issue came about because I'd setup a schedule of "user databases" on a server that incuded snapshot databases, so hopefully they would just be skipped during a "user databases" backup in final release.

  JulianKuiters December 19, 2006 18:34

  - 0 +

Add comment

Please sign in to leave a comment.