Incorrect installation

psribeiropsribeiro Posts: 10
edited August 22, 2006 11:43AM in SQL Backup Previous Versions
Hi HJoyce !

I had some problems with my version of SQL Backup (4.1) ; the error was like that ...

ODBC: Msg 0, Level 10, State 1
Execute interrupted by exception: Access violation at address 096782C3 in module 'xp_sqlbackup.dll'.
Write of address 00000000

Well, I decided to write you but before writint I noticed that version 4.6 was ready for download, then I did the download and installed this version. The problem is that when I start SQL Backup it shows at the bottom left "SQL Backup incorrectly installed", and the error with access violation persists.

As I don´t have enought space for backups without compression, could you please respond as soon as possible?

Thanks
Paulo Ribeiro
Livraria e Papelaria Saraiva S/A
Sao Paulo - Brazil

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    You may need to force SQL Backup off of the server:

    exec sp_dropextendedproc 'sqlbackup'
    DBCC xp_sqlbackup (FREE)

    Manually copy the xp_sqlbackup.dll to the sql Server's BINN folder (c:\Program files\microsoft sql server\80\binn)

    exec sp_addextendedproc 'sqbutility', 'xp_sqlbackup.dll'
    exec sp_addextendedproc 'sqbmemory', 'xp_sqlbackup.dll'
    exec sp_addextendedproc 'sqbstatus', 'xp_sqlbackup.dll'
    exec sp_addextendedproc 'sqlbackup', 'xp_sqlbackup.dll'

    Hopefully at this point SQL Backup will work okay.
Sign In or Register to comment.