Please need Help
newbie
Posts: 5
Hi i'm new to this forum. We are using the "sql backup PRO" for our backups and restores.We have a log restore set to run every 30 minutes and its been failing with the following errors. Can someone please advice me?
12/15/2016 10:33:01 AM: Restoring mydb (transaction logs) from:
12/15/2016 10:33:01 AM: \myserver1LogShippingmyserver2LOG_pkcrft_20161215101500.sqb
12/15/2016 10:33:02 AM: RESTORE LOG [mydb] FROM VIRTUAL_DEVICE = 'SQLBACKUP_4B4E6B6D-A1A4-4C96-B1E4-D66A41E51D31', VIRTUAL_DEVICE = 'SQLBACKUP_4B4E6B6D-A1A4-4C96-B1E4-D66A41E51D3101', VIRTUAL_DEVICE = 'SQLBACKUP_4B4E6B6D-A1A4-4C96-B1E4-D66A41E51D3102', VIRTUAL_DEVICE = 'SQLBACKUP_4B4E6B6D-A1A4-4C96-B1E4-D66A41E51D3103' WITH BUFFERCOUNT = 24, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , NORECOVERY
12/15/2016 10:33:32 AM: VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. Check that the SQL Server instance is running, that you have the SQL Server System Administrator server role; and that no other processes are blocking the backup or restore process; or try increasing the value of the VDITimeout registry setting in HKEY_LOCAL_MACHINESOFTWARERed GateSQL BackupBackupSettingsGlobal[InstanceName]
12/15/2016 10:33:32 AM: Also check that the database is not currently in use.
12/15/2016 10:33:01 AM: Restoring mydb (transaction logs) from:
12/15/2016 10:33:01 AM: \myserver1LogShippingmyserver2LOG_pkcrft_20161215101500.sqb
12/15/2016 10:33:02 AM: RESTORE LOG [mydb] FROM VIRTUAL_DEVICE = 'SQLBACKUP_4B4E6B6D-A1A4-4C96-B1E4-D66A41E51D31', VIRTUAL_DEVICE = 'SQLBACKUP_4B4E6B6D-A1A4-4C96-B1E4-D66A41E51D3101', VIRTUAL_DEVICE = 'SQLBACKUP_4B4E6B6D-A1A4-4C96-B1E4-D66A41E51D3102', VIRTUAL_DEVICE = 'SQLBACKUP_4B4E6B6D-A1A4-4C96-B1E4-D66A41E51D3103' WITH BUFFERCOUNT = 24, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , NORECOVERY
12/15/2016 10:33:32 AM: VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. Check that the SQL Server instance is running, that you have the SQL Server System Administrator server role; and that no other processes are blocking the backup or restore process; or try increasing the value of the VDITimeout registry setting in HKEY_LOCAL_MACHINESOFTWARERed GateSQL BackupBackupSettingsGlobal[InstanceName]
12/15/2016 10:33:32 AM: Also check that the database is not currently in use.
Comments
Another option is to use the DISCONNECT_EXISTING option in SQL Backup, so that it attempts to close all connections prior to running the restore e.g.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8