What are the challenges you face when working across database platforms? Take the survey
Options

xp_sqlbackup.dll access violation on backup

amillisamillis Posts: 7
edited April 12, 2006 11:04PM in SQL Backup Previous Versions
We just purchased sqlbackup 4.1 yesterday and it was working well.

After about 12 hours of backups, I am getting this on the server doing the backups on every backup, data or log:
ODBC: Msg 0, Level 10, State 1
Execute interrupted by exception: Access violation at address 09B77F65 in module 'xp_sqlbackup.dll'.  Read of address FFFFFFFC

Connecting via the SQL Backup GUI give sthe same message.

We are backing up 10 databases, ranging in size from 50meg to 80gb. At the time, only 5 had scheduled log dumps. I had manually dumped full dumps about 6 hours before the dll started failing. The log dumps are happening every 5 minutes, each happening in a separate job (so at the time this started failing, there were 5 sqlbackup commands doing a Log dump simultaneously). They all appear to have stopped working at the same time (4:20am was the last successful dump for all 5 that were enabled). The DB's would have had little changing in them around this time, dumps would have been around 3-10kb with the lowest level compression.

I have attempted restarting the SQL Backup Agent service with no change.

Running a
dbcc xp_sqlbackup(FREE)
completes quickly without errors.

The syntax in the backup log job:
DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-sql "BACKUP LOG [DATABASENAME]
 TO DISK = ''S:\redgate_logship\DATABASENAME\LOG__DATABASENAME_<DATETIME yyyymmdd_hhnnss>.sqb''
 WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'',
 COPYTO = "\\10.0.0.206\redgate_logship\DATABASENAME",
 COMPRESSION = 1, THREADS = 1"', @exitcode OUTPUT, @sqlerrorcode OUTPUT

(10.0.0.206 is a crossover link on a gig connection to the secondary)
I saw a few posts about copyto possibly being broken, removing it doesn't allow the command to run (though I will remove it after this is working again and use a file system copy).
Edit: I dont know if the copyto statement is really the issue here since we aren't getting the local backup, the access violation error occurs immediately on running the sqlbackup command.

I am unable to restart this SQL server outside of weekly maintenance windows so I have not been able to see if this fixes it (rebooting the server would be similar). Since this was my initial deployment, my secondary is not viable to be brought online either.

System info:
Windows 2003 Server SP1
Quad P4 Xeon 3.2GHz
4gb Ram
SQL 2000 SP4 (8.00.2039)
RedGate SQL Backup 4.1.0.207 - Standard (downloaded yesterday)



Should I not be doing simultaneous backups?
Should I avoid using copyto for now (only the copyto is going across a crossover cable network)?
Should I avoid doing simultaneous restores on my secondary (not part of this problem, the secondary is fine that I can see)?

Comments

Sign In or Register to comment.