Options
Incorrect installation
psribeiro
Posts: 10
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
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
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.