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
psribeiro
0

Comments

1 comment

  • Brian Donahue
    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.