Activity overview
Latest activity by johnzabroski
This problem has been solved by uninstalling Redgate, downloading a new installer, and then reinstalling everything Redgate-related on the server where the restore job was failing. / comments
This problem has been solved by uninstalling Redgate, downloading a new installer, and then reinstalling everything Redgate-related on the server where the restore job was failing.
The article can be improved further. It states:
When SQL Backup encounters a critical error, it generates a stack trace to a log file named SQBCoreService_bugreport.txt.
On my machine the file is titled SQBCoreService_(LOCAL)_bugreport.txt
It might also make sense to break out the differences across OS versions in a table, rather than a paragraph. It is easier to digest that way IMHO. / comments
The article can be improved further. It states:
When SQL Backup encounters a critical error, it generates a stack trace to a log file named SQBCoreService_bugreport.txt.
On my machine the file ...
I am using SQL Backup6 with Windows Server 2008 R2 Standard and SQL Server 2008 Standard, and don't know where the equivalent folder mentioned in your link is (I cannot find "\All Users\Application Data\Red Gate\SQL Backup\Log").
I tried:
EXEC master..sqbutility 9997
and the result was:
result
------
NULL
...with no output messages.
I did this while the restore job was hung in its usual place.
Afterward I used the file system search to find the file, and it still did not show up. This leads me to believe that SQL Backup 6 doesn't have permission to write to the folder, and maybe is trying to write to a folder name that doesn't exist on Windows Server 2008 R2. Or SQL Backup 6 is smart enough to know the directory structure of all Windows OSes using some environment variables I don't know about, and then the issue would simply be fixing permissions.
Edit:
I found a post on the MSDN Forums explaining that Windows Server 2008 R2 hides the ability to unhide files, and that you need to press the 'ALT' key once while focused on the Windows Explorer window. This will cause a standard menu to appear below the backward-forward-enter-url widget.
This helped reveal that '\All Users\Application Data\' on Windows Server 2008 R2 is actually 'Users\Default\AppData'. I'll examine the permissions and update again. / comments
I am using SQL Backup6 with Windows Server 2008 R2 Standard and SQL Server 2008 Standard, and don't know where the equivalent folder mentioned in your link is (I cannot find "\All Users\Application...
exec dbo.sqbstatus 1 -- 0 Processed (Bytes) after hours
SQL Server 2008, brand new install.
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 (Byt...