xp_sqlbackup.dll reports Access violation
tpirkle1
Posts: 3 Bronze 2
The following script fails repeatedly in SQL Query Analyzer. I plan to script a SQL backup job for more than 200 client databases if I can get this tool working. I was able to get it working with one database, so I scripted jobs similar to the following for each client database. What am I doing wrong?
master..sqlbackup '-SQL "BACKUP DATABASE [TEST_DB] TO DISK = ''E:\BACKUPS\TEST_DB.sqb'' WITH NAME = ''Database (TEST_DB)'', DESCRIPTION = ''TEST_DB'', INIT, VERIFY, COMPRESSION = 1" -U sa -P <LOGINPASSWORD>XXXXXXXXXX</LOGINPASSWORD>'
Results in Query Analyzer:
ODBC: Msg 0, Level 10, State 1
Execute interrupted by exception: Access violation at address 09262140 in module 'xp_sqlbackup.dll'. Write of address 00015010
master..sqlbackup '-SQL "BACKUP DATABASE [TEST_DB] TO DISK = ''E:\BACKUPS\TEST_DB.sqb'' WITH NAME = ''Database (TEST_DB)'', DESCRIPTION = ''TEST_DB'', INIT, VERIFY, COMPRESSION = 1" -U sa -P <LOGINPASSWORD>XXXXXXXXXX</LOGINPASSWORD>'
Results in Query Analyzer:
ODBC: Msg 0, Level 10, State 1
Execute interrupted by exception: Access violation at address 09262140 in module 'xp_sqlbackup.dll'. Write of address 00015010
Comments
master..sqlbackup '-SQL "BACKUP DATABASE [TEST_DB] TO DISK = ''E:\BACKUPS\TEST_DB.sqb'' WITH INIT, COMPRESSION = 1" -U sa -P <actual password>
then add on the other options until it fails? Let us know at which point it fails. Thanks.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
master..sqlbackup '-SQL "BACKUP DATABASE [TEST_DB] TO DISK = ''E:\TEST_DB.sqb'' WITH INIT, COMPRESSION = 1" -U sa -P PASSWORD'
ODBC: Msg 0, Level 10, State 1
Execute interrupted by exception: Access violation at address 09261E1B in module 'xp_sqlbackup.dll'. Read of address 00015000