SQL Backup just stopped working today...

designtoscanodesigntoscano Posts: 10
edited June 1, 2006 8:19PM in SQL Backup Previous Versions
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?
· Share on Twitter

Comments

  • Neil DavidsonNeil Davidson Posts: 281
    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
    Red Gate Software Ltd
    · Share on Twitter
  • Neil DavidsonNeil Davidson Posts: 281
    @version will tell you this).
    - Neil Davidson
    Red Gate Software Ltd
    · Share on Twitter
  • designtoscanodesigntoscano Posts: 10
    A reinstall of the server components seems to have solved the problem.
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    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).
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • jlehewjlehew Posts: 6
    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
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    Please do upgrade to version 4.2. See http://www.red-gate.com/messageboard/viewtopic.php?t=2312
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • jlehewjlehew Posts: 6
    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
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.