How can we help you today? How can we help you today?

xp_sqlbackup.dll reports Access violation

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

Comments

2 comments

Sort by
  • petey
    Could you pls try running the command in Query Analyzer, but start from a basic command e.g

    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.
    petey
    0
  • tpirkle1
    I ran the following script in Query Analyzer and got the following error. I'm able to backup ALL of my client databases using the command line utility. I created a batch file and put them all in there and it works fine. I'd rather use a SQL job, but at least it's working for me.

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

Add comment

Please sign in to leave a comment.