Competition: What’s your favorite Redgate tool? Enter now.

Differential creating VDI 1010 Error

malcolm.daughtreemalcolm.daughtree Posts: 16
edited February 18, 2008 10:22PM in SQL Backup Previous Versions
I have created a diff. backup and verify [multiple databases] schedule that creates a warning but appears to first fail giving VDI error 1010: Failed to get configuration from server and then proceed. There is a 30 second gap in the job log but then it seems to complete. Unfortunately this warning is emailed to the SQL DBA (me !! 8) at 12:02. I'm a little confused ! The end of the log says its valid but is it and how do I prevent the WARNING ?
Log output attached
2/19/2008 12:01:07 AM: Backing up PMDB (differential database) to:
2/19/2008 12:01:07 AM: G:\Backups\RedGate\Databasebackups\PMDB\DIFF_(local)_PMDB_20080219_000107.sqb

2/19/2008 12:01:07 AM: BACKUP DATABASE [PMDB] TO DISK = 'G:\Backups\RedGate\Databasebackups\<database>\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', DIFFERENTIAL, INIT, VERIFY, ERASEFILES_ATSTART = 7, MAILTO_ONERROR = '[email protected]', COMPRESSION = 1, THREADCOUNT = 3

2/19/2008 12:01:39 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.)
2/19/2008 12:01:42 AM: SQL error 3013: BACKUP DATABASE is terminating abnormally.
2/19/2008 12:01:42 AM:
2/19/2008 12:01:42 AM: Memory profile
2/19/2008 12:01:42 AM: Type Maximum Minimum Average Blk count Total
2/19/2008 12:01:42 AM:





2/19/2008 12:01:42 AM: Commit 38633472 4096 203384 8546 1738125312
2/19/2008 12:01:42 AM: Reserve 1044480 4096 16337 7709 125947904
2/19/2008 12:01:42 AM: Free 161632256 4096 1539917 184 283344896
2/19/2008 12:01:42 AM: Private 38633472 4096 115251 15704 1809903616
2/19/2008 12:01:42 AM: Mapped 1536000 4096 184661 48 8863744
2/19/2008 12:01:42 AM: Image 6156288 4096 90071 503 45305856
2/19/2008 12:01:42 AM:
2/19/2008 12:01:42 AM: Warning 300: Backup failed. Retry attempt: 1
2/19/2008 12:01:44 AM: BACKUP DATABASE [PMDB] TO DISK = 'G:\Backups\RedGate\Databasebackups\PMDB\DIFF_(local)_PMDB_20080219_000107.sqb' WITH NAME = 'Database (PMDB), 2/19/2008 12:01:07 AM', DESCRIPTION = 'Backup on 2/19/2008 12:01:07 AM Server: AUSSQL1 Database: PMDB', DIFFERENTIAL, INIT, VERIFY, ERASEFILES_ATSTART = 7, MAILTO_ONERROR = '[email protected]', COMPRESSION = 1, THREADCOUNT = 3

2/19/2008 12:01:45 AM: Backup data size : 2.563 MB
2/19/2008 12:01:45 AM: Compressed data size: 187.500 KB
2/19/2008 12:01:45 AM: Compression rate : 92.85%

Processed 88 pages for database 'PMDB', file 'PMDB_Data' on file 1.
Processed 1 pages for database 'PMDB', file 'PMDB_Log' on file 1.
BACKUP DATABASE WITH DIFFERENTIAL successfully processed 89 pages in 0.049 seconds (14.733 MB/sec).
2/19/2008 12:01:45 AM:
2/19/2008 12:01:45 AM: Validating files:
2/19/2008 12:01:45 AM: G:\Backups\RedGate\Databasebackups\PMDB\DIFF_(local)_PMDB_20080219_000107.sqb
2/19/2008 12:01:45 AM:
2/19/2008 12:01:45 AM: RESTORE VERIFYONLY FROM DISK = 'G:\Backups\RedGate\Databasebackups\PMDB\DIFF_(local)_PMDB_20080219_000107.sqb'

The backup set is valid.

Regards
CodeOn ;-)

Comments

  • peteypetey Posts: 2,358 New member
    Most likely cause was that there was a process blocking the backup from being performed between 12:01:09 to 12:01:39. Could you please check if that is indeed the case?

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.