Comments
Sort by recent activity
My experience was that upgrading from 5.4 to 6.1 worked without any problems for multiple SQL Server 2000 and 2005 instances. The only problem I had was upgrading the repository server (SQL Server 2005). The failure pattern was identical to fatherjack's original post (failing on: "The SQL Backup extended stored procedure DLL version is 5.4.0.55, and 6.0.0.412 was expected.")
After 5 or 6 unsuccessful attempts from the client, I switched to manual upgrade on the repository server after first stopping the SQL Backup service. Even that failed, but gave a somewhat different error msg: "The extended stored procedure file (xp_sqlbackup.dll) that exists is an earlier version. Check that you have rights to overwrite the existing file,and run the installation again."
It was no surprise to find that the DLL was locked (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_sqlbackup.dll).
To successfully upgrade the repository server, I had to unlock the DLL (using unlocker), run SQBServerSetup again, delete and re-register the two extended stored procs:
sp_addextendedproc 'sqlbackup','xp_sqlbackup.dll'
sp_addextendedproc 'sqbutility','xp_sqlbackup.dll'
and restart the SQL Server instance.
By the way, the repository runs in a SS 2005 default instance on the same server with a SS 2000 named instance. I did not have any problems upgrading the SS 2000 named instance prior to the above adventures with the repository instance. / comments
My experience was that upgrading from 5.4 to 6.1 worked without any problems for multiple SQL Server 2000 and 2005 instances. The only problem I had was upgrading the repository server (SQL Server ...
Thanks. Refresh is indeed enabled at the server level. I just started using SQL Backup a couple days ago. Also I just read a post about why Refresh function was recently disabled at the database level. / comments
Thanks. Refresh is indeed enabled at the server level. I just started using SQL Backup a couple days ago. Also I just read a post about why Refresh function was recently disabled at the database le...
Has Red-Gate looked into performance tuning sqbdata? Activity History still takes forever to populate--GT 5 minutes for us on a server that contains 1 year of history.
Customers should not be forced to delete important backup history as a workaround for a poorly performing SQL Backup process. / comments
Has Red-Gate looked into performance tuning sqbdata? Activity History still takes forever to populate--GT 5 minutes for us on a server that contains 1 year of history.
Customers should not be force...