Failed to get configuration from server
My backups ran successfully for months but now are failing with this error. From the log:
SQL Backup log file 7.0.0.597
-SQL "BACKUP LOG [TTC] TO DISK = '\\America\GPSQLBackup\PacioliBackups\TTC\Tlog\<TYPE>_<DATABASE>_<DATETIME YYYYmmddhhnnss>.sqb' WITH ERASEFILES = 1, PASSWORD = 'XXXXXXXXXX', DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COPYTO = '\\America\GPSQLBackup\PacioliBackups\TTC\LogCopy', KEYSIZE = 256, THREADCOUNT = 7 "
ERRORS AND WARNINGS
7/11/2012 3:00:00 AM: Backing up TTC (transaction log) to:
7/11/2012 3:00:00 AM: \\America\GPSQLBackup\PacioliBackups\TTC\Tlog\LOG_TTC_20120711030000.sqb
7/11/2012 3:00:01 AM: BACKUP LOG [TTC] TO VIRTUAL_DEVICE = 'SQLBACKUP_A67A25FA-5C24-45A8-A7D8-07BCF0A54F59', VIRTUAL_DEVICE = 'SQLBACKUP_A67A25FA-5C24-45A8-A7D8-07BCF0A54F5901', VIRTUAL_DEVICE = 'SQLBACKUP_A67A25FA-5C24-45A8-A7D8-07BCF0A54F5902', VIRTUAL_DEVICE = 'SQLBACKUP_A67A25FA-5C24-45A8-A7D8-07BCF0A54F5903', VIRTUAL_DEVICE = 'SQLBACKUP_A67A25FA-5C24-45A8-A7D8-07BCF0A54F5904', VIRTUAL_DEVICE = 'SQLBACKUP_A67A25FA-5C24-45A8-A7D8-07BCF0A54F5905', VIRTUAL_DEVICE = 'SQLBACKUP_A67A25FA-5C24-45A8-A7D8-07BCF0A54F5906' WITH BUFFERCOUNT = 28, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (TTC), 7/11/2012 3:00:00 AM', DESCRIPTION = N'Backup on 7/11/2012 3:00:00 AM Server: PACIOLI Database: TTC', FORMAT
7/11/2012 3:00:01 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: (-2147024888: )
SQL server IS running -- this is my production server and I would know if it were down!! I do have Admin server role. So what's up??
SQL Backup log file 7.0.0.597
-SQL "BACKUP LOG [TTC] TO DISK = '\\America\GPSQLBackup\PacioliBackups\TTC\Tlog\<TYPE>_<DATABASE>_<DATETIME YYYYmmddhhnnss>.sqb' WITH ERASEFILES = 1, PASSWORD = 'XXXXXXXXXX', DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COPYTO = '\\America\GPSQLBackup\PacioliBackups\TTC\LogCopy', KEYSIZE = 256, THREADCOUNT = 7 "
ERRORS AND WARNINGS
7/11/2012 3:00:00 AM: Backing up TTC (transaction log) to:
7/11/2012 3:00:00 AM: \\America\GPSQLBackup\PacioliBackups\TTC\Tlog\LOG_TTC_20120711030000.sqb
7/11/2012 3:00:01 AM: BACKUP LOG [TTC] TO VIRTUAL_DEVICE = 'SQLBACKUP_A67A25FA-5C24-45A8-A7D8-07BCF0A54F59', VIRTUAL_DEVICE = 'SQLBACKUP_A67A25FA-5C24-45A8-A7D8-07BCF0A54F5901', VIRTUAL_DEVICE = 'SQLBACKUP_A67A25FA-5C24-45A8-A7D8-07BCF0A54F5902', VIRTUAL_DEVICE = 'SQLBACKUP_A67A25FA-5C24-45A8-A7D8-07BCF0A54F5903', VIRTUAL_DEVICE = 'SQLBACKUP_A67A25FA-5C24-45A8-A7D8-07BCF0A54F5904', VIRTUAL_DEVICE = 'SQLBACKUP_A67A25FA-5C24-45A8-A7D8-07BCF0A54F5905', VIRTUAL_DEVICE = 'SQLBACKUP_A67A25FA-5C24-45A8-A7D8-07BCF0A54F5906' WITH BUFFERCOUNT = 28, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (TTC), 7/11/2012 3:00:00 AM', DESCRIPTION = N'Backup on 7/11/2012 3:00:00 AM Server: PACIOLI Database: TTC', FORMAT
7/11/2012 3:00:01 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: (-2147024888: )
SQL server IS running -- this is my production server and I would know if it were down!! I do have Admin server role. So what's up??
Margaret Norkett
Database Administrator
Commercial Foodservice Repair
Database Administrator
Commercial Foodservice Repair
Comments
Look here for answers http://www.red-gate.com/SupportCenter/C ... 0710000177
HTH
Chris
Database Administrator
Commercial Foodservice Repair
Thank you.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
Database Administrator
Commercial Foodservice Repair
ngWrapper.LogManager
#6:Failed to load assembly Microsoft.SqlServer.SqlEnum
Database Administrator
Commercial Foodservice Repair
You didn't mention the O/S or SQL version. This might help understand things a little better.
Chris
Database Administrator
Commercial Foodservice Repair
Is this 32 or 64 bit and how much memory does the server have and are you giving to SQL?
Chris
Database Administrator
Commercial Foodservice Repair
Database Administrator
Commercial Foodservice Repair
Red Gate SQLBackup uses the vas space in SQL which defaults to 256Mb in SQL2008R2. If this was changed you would see a line like this -g 400 in the SQL errorlog after lines like -l \DBMS\MSSQL.1\MSSQL\DATA\mastlog.ldf to indicate where the master db log is after the last SQL startup.
I am not currently using SQLBackup on any SQL2008R2 servers but saw this error many times in SQL2005 running on W2K3R2 SP2.
A -g can be added to the startup of SQL but it would need to be stopped and restarted for it to apply.
Chris
Database Administrator
Commercial Foodservice Repair
if you do then your problem could well be lack of contiguous memory in the vas.
Chris
Database Administrator
Commercial Foodservice Repair
In your case, the VDI is raising error 80070008, which is undocumented in the VDI specification. Hence, I can't tell exactly what went wrong. In most cases, SQL Server will add an entry to the Windows event log providing more details about the VDI error e.g.
You could also try looking in the SQL Server error log to see if any errors were recorded.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8