We have log shipping running between a production and DR server (it has been running for several months), and twice in the past week the restore job has hung with a wait type of PREEMPTIVE_OS_GETPROCADDRESS.

Are you able to shed some light on what these error messages mean and what may be the cause? Because the SQL Agent job is hanging, rather than failing, there are no error notifications, and we are therefore in a situation where our DR site is out of sync and we are unaware of it!

1. Close all GUI connections to the SQL Server.
2. Ensure that no SQL Backup jobs are in progress.
3. Stop the SQL Backup Agent Service, or disable the cluster resource if on a cluster.
4. On the SQL Server where the SQL Backup server components are installed, navigate to the installation directory. Defaults are:

5. In the folder you will find an existing SQBCoreService.exe and SQL BackupC.exe. Rename the existing files, for example to OLDSQBCoreService.exe and OLDSQLBackupC.exe.
6. Now copy in the files extracted from the downloaded zip.
7. Restart the SQL Backup agent service/cluster resource, and ensure that it starts successfully.
8. Perform a test backup to ensure that all is OK. Then test to see if the original error occurs. SQL Backup should now error out correctly and not become unresponsive.

We deployed the patch on Tuesday and our log shipping backup/restore processes have been running ok.

Last night there was a failure in the restore job, but this was handled and subsequent restore jobs have completed successfully. The same SQLVDI error messages are recorded in the windows event logs, so it seems likely this is the same error that was causing the jobs to hang previously.

Deploying the patch therefore seems to have resolved the issue with the jobs hanging.