Upgrade 5.2 to 5.3
krhyll
Posts: 6
The server components upgrades correctly for two databases, and fails for two. Check installed versions fails as shown below.
How do I manually upgrade server component?
Kristian
Server Component Installation - Failed
====================================================================
Copy SQBServerSetup.exe to server - Successful
This operation completed successfully.
Run setup on server - Successful
This operation completed successfully.
Start SQL Backup Agent service - Successful
This operation completed successfully.
Check installed versions - Failed
The SQL Backup extended stored procedure DLL version is 5.2.0.2825, and 5.3.0.178 was expected.
Check SQLBackup extended stored procedures - Successful
This operation completed successfully.
Delete setup file from server - Successful
This operation completed successfully.
Updating SQL Server information - Successful
This operation completed successfully.
How do I manually upgrade server component?
Kristian
Server Component Installation - Failed
====================================================================
Copy SQBServerSetup.exe to server - Successful
This operation completed successfully.
Run setup on server - Successful
This operation completed successfully.
Start SQL Backup Agent service - Successful
This operation completed successfully.
Check installed versions - Failed
The SQL Backup extended stored procedure DLL version is 5.2.0.2825, and 5.3.0.178 was expected.
Check SQLBackup extended stored procedures - Successful
This operation completed successfully.
Delete setup file from server - Successful
This operation completed successfully.
Updating SQL Server information - Successful
This operation completed successfully.
Comments
This issue is normally caused by SQL Server not releasing the xp_sqlbackup.dll located in the Server's Binn for upgrade.
To manually upgrade the xp_sqlbackup.dll, please follow the steps below:
Open a new query window and excute the following:
DBCC xp_sqlbackup(FREE)
sp_dropextendedproc sqlbackup, ‘xp_sqlbackup.dll’
sp_dropextendedproc sqbstatus, ‘xp_sqlbackup.dll’
sp_dropextendedproc sqbutility, ‘xp_sqlbackup.dll’
sp_dropextendedproc sqbmemory, ‘xp_sqlbackup.dll’
sp_dropextendedproc sqbdata, ‘xp_sqlbackup.dll’
sp_dropextendedproc sqbdir, ‘xp_sqlbackup.dll’
sp_dropextendedproc sqbtest, ‘xp_sqlbackup.dll’
sp_dropextendedproc sqbtestcancel, ‘xp_sqlbackup.dll’
sp_dropextendedproc sqbteststatus, ‘xp_sqlbackup.dll’
Stop the SQL Server Service.
Find all previous versions of xp_sqlbackup on your system.
Find the Version 5.3 of xp_sqlbackup.dll ( a copy can be found in the SQL Backup 5.3 installation folder) and copy this to the SQL Server instance BINN folder.
Start the SQL Server Service.
sp_addextendedproc sqlbackup, ‘xp_sqlbackup.dll’
sp_addextendedproc sqbstatus, ‘xp_sqlbackup.dll’
sp_addextendedproc sqbutility, ‘xp_sqlbackup.dll’
sp_addextendedproc sqbmemory, ‘xp_sqlbackup.dll’
sp_addextendedproc sqbdata, ‘xp_sqlbackup.dll’
sp_addextendedproc sqbdir, ‘xp_sqlbackup.dll’
sp_addextendedproc sqbtest, ‘xp_sqlbackup.dll’
sp_addextendedproc sqbtestcancel, ‘xp_sqlbackup.dll’
sp_addextendedproc sqbteststatus, ‘xp_sqlbackup.dll’
Normally the above action resolves this upgrading issue.
Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-Mail: Support@red-gate.com
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
Before I read your response I tried:
- stop backup agent
- run SQBServerSetup.EXE manually
Seems it also solved the problem with xp_sqlbackup.dll.
But running backup I receive errors like:
2008-02-27 22:04:23.53 Backup BACKUP failed to complete the command BACKUP DATABASE NordlandTest. Check the backup application log for detailed messages.
2008-02-27 22:04:32.06 Backup Error: 3201, Severity: 16, State: 7.
2008-02-27 22:04:32.06 Backup Cannot open backup device 'SQLBACKUP_9DCDA396-4890-4A20-AB5F-8D3808BCE491'. Operating system error 0x80070002(The system cannot find the file specified.).
2008-02-27 22:04:32.06 Backup Error: 3041, Severity: 16, State: 1.
2008-02-27 22:04:32.06 Backup BACKUP failed to complete the command BACKUP DATABASE model. Check the backup application log for detailed messages.
Do you immediately understand the problem? The backups stopped working 10 days ago, not sure why. Any hints?
Kristian