exec dbo.sqbstatus 1 -- 0 Processed (Bytes) after hours
Trying to restore from SQL Server 2005 database backup w/ Redgate SQL Backup.
exec dbo.sqbstatus 1
-- shows that the database I am restoring has 0 Processed (Bytes) after hours spent in Restore mode
SQL Server Management Studio Activity Monitor reveals I have a process blocking SQL Backup from continuing: PREEMPTIVE_OS_GETPROCADDRESS.
Searching for that, I found this article: http://blogs.msdn.com/b/psssql/archive/ ... ation.aspx
According to that article, that process is a figment of SQL Server 2008's imagination (if I understand it).
I tried the DBCC TRACEON commands for logging restore-related stuff, and they print nothing. The issue seems to be that when TSQL processes the SQL Backup command, the associated DLL entry point gets hung while searching for the DLL and/or something along that line of thought.
This article: http://social.msdn.microsoft.com/Forums ... a2da662f4b says that I might either have a misconfigured database driver or have not registered a DLL.
What DLLs should I have registered?
Any other debugging tips? I basically have already browsed the whole Redgate SQL Backup FAQ searching for answers and/or clues (which is how I found out the DBCC TRACEON trick). Maybe I overlooked one?