SqlDumpExceptionHandler Error Message In MS SQL Server 7.0

0 pts.
Tags:
Database
DB2
Desktops
Management
Microsoft Windows
Oracle
OS
Security
Servers
Software
SQL
SQL Server
Tech support
Updates from SearchSQLServer.com staff
I am trying to restore a database in MS SQL Server 7.0. I keep getting the following error message. Backup or restore operation terminating abnormally. SqlDumpExceptionHandler: Process 8 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. I searched on google and on Microsoft's Knowledge Base. Any reference to this above error states that it is a bug in SQL Server, but all references have something to do when querying the database, nothing about restoring a database causing this error. Are any of you familiar with this and what a fix could be?
ASKED: September 1, 2005  6:48 AM
UPDATED: September 1, 2005  9:39 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Error – c0000005 – access denied
For what ever reason at least part of the file you are trying to restore does NOT belong to the account you are using for the restore.
1 – is this a new instance of SQL server and you are transferring the database?
2 – is this a repaired instance where you added service pack or patches between making the backup and trying to restore it?
3 – In ‘enterprise manager’ is the database owner/login authorized as backup operator?

These are the 1st three ideas I thought of capable of causing this error. Collateral errors depend on what other tasks are running on the server when you attempt the restore.

Good luck.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Bkr0963c
    Thanks for your response. To answer your questions: 1. This is not a new instance of SQL. 2. I am restoring a backup file to the same machine that the database resides, just giving it a different name. 3. The account used to perform the restore has db_backupoperator checked for its role in this databse.
    0 pointsBadges:
    report
  • Bkr0963c
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/sqldumpexceptionhandler-error-message-in-ms-sql-... (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following