SqlDumpExceptionHandler Error Message In MS SQL Server 7.0
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
September 1, 2005 6:48 AM
UPDATED:
September 1, 2005 9:39 AM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
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.