What do you need to do after doing an In-Place SQL upgrade?

st8floorsup · February 20, 2008 3:05PM

I have sqlbackup 5 installed on a SQL 2000EE instance and will be doing an In-Place upgrade to SQL2005EE. What needs to be done to get backups to work after upgrade?

petey · February 20, 2008 10:04PM

SQL Backup uses the same files for both SQL 2000 and SQL 2005. You should not have to change or reinstall anything after the upgrade, assuming no change in SQL Server instance names, though I would suggest restarting the SQL Backup Agent service after the upgrade.

st8floorsup · February 21, 2008 11:28AM

I tried restarting the service and it doesn't work. When I open the GUI it gives me a Connection Error: Could not load the DLL xp_sqlbackup.dll, or one of the DLLs it references. Reason: 126(The specified moidule could not be found.). The instance name has not changed, it is the local instance.

I dicided to reinstall it. It is working now.

petey · February 21, 2008 11:57AM

You are right, I was mistaken. You would have needed to copy the SQL Backup extended stored procedure library (xp_sqlbackup.dll) from the previous SQL 2000 Binn folder to the new SQL 2005 Binn folder. I had assumed that an in-place upgrade meant the same Binn folder would be used.

st8floorsup · February 21, 2008 12:01PM

Thanks for your reply.

What do you need to do after doing an In-Place SQL upgrade?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk