Knowledge Base

Cannot load xp_sqlbackup.dll

Category: Troubleshooting & error messages
Date: 13 Jul 2009
Product: SQL Backup
When a scheduled backup is performed, or a backup is performed using the SQL Backup extended stored procedure, the following error may occur:
Cannot load the DLL xp_sqlbackup.dll, or one of the DLLs it references.
Reason: 1114(A dynamic link library (DLL) initialization routine
failed.).

The old xp_sqlbackup.dll has not been freed for some reason.

The following procedure will require that the Microsoft SQL Server service be stopped for a very brief period of time, so you can delete the previous version xp_sqlbackup.dll file.

Please perform the following actions:

1. Open a new query windows in SQL Server Management Studio (SQL Server 2005) or Query Analyzer (SQL Server 2000)

2. Type the following:

DBCC xp_sqlbackup(FREE)

EXEC sp_dropextendedproc sqlbackup
EXEC sp_dropextendedproc sqbstatus
EXEC sp_dropextendedproc sqbutility
EXEC sp_dropextendedproc sqbmemory

3. Stop the SQL Server Service.

4. Find all previous versions of xp_sqlbackup on your system and remove them including the installation folder.

5. Find xp_sqlbackup.dll ( a copy can be found in the SQL Backup installation folder) and copy this to the SQL Server instance BINN folder.

6. Start the SQL Server Service.

7. Reinstall the SQL Backup server components.