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

SQL Backup just stopped working today...

Here's the error I get:

Stored function 'sqbutility' in the library 'xp_sqlbackup.dll' generated an access violation.

Nothing has changed about the program, and it's been running fine for 6 weeks. When I right-click and try to connect, the right-hand pane populates with jobs, but then they immediately disappear and the connection is lost. What's goin on?
designtoscano
0

Comments

8 comments

Sort by
  • Neil Davidson
    Can you tell me exactly what the error message is please? There should be some numbers in there.

    Also, can you tell me what the value of the following registry keys is please:

    HKEY_CLASSES_ROOT\CLSID\{40700425-0080-11d2-851f-00c04fc21759}\InprocServer32 \ThreadingModel

    HKEY_CLASSES_ROOT\CLSID\{b5e7a132-a7bd-11d1-84c2-00c04fc21759}\InprocServer32 \ThreadingModel
    Neil Davidson
    0
  • Neil Davidson
    @version will tell you this).
    Neil Davidson
    0
  • designtoscano
    A reinstall of the server components seems to have solved the problem.
    designtoscano
    0
  • petey
    I would suggest writing to support@red-gate.com, requesting for a patch to xp_sqlbackup.dll. Provide them the version of the DLL that you are currently using (simply run sqlbackup in Query Analyzer, note down the column name).
    petey
    0
  • jlehew
    I sent this to support@red-gate as well...

    I have RedGate v4.1 installed on a cluster and it has been working fine for 1-2 months but for some reason it failed today.

    Here is the error message from the backup job in SqlServer:

    Job 'Translink Full Daily Backup' : Step 1, 'Step 1' : Began Executing 2006-06-01 07:00:10
    Execute interrupted by exception: Access violation at address 146B7F6B in module 'xp_sqlbackup.dll'. Write of address 00270FFC [SQLSTATE 01000]
    Msg 0, Sev 20: Stored function 'sqlbackup' in the library 'xp_sqlbackup.dll' generated an access violation. SQL Server is terminating process 76. [SQLSTATE HY000]

    Here is the message in the lower left hand corner of SQLBack:

    Execute interrupted by exception: Access violation at address 146B7F9B in module 'xp_sqlbackup.dll'. Write of address 00000014
    6/1/2006 9:44:47 AM

    Here is my version info:
    Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
    May 31 2003 16:08:15
    Copyright (c) 1988-2003 Microsoft Corporation
    Enterprise Edition on Windows NT 5.2 (Build 3790: )

    Here is the info in these keys:
    HKEY_CLASSES_ROOT\CLSID\{40700425-0080-11d2-851f-00c04fc21759}\InprocServer32 \ThreadingModel
    BOTH

    HKEY_CLASSES_ROOT\CLSID\{b5e7a132-a7bd-11d1-84c2-00c04fc21759}\InprocServer32 \ThreadingModel
    BOTH
    jlehew
    0
  • petey
    Please do upgrade to version 4.2. See http://www.red-gate.com/messageboard/viewtopic.php?t=2312
    petey
    0
  • jlehew
    Is your recommendation based on knowledge that v4.2 fixes this specific issue or is it the standard recommendation to upgrade to the latest version and see if that fixes it.

    Regards,
    John
    jlehew
    0
  • petey
    4.2 fixes this specific issue. The problem lies with the xproc, which has been busted. Your server would be a multi-processor box, or a single processor with HyperThreading enabled, and you must have ran 2 or more backups simultaneously before the error started appearing.
    petey
    0

Add comment

Please sign in to leave a comment.